...
This website is auto-updated by the FAA every Monday morning. All record layouts are identical going back to around 2010 - not a problem, we already have the data going back to about 1974.
Each FAA datafile data file is suffixed with either
'a' - Commercial Aviation - or -
'g' - General Aviation.
However, this distinction has no relevance to the upload procedure. We consolidate all the data and process it as one batch.
Additionally, we only import pure TEXT data. We’re not importing photographs or documents during this process. Only TC data from Canadian submitters has photos, attachments, supplemental text etc . .
The FAA accepts SDR reports in a "Preliminary" format. This means it can often take months/years for a given report to finally appear on the FAA ftp website, until such time as the report has been marked "reviewed" by a Technical inspector. ( They frequently contact the submitter with supplemental questions, and that exchange can take an extended period )
...