Boeing 747-2U3B
Service difficulty reports · 125
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '7472U3B' ORDER BY difficulty_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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '7472U3B' ORDER BY difficulty_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 P5CA0100515Balance Weight · corrodedLEVEL 1 CORROSION FOUND ON BALANCE WEIGHT TWO RIGHT OUTBOARD ELEVATOR. REPAIRED PER S/L 747-55-07.SDR P5CA0100513Skin · corrodedLEVEL 1 CORROSION FOUND ON LT WING L/E TOP WING SKIN WS 586 - WBL 470 BULGING AROUND FASTENERS. REPAIRED PER SRM 57-10-01, 51-30-02.SDR P5CA0100512Intercostal · crackedCRACK FOUND ON INTERCOSTALS BS 1960- RBL 30, BS 1960- BL 0, BS 1960- RBL 7.5, BS 1980- LBL 37.5. REPAIRED PER SRM 53-10-07.SDR P5CA0100511Skin · dentedFUSELAGE SKIN DENTED BS 2298-STRINGER 24 LEFT, BS 2433-STRINGER 24L TO S25 LEFT, BS 2184-STRINGER 23L TO S24 LEFT, BS 2191 - STRINGER 23L TO S24 LEFT. REPAIRED PER SRM 51-40-01.SDR P5CA0100510Skin · dentedFUSELAGE SKIN DENTED BS 2298-STRINGER 21 RIGHT, BS 2288 TO 2300 - STRINGERS 22 TO 23 LEFT, BS 2303 - STRINGER 23 LEFT, BS 2306 - STRINGER 24 LEFT. REPAIRED PER SRM 51-40-01.SDR P5CA0100509Skin · dentedFUSELAGE SKIN DENTED AT BS 2309-STRINGER 22 RIGHT, BS 2318-STRINGER 22 LEFT, BS 2324-STRINGER 21 LEFT. REPAIRED PER SRM 51-40-01.SDR P5CA0100508Skin · delaminatedDELAMINATION FOUND ON LT WING, T/E INBOARD MID FLAP BOTTOM SKIN WITH BULGES. REPAIRED PER SRM 51-40-15.SDR P5CA0100507Flap · wornWEAR FOUND ON LEADING EDGE FLAPS - NR 2 - WS 1423, NR 4-WS 1280, NR 7-WS 972, NR 8-WS889, NR 9-WS807. REPAIRED PER SRM 51-40-15.SDR P5CA0100506Skin · chafedDAMAGE FOUND ON LT WING, T/E OUTBOARD FOREFLAP O/B AREA LEADING EDGE CHAFED. REPAIRED PER SRM 51-40-15.SDR P5CA0100484Stringer · crackedCRACK 2.1 LONG BS 1000 LHS STR 46. REPAIRED PER SB747-53-2316.SDR P5CA0100480Intercostal · crackedCRACK 2.25 INCH FOUND ON INTERCOSTAL BS 434 STR 26. REPAIRED PER SRM 53-30-02.SDR P5CA0100479Skin · crackedCRACK FOUND BS 434 STR 26 & 27. REPAIRED PER SRM 53-30-02.SDR P5CA0100478Skin · crackedCRACK FOUND AT BS 1000 STR 46-47 RT 1.8 LONG. REPAIRED PER S/B 747-53-2316.SDR P5CA0100477Skin · corrodedLEVEL 1 CORROSION BETWEEN STA 1700-1720 STR 50L AND51L. REPAIRED PER 53-30-03.SDR P5CA0100476Panel · crackedCRACK FOUND AT CANTED RPESSURE BULKHEAD R/L CLOSURE PANELS AT WEB STA 1240. REPAIRED PER SRM 53-10-02 AND 8110-3 SB 747-53-2329.SDR P5CA0100475Skin · dentedDENT AT 3 LOCATIONS STA 1830 TO 1840 STR 39L TO 40L. REPAIRED PER SRM 53-30-03.SDR P5CA0100474Stringer · corrodedLEVEL 1 CORROSION FOUND STR 51R STA 1000 KWD TIE. REPAIRED PER SRM 53-10-03.SDR P5CA0100473Stringer · corrodedLEVEL 1 CORROSION FOUND ON STR 51L AT STA 1000. REPAIRED PER SRM 53-10-03.SDR P5CA0100483Frame · crackedCRACK FOUND ON 1265 FRAME RT AND LT SIDE. REPAIRED PER SB 747-53A-2416.SDR P5CA0100472Skin · dentedDENT FOUND ON FUSELAGE SKIN LT BS 510 S28L. REPAIRED PER SRM 53-30-03.SDR P5CA0100471Skin · dentedDENT FOUND ON FUSELAGE SKIN LT SIDE EXTERIOR SURFACE AT BS 630 S39L. REPAIRED PER SRM 53-30-03.SDR P5CA0100470Skin · dentedDENT FOUND ON FUSELAGE SKIN RT SIDE EXT SURFACE AT BS 450 S37R. REPAIRED PER SRM 53-30-03.SDR P5CA0100469Stop Fitting · crackedCRACK ON LT DOOR STOP AFT SIDE ON WEB DOOR FRAME. REPAIRED PER SRM 53-10-04.SDR P5CA0100468Skin · damagedDENT FOUND ON AFT CARGO DOOR EXT SKIN AT LOWER FWD SECTION AT INSP PANEL. REPAIRED PER SRM 52-00-03.SDR P5CA0100481Panel · crackedCRACK FOUND ON CANTED PRESSURE BULKHEAD LEFT CLOSURE PANEL AT WEB AND DOUBLER STA 1240 LBL 75. REPAIRED PER 8110-3 AND SRM 51-10-01.
Back to Boeing 747-2U3B