Airbus SB A300-53-6177
Service difficulty reports that cite it · 20
Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.
Query with SQL
duckdb -csv -c "SELECT s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id
WHERE c.document_id = 'airbus/a300-53-6177' AND c.record_type = 'faa_service_difficulty_report'
GROUP BY ALL
ORDER BY max(c.record_date) DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions, bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id WHERE c.document_id = 'airbus/a300-53-6177' AND c.record_type = 'faa_service_difficulty_report' GROUP BY ALL ORDER BY max(c.record_date) DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR FDEA202503180436Shear Tie · Airbus A300F4605RCOMPLY WITH EO 6-5310-E0330747 D P21 FOR FUSELAGE FRAME BASE FITTING AT FR44 BETWEEN STGR35LH AND STGR37LH CRACK REPAIR COMPLIED WITH EO 6-5310-E0330747 D P21. TITLE: FUSELAGE - MAIN FRAME - INSPECTIOSDR FDEA202503180437Shear Tie · Airbus A300F4605RCOMPLY WITH EO 6-5310-E0330747 D P22 FOR FUSELAGE FRAME BASE FITTING AT FR44 BETWEEN STGR35RH AND STGR37RH CRACK REPAIR COMPLIED WITH EO 6-5310-E0330747 D P22. TITLE: FUSELAGE - MAIN FRAME - INSPECTIOSDR FDEA202503180438Shear Tie · Airbus A300F4605RCOMPLY WITH EO 6-5310-E0330747 D P23 FOR FUSELAGE FRAME BASE FITTING AT FR45 BETWEEN STGR36LH AND STGR38LH CRACK REPAIR COMPLIED WITH EO 6-5310-E0330747 D P23. TITLE: FUSELAGE - MAIN FRAME - INSPECTIOSDR FDEA202503180439Shear Tie · Airbus A300F4605RCOMPLY WITH EO 6-5310-E0330747 D P24 FOR FUSELAGE FRAME BASE FITTING AT FR45 BETWEEN STGR36RH AND STGR38RH CRACK REPAIR COMPLIED WITH EO 6-5310-E0330747 D P24. TITLE: FUSELAGE - MAIN FRAME - INSPECTIOSDR FDEA202503180440Shear Tie · Airbus A300F4605RCOMPLY WITH EO 6-5310-E0330747 D P26 FOR FUSELAGE FRAME BASE FITTING AT FR46 BETWEEN STGR36RH AND STGR38RH CRACK REPAIR COMPLIED WITH EO 6-5310-E0330747 D P26. TITLE: FUSELAGE - MAIN FRAME - INSPECTIOSDR FDEA202412051837Fitting · Airbus A300F4605RLOWER LH FRAME 44 BASE FITTING FOUND AREA 1 CRACK ACCOMPLISHED THE FRAME FOOT REPAIR AT LH LOWER FRAME FITTING FR44. I.A.W FEDEX EO NO: E6-5310-E0330747 D P21, SEQ NO:1119, TITLE: FUSELAGE-MAINFRAME-ISDR FDEA202412051838Fitting · Airbus A300F4605RLOWER LH FRAME 46 BASE FITTING FOUND AREA 1 CRACK ACCOMPLISHED THE FRAME FOOT REPAIR AT LH LOWER FRAME FITTING FR46. I.A.W FEDEX EO NO: E6-5310-E0330747 D P25, SEQ NO:1122, TITLE: FUSELAGE-MAINFRAME-ISDR FDEA202412051839Fitting · Airbus A300F4605RLOWER RH FRAME 46 BASE FITTING FOUND AREA 1 CRACK ACCOMPLISHED THE FRAME FOOT REPAIR AT RH LOWER FRAME FITTING FR46. I.A.W FEDEX EO NO: E6-5310-E0330747 D P26, SEQ NO:1123, TITLE: FUSELAGE-MAINFRAME-ISDR FDEA202412051841Fitting · Airbus A300F4605RLOWER RH FRAME 45 BASE FITTING FOUND AREA 1 CRACK. ACCOMPLISHED THE FRAME FOOT REPAIR AT RH LOWER FRAME FITTING FR45. I.A.W FEDEX EO NO: E6-5310-E0330747 D P24, SEQ NO:1121, TITLE: FUSELAGE-MAINFRAME-SDR FDEA202412051842Fitting · Airbus A300F4605RLOWER LH FRAME 45 BASE FITTING FOUND AREA 1 CRACK ACCOMPLISHED THE FRAME FOOT REPAIR AT LH LOWER FRAME FITTING FR45. I.A.W FEDEX EO NO: E6-5310-E0330747 D P23, SEQ NO:1120, TITLE: FUSELAGE-MAINFRAME-ISDR FDEA202409111404Fitting · Airbus A300F4605RLOWER RH FRAME 44 BASE FITTING FOUND AREA 1 CRACK ACCOMPLISHED THE TRIMMED OUT AND FILLED THE GAP UNDER THE ANGLE WITH SHIM AT FR 44, STGR36R~37R I.A.W FEDEX EO NO:E6-5310-E0330747 D P22, SEQ NO: 781,SDR FDEA202409111405Fitting · Airbus A300F4605RLOWER LH FRAME 45 BASE FITTING FOUND AREA 1 CRACK ACCOMPLISHED THE DOUBLER REPAIR AT FRAME FOOT FR 45, STGR36L~38L. I.A.W FEDEX EO NO:E6-5310-E0330747 D P23, SEQ NO:782, TITLE: FUSELAGE- MAINFRAME- INSDR FDEA202409111406Fitting · Airbus A300F4605RLOWER LH FRAME 46 BASE FITTING FOUND AREA 1 CRACK ACCOMPLISHED THE DOUBLER REPAIR AT FRAME FOOT FR 46, STGR36L~38L. I.A.W FEDEX EO NO:E6-5310-E0330747 D P25, SEQ NO:783, TITLE: FUSELAGE- MAINFRAME- INSDR FDEA202409111407Fitting · Airbus A300F4605RLOWER RH FRAME 46 BASE FITTING FOUND AREA 1 CRACK ACCOMPLISHED THE DOUBLER REPAIR AT FRAME FOOT FR 46, STGR36R~38R. I.A.W FEDEX EO NO:E6-5310-E0330747 D P26, SEQ NO:784, TITLE: FUSELAGE- MAINFRAME- INSDR FDEA202408111331Shear Tie · Airbus A310300COMPLY WITH EO 6-5310-E0330747 D P12 REPAIRED THE FRAME FOOT CRACK AT FR45 RH SIDE AREA 2 COMPLIED WITH EO 6-5310-E0330747 D P12 REPAIRED THE FRAME FOOT CRACK AT FR45 RH SIDE AREA 2, TITLE: FUSELAGE -SDR FDEA201903170660Fitting · Airbus A300F4605REO 6-5310-E0330747 A P1 INSPECTION FOUND THE LOWER FRAME BASE FITTING HAS CRACK AT LT FR44 AREA 1 COMPLIED WITH FEDEX EO #:6-5310-E0330747 B P9, TITLE:FUSELAGE-MAINFRAME-INSPECTION OF LOWER FRAME BASESDR FDEA201903170661Fitting · Airbus A300F4605REO 6-5310-E0330747 A P1 INSPECTION FOUND THE LOWER FRAME BASE FITTING HAS CRACK AT LT FR46 AREA 1 COMPLIED WITH EO #:6-5310-E0330747 B P13, TITLE:FUSELAGE-MAINFRAME- INSPECTION OF LOWER FRAME BASE FITSDR FDEA201903170663Fitting · Airbus A300F4605REO 6-5310-E0330747 A P1 INSPECTION FOUND THE LOWER FRAME BASE FITTING HAS CRACK AT RT FR44 AREA 1 COMPLIED WITH EO #:6-5310-E0330747 B P10, TITLE:FUSELAGE-MAINFRAME- INSPECTION OF LOWER FRAME BASE FITSDR FDEA201903170664Fitting · Airbus A300F4605REO 6-5310-E0330747 A P1 INSPECTION FOUND THE LOWER FRAME BASE FITTING HAS CRACK AT RT FR45 AREA 1 COMPLIED WITH EO #:6-5310-E0330747 B P12, TITLE:FUSELAGE-MAINFRAME- INSPECTION OF LOWER FRAME BASE FITSDR FDEA201903170665Fitting · Airbus A300F4605REO 6-5310-E0330747 A P1 INSPECTION FOUND THE LOWER FRAME BASE FITTING HAS CRACK AT RT FR46 AREA 1 COMPLIED WITH EO #:6-5310-E0330747 B P14, TITLE:FUSELAGE-MAINFRAME- INSPECTION OF LOWER FRAME BASE FIT
Back to Airbus SB A300-53-6177