Boeing SB 737-53-1094
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-737-53-1094' 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-737-53-1094' 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 AWXA200100491Skin · Boeing 737277YVR - C19 CK - "C" - L2 DOOR, FUSELAGE TORQUE BOX INNER SKIN 2" CRACK BS 952, BETWEEN STR 11R & 12R. MAINTENANCE FABRICATED REINFORCEMENT STRAP AND INSTALLED IAW AWA ER 15-5345-01264-TB4, REFERENCING SDR F3LA98100Skin · Boeing 737301DURING C-CHECK INSPECTION, REPORTED A 1 INCH CRACK IN AFT GALLEY DOOR SURROUND STRUCTURE INNER SKIN AT BS 946, STRINGER 11R TO 12R THROUGH A HI-LOK HOLE. MAINTENANCE REPAIRED CRACK PER BOEING SB 737-5SDR AWXA9700468Web · Boeing 737277DURING ROUTINE MAINTENANCE CHECK, FOUND A CRACK ON WEB AT BS 948, WL 257, RBL 61. REPAIRED CRACK ON WEB AT BS 948, WL 257, RBL 61 AS PER EO 2-53-35-16 AND SB 737-53-1094.SDR W8PA971230Skin · Boeing 737301CRACKED INNER SKIN BS 948, RBL 65, WL 254. REPAIRED PER SB 737-53-1094. (M)
Back to Boeing SB 737-53-1094