Airbus SB A300-57-6086
Service difficulty reports that cite it · 7
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-57-6086' 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-57-6086' 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 FDEA202009202270Web · Airbus A300F4605RDURING THE ACCOMPLISHMENT OF STEP (9)(C) OF EO 6-5710-E0342809 P5 (LT WING), A CRACK NDICATION WAS NOTED APPROXIMATELY .500" FROM THE BOTTOM OF HOLE G AT THE 7 O'LOCK POSITION. CRACK MEASURES APPROXIMSDR FDEA201210053558Frame · Airbus A300F4605RDURING SB A300-57-6086 ACCOMPLISHMENT, DAMAGE FOUND IN HOLE "P" AT FRAME 47 RT SIDE. DAMAGE WAS NOTED IN THE TEE AND SPAR. REMOVED NOMINAL FASTENER FROM HOLE "P" AT FRAME 47 RT SIDE, VERIFIED DAMAGE ISDR 08FDEA03977Fitting · Airbus A300B4622RFOUND DAMAGED HOLES DURING ACCOMPLISHMENT OF SB A300-57-6086 (HOLE E, F, P) ON HORIZONTAL FLANGE, C 47, LT. REPAIR PERFORMED BY OVERSIZING THE HOLES AND NDT FOR DAMAGE FREE CONDITION IAW RAS/70512903/SDR 08FDEA03978Fitting · Airbus A300B4622RFOUND DAMAGED HOLES DURING ACCOMPLISHMENT OF SB A300-57-6086 (HOLE G,T) ON HORIZONTAL FLANGE, C47, RT. REPAIR PERFORMED BY OVERSIZING THE HOLES, NDT FOR DAMAGE FREE CONDITION AND INSTALLING A CONICAL SDR 07FDEA03333Fitting · Airbus A300B4622RFOUND CRACK IN HOLE G/T OF ANGLE FITTING IN CENTER WING BOX AT FRAME 47 LT DURING SB A300-57-6086, -6050, AND -6049. REPAIR PERFORMED BY OVERSIZING THE HOLES IN ALL LAYERS ON A STEP BY STEP BASIS, ROTSDR 07FDEA03334Fitting · Airbus A300B4622RFOUND CRACK IN HOLES H, G, Q, S AND T OF ANGLE FITTING IN CENTER WING BOX AT FRAME 47 RT DURING SB A300-57-6086, -6050, AND -6049. REPAIR PERFORMED BY OVERSIZING THE HOLES IN ALL LAYERS ON A STEP BY SSDR 07FDEA03005Fitting · Airbus A300B4622RFINDING CRACKS DURING ACCOMPLISHMENT OF SB A300-57-6049 AND A300-57-6086 IN CENTER WING BOX CORNER ANGLE FITTING (HOLE A (LT/RT), Q, G , I (LT). REPAIR PERFORMED BY REAM UP UNTIL CRACK REMOVAL IAW EA
Back to Airbus SB A300-57-6086