Airbus SB A330-53-3273
Service difficulty reports that cite it · 5
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/a330-53-3273' 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/a330-53-3273' 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 DALA2024010800311Unknown · Airbus A330323SHIP 3310 CRACK INDICATION FROM 14I HOLE LOCATED AT RH STRG 15A LEVEL AT UPPER FUSELAGE. CRACK DIRECTION IS 11 OCLOCK AND CRACK DEPTH IS 0.083 INCH. FOR AD MANDATED DOCUMENTS AN AMOC MAY BE REQUIRED. SDR DALA2022120207714None · Airbus A330323DURING ACCOMPLISHMENT OF THE MODIFICATION REQUIRED PER FAA AD 2019-19-09 AND SB A330-53-3273 REV. 2 VIA WORK CARD 5310-01461- 01, MTC HAS REPORTED THAT WORK COULD BE ACCOMPLISHED MORE EFFICIENTLY IF CSDR DALA2022120207721None · Airbus A330323DURING ACCOMPLISHMENT OF THE MODIFICATION REQUIRED PER FAA AD 2019-19-09 AND SB A330-53-3273 REV. 2 VIA WORK CARD 5310-01461- 01, MTC HAS REPORTED AN ERROR REFERENCING AN INCORRECT FIGURE VIEW WITHIN SDR DALA2022122308346None · Airbus A330323DURING ACCOMPLISHMENT OF THE MODIFICATION REQUIRED PER FAA AD 2019-19-09 AND SB A330-53-3273 REV. 2 VIA WORK CARD 5310-01461-01, MTC HAS REPORTED AN ERROR REFERENCING AN INCORRECT FIGURE VIEW WITHIN TSDR DALA2023012600651None · Airbus A330323SHIP 3308 DURING ACCOMPLISHMENT OF THE MODIFICATION REQUIRED PER FAA AD 2019-19-09 AND SB A330-53-3273 REV. 2 VIA WORK CARD 5310-01461- 01, MTC HAS REPORTED AN ERROR REFERENCING AN INCORRECT FIGURE VI
Back to Airbus SB A330-53-3273