Airbus SB A310-53-2124
Service difficulty reports that cite it · 3
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/a310-53-2124' 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/a310-53-2124' 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 07FDEA03083Frame · Airbus A310324TWO CRACKED HOLES (H1, H2) WERE FOUND AT FRAME 43, STRG 26-27 RT, REPAIR PERFORMED BY REPLACING FITTING AND APPLY SB A310-53-2124 ON THE NEW FITTING HOLES IAW EA 6-5315-103254.SDR 07FDEA01426Shear Tie · Airbus A310324CRACK FINDINGS DURING ACCOMPLISHMENT OF EO 6-5310-7-5020, SB A310-53-2124, RHS, C43 RT HOLE H2 CRACK LENGTH 7MM; C45 HOLE H22 CRACK LENGTH 7MM; C46 HOLE H25 CRACK LENGTH 8MM; C46 HOLE 27 CRACK LENGTH SDR 07FDEA01310Frame · Airbus A310304DEVIATION TO EO 6-5310-7-5020, SB A310-53-2124, AD 2006-02-06, CRACKS IN FRAME FEET , C45, C46 LT REPAIR PERFORMED BY CRACK REMOVING THRU OVERSIZING IAW EA 6-5315-106424 AND RAS 049395/047/2007 ISS A.
Back to Airbus SB A310-53-2124