Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA118388Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA20111206363Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 986.5, STR 18R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118362Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 24L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118717Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND CRACK ON AFT LWR CORNER OF GALLEY DOOR, BS 332.1-3, STR 17R-3. REPAIRED SKIN PER DOC.SDR SWAA118718Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CRACK UPPER CHORD BS 661 ABD BBL 0.07 LONG FLOORBEAM. REPAIRED FLOORBEAM PER AE.SDR SWAA118716Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND CRACK ON AFT LWR CORNER OF GALLEY DOOR, BS 332.0-4, STR 17R-2. REPAIRED SKIN PER DOC.SDR SWAA118715Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND CRACK ON WEB LWR CHORD BS 670+1 AND BBL 0.07 LONG FLOORBEAM. REPAIRED WEB LOC ON LWR CHORD PER DOC.SDR SWAA20111205429Lens · brokenDURING SCHEDULED 20Y CHECK, FOUND EEPLS LENS BROKEN AT FWD LAV. REMOVED AND REPLACED LENS IAW MM.SDR SWAA118737Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CORROSION STA 482B+3.5, STR 28L IN FWD CARGO COMPARTMENT. REPAIRED CORROSION PER SWA DOC.SDR SWAA118681Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND DELAMINATION ON I/B SIDE OF O/B AFT FLAP. REMOVED AND REPLACED FLAP PER MM.SDR SWAA118326Skin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 390+1, STR 1. REPAIRED SKIN PER EA.SDR SWAA118325Skin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 370+5, STR 1. REPAIRED SKIN PER EA.SDR SWAA118739Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND EXTERNAL FUSELAGE SKIN CRACK BS 520+2, STR 28R. REPAIRED FUSELAGE CRACK PER DOC.SDR SWAA118298Lens · puncturedLT EMERGENCY EXIT LIGHT LENS PUNCTURED AT ROW 11. REMOVED AND REPLACED LENS IAW MM.SDR SWAA118292Lens · brokenDURING SCHEDULED 20Y CHECK FOUND OVERHEAD EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS IAW MM.SDR SWAA118276Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, LBL 12.5. REPAIRED CHANNEL IAW EA.SDR SWAA118275Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, RBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA118274Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT STIFFENER CRACKED AT BS 727, STR 27R. REMOVED AND REPLACED STIFFENER CRACKED IAW SRM AND DWG.SDR SWAA118273Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118272Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CLIP CRACKED AT BS 787, STR 20R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118271Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED BETWEEN BS 857 TO BS 861, RBL 8.10. REMOVED AND REPLACED CHANNEL IAW SRM AND EA.SDR SWAA118270Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 967, BETWEEN STR 20L TO STR 21L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA118244Lens · brokenDURING SCHEDULED 20Y CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS BROKEN. REMOVED AND REPLACED LENS IAW MM.SDR SWAA2012032702616Skin · crackedSKIN CRACKED AT BS 370+ 5, STR 1. REPAIRED SKIN IAW EA.SDR SWAA2012032302521Skin · crackedFUSELAGE SKIN CRACKED AT BS 390+ 1, STR 1. REPAIRED SKIN IAW EA.SDR SWAA118187Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, LBL 3.0. REPAIRED CHANNEL IAW EA.SDR SWAA118186Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, LBL 7.10. REPAIRED CHANNEL IAW EA.SDR SWAA118185Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, RBL 3.0. REPAIRED CHANNEL IAW EA.SDR SWAA118184Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 21R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118183Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 24L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118182Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 482A TO BS 482B, STR 26R. REPAIRED STRINGER IAW SRM.SDR SWAA118181Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 312+8, STR 21L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118180Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 325.6, STR 21L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118179Light · looseLT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LOOSE AT ROW 6. SECURED LIGHT PER MM.SDR SWAA118136Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABLIZER L/E PANEL RIB CRACKED AT STA 170.37. REMOVED AND REPLACED RIB IAW SRM AND DWG.SDR SWAA118094Lens · looseDURING SCHEDULED CV CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE LENS LOOSE. REMOVED AND REPLACED LENS IAW MT.SDR SWAA118093Lens · looseDURING SCHEDULED CV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LENS LOOSE. REMOVED AND REPLACED LENS IAW MT.SDR SWAA118095Lens · brokenDURING SCHEDULED 20Y CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA118092Lens · looseRIGHT EMERGENCY EXIT LIGHT LENS LOOSE. INSTALLED LENS IAW EA.SDR SWAA118110Pressure Deck · crackedDURING SCHEDULED HC1 CHECK, FOUND MAIN WHEEL WELL PRESSURE DECK CRACKED AT BS 664.75, RBL 36. REPAIRED WEB IAW SRM AND EA.SDR SWAA118063Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT EMERGENCY EXIT SLIDE LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA117896Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 947.5+12, STR 21L. REPAIRED SKIN IAW EA.SDR SWAA117895Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 867+4.5, STR 24R. REPAIRED SKIN PER EA.SDR SWAA117894Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 867+17, STR 24R. REPAIRED SKIIN IAW SRM.SDR SWAA117693Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 405, STR 16R. REPAIRED SKIN.SDR SWAA117741Lens · looseDURING SCHEDULED HC1 CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA117628Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM T-CHORD CORRODED BETWEEN BS 360 TO BS 396, STR 17R. REMOVED AND REPLACED BEAM IAW SRM.SDR SWAA117627Shear Web · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM SHEAR WEB CORRODED BETWEEN BS 380 TO BS 400, STR 17R. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA117626Beam · crackedDURING SCHEDULED SPV CHECK, FOUND STUB BEAM UPPER CHORD CRACKED AT BS 616, WL 207. REMOVED AND REPLACED BEAM IAW ER.SDR SWAA117625Beam · crackedDURING SCHEDULED SPV CHECK, FOUND STUB BEAM UPPER CHORD CRACKED AT BS 616, WL 208. REMOVED AND REPLACED BEAM IAW ER.
Back to Boeing 737-5H4