Boeing SB 747-53-2272
Service difficulty reports that cite it · 13
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-2272' 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-2272' 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 EIAA2011164Floorbeam · Boeing 747212BUPPER DECK FLOORBEAM WEB AT BS 330 RBL 60 FOUND CRACKED. DAMAGED WEB REMOVED. FLOORBEAM UPPER CHORD TRIMMED OUT PER SRM 51-10-01 AND REPAIRED CARRIED OUT PER BOEING DRAWING 65B28068, REV B SHEET 3 ANDSDR UIEA200700296Floorbeam · Boeing 747271CCRACK ON FORWARD FACE OF FLOORBEAM WEB (UPPER DECK) STA 330 LEFT SIDE AT FRAME TO FLOORBEAM ATTACHMENT. REPAIRED CRACKED FLOORBEAM WEB AT STA 330 LEFT PER SB 747-53-2272 DRAWING NR 65B28068 SRM 51-30-SDR UPS06446363Frame · Boeing 747200COCKPIT BS 380 STR10L, 10AL AND 11L FRAME O/B AREA FOUND CRACK. COCKPIT BS 380 STR 0 TO STR 13AL FRAME REPLACED AND INSTALLED AS PER RS R53-12-35444 CONTINUED SB747-53A2265 INSPECTIONS REQUIRE AND WHESDR UPS05444397Frame · Boeing 747283BNR 1 LT MED CUTOUT BS 488 FRAME AT STR 25L INNER CHORD TWO FASTENER HOLES FOUND CRACKED AND AS MARKED, CRACK LENGTH 1/8 INCH. NR 1 MED LT BS 488 INNER CHORD REPLACED AS PER SB 747-53-2272 AND DWG 624USDR EIA2004056Frame · Boeing 747273CSTA 300 LOWER LOBE FRAME, 3 EXTRA HOLES WERE DRILLED AND PLUGGED INTO THE 141U1021-21 DOUBLER AND 1 OF THE EXTRA HOLES IS COMMON TO THE 141U1021-9 FRAME AT THE STR 27A 4H CLIP LOCATION. LOCATED AND DRSDR EIA2003102Frame · Boeing 747212BFRAME CRACKED, INTERIOR FUSELAGE STA 300L, BELOW S-25L, OUTBOARD NEAR SKIN. REMOVED AND REPLACED FUSELAGE FRAME AT FS 300L, STR 23-41, PER SB 747-53-2272, PER -B-DRAWINGS 141U1021 AND 65B1708 & ECRA 4SDR UPS02439727Frame · Boeing 747SR46INSPECTION TYPE:C M/D BS 380 S24AR FRAME CRACKED. RH FRAME AT BS 380 S24AR REPAIRED AS PER HX RS R53-12-34913 & UPS EO B747-5310-17674-A. TO BE CONTINEOUS TO INSPECT THE REPAIR AREA UNTIL SB 747-53-22SDR UIEA01041Frame · Boeing 747230BDURING INSPECTION FOUND BS 360 FRAME DEEPLY GOUGED BETWEEN STRINGER 2L AND 2AL. CUT AWAY DAMAGED AREA. FABRICATED REPAIR FILLER, DOUBLERS AND SPLICE PLATES. INSTALLED PER STANDARD PRACTICES IAW BOEINGSDR UIEA01007Frame · Boeing 747230BDURING ACCOMPLISHMENT OF SB 747-53-2272 FOUND ONE CRACKED HOLE BS 360 LEFT ABOVE STRINGER 15L. STOP DRILLED CRACK, INSTALLED REPAIR DOUBLERS PER STANDARD PRACTICES IN A NON-MANDATORY ZONE. AMOC APPROVSDR UIEA01008Frame · Boeing 747230BDURING ACCOMPLISHEMENT OF SB 747-53-2272 FOUND TWO CRACKED HOLE BS 360 R/S AT STRINGER 14R AND STRINGER 15R. STOP DRILLED CRACK, INSTALLED REPAIR DOUBLERS PER STANDARD PRACTICES IN A NON-MANDATORY ZONSDR UIEA01009Frame · Boeing 747230BDURING ACCOMPLISHMENT OF SB 747-53-2272 FOUND ONE CRACKED HOLE BS 380 R/S AT STRINGER 14R. STOP DRILLED CRACK, INSTALLED REPAIR DOUBLER PER STANDARD PRACTICES IN A NON-MANDATORY ZONE. AMOC APPROVED PESDR UIEA00022Skin · Boeing 7472D7BNOSE GEAR CUTOUT CORNER CRACKED AT STATION 240 STRINGER 40R. FOUND NO SECONDARY CRACKS. REPAIRED BY INSTALLING DOUBLER PER SB 747-53-2272. (M)SDR EIAA2000124Lap Joint · Boeing 747212BHAECO-HKG - C6/D-CHECK/PLY MOD - S41 MOD AT RT BS 360 - BS 380 S6 LAP SPLICE FOUND 3 EACH HOLES CRACKED AT UPPER SKIN. RT BS 360 - BS 380 LAP SKIN S6 SPLICE 3 EACH CRACKED HOLES AT UPPER SKIN 0.25 INC
Back to Boeing SB 747-53-2272