Boeing SB 727-53-0149
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 = 'boeing/sb-727-53-0149' 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-727-53-0149' 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 GAIA00465Frame · Boeing 727251FOUND DURING ROUTINE SCHEDULED MAINTENANCE, FOUND CRACK IN MLG WELL AT BS 940, LBL 50 REF N/R NR 20014, 20692, AND 20816. REPAIRED IAW BOEING DRAWING 65-89360 AND S/B 727-53-0149. THE AIRCRAFT WAS RETSDR GAIA0072Plate · Boeing 727251DURING C-CHECK AT TIMCO/OSC THE FOLLOWING DISCREPANCY WAS FOUND AT STATION 940, THE LEFT GEAR WELL PRESSURE DECK HAD CRACK INDICATION AT LBL 30. REPAIRED CRACK IAW SB 727-53-0149 AND BOEING DRAWING 65SDR GAIA0075Plate · Boeing 727251DURING C-CHECK AT TIMCO/OSC THE FOLLOWING DISCREPANCY WAS FOUND AT STATION 940, IN THE RIGHT WHEEL WELL PRESSURE DECK CRACK WAS FOUND AT RBL 30. REPAIRED CRACK IAW SB 727-53-0149 AND BOEING DRAWING PLSDR DALR960001Web · Boeing 727223ATL - DURING HEAVY C-CHECK, THE LT MLG WHEELWELL PRESSURE DECK WAS FOUND WITH SEVERAL CRACKS AT THE FWD INBOARD CORNER OF THE WEB BEADS AT BS 870, LBL 4. ACCOMPLISHED REPAIRS PER DL ERA 303046-14, REVSDR DL72S960202Deck · Boeing 727232DURING MIDVISIT, TWO 1 INCH CRACKS WERE FOUND IN THE LT MAIN LANDING GEAR WHEEL WELL PRESSURE DECK BETWEEN STATIONS 940 AND 950, BETWEEN LBL 50 AND 60. MODIFICATION INSTALLED IN ACCORDANCE WITH BOEINGSDR DL72E954266Doubler · Boeing 727247THE LT MAIN LANDING GEAR WHEEL WELL PRESSURE DECK WAS FOUND WITH A PREVIOUS MODIFICATION DOUBLER INSTALLED FOR A CRACK AT LBL 55 AND STA 938. THE PREVIOUS DOUBLER WILL BE REMOVED AND A NEW DOUBLER INSSDR 95ZZZM683Web · Boeing 727231MCI - DURING C-CHECK, FOUND A TWO INCH CRACK BETWEEN BEADED EXTRUSION IN HORIZONTAL PRESSURE DECK WEB OF LEFT MLG WHEEL WELL, AFT OUTBOARD CORNER OF WHEEL WELL CEILING, BS 948, LBL 59. INSTALLED DOUBL
Back to Boeing SB 727-53-0149