Boeing SB 747-53-2112
Service difficulty reports that cite it · 4
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 = 'boeing/sb-747-53-2112' 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 = 'boeing/sb-747-53-2112' 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 UPS00434011Doubler · Boeing 747121INSPECTION TYPE:C, NLG CRACK FOUND ON THE FWD LOWER CORNER STRUCTURE OF THE WHEEL WELL LT SIDE. CRACK EXTENDS UNDER THE LOWER CHORD OF THE BULKHEAD. CRACKS ARE PERMITTED IAW SB 747-53-2112 R3 IN UNDERSDR EIAA2000118Structure · Boeing 747212BHAECO-HKG - C6/D-CHECK/PLY MOD - NLG W/W FORWARD LT CORNER STRUCTURE AT STA 240 LBL 33 AREA CANTED BULKHEAD CHORD UPPER FLANGE CRACKED BY 1.25 INCHES RUNNING UPWARDS. REPAIRED NLG W/W LT FORWARD CORNESDR P5CA9800967Bulkhead · Boeing 747122LEFT AND RIGHT NLG WHEEL WELL FORWARD CORNERS CANTED BULKHEAD AND SIDEWALL LOWER CHORD FOUND CRACKED. REPAIRED AS PER SB 747-53-2112.SDR 95UAL900122Doublers · Boeing 747238BTHE 65B00283-1, 65B00283-2 DOUBLERS WERE FOUND TO HAVE CRACKS EMANATING FROM THE INBOARD EDGE. THE DOUBLERS WERE PREVIOUSLY INSTALLED BY THE PRIOR OWNER. UAL REPLACED DOUBLERS AND REINFORCED AREA PER
Back to Boeing SB 747-53-2112