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 SWAA115013Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA114937Lens · looseL1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA114900Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT OF CONTAINER, DID NOT DEPLOY. RE-INSTALLED SLIDE IAW MT.SDR SWAA114899Bear Strap · crackedDURING SCHEDULED 22Y CHECK, FOUND RT AFT CARGO COMPARTMENT BEAR STRAP CORRODED AT BS 787, STR 26R. REPAIRED SKIN IAW EA.SDR SWAA114901Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 789 TO BS 780, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA114902Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114903Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA114862Structure · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT CHORD CORRODED AT BS 727, BETWEEN STR 27L TO STR 27R. REPAIRED CHORD PER SRM.SDR SWAA114863Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 747+17, STR 24L. REPAIRED SKIN PER EA.SDR SWAA114864Bulkhead · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD CORRODED AT BS 1016, BETWEEN BL 0 TO RBL 8. REPAIRED BULKHEAD PER EA, SRM, DWG, AND ACO.SDR SWAA114865Bulkhead · crackedDURING SCHEDULE 22Y CHECK, FOUND AFT PRESSURE BULKHEAD DOME CAP CRACKED AT 6 O'CLOCK POSITION. REPAIRED DOME CAP PER EA.SDR SWAA114866Stiffener · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT BULKHEAD LOWER STIFFENER CHORD CORRODED AT BS 1016, RBL 1. REPAIRED CHORD PER SRM, ACO, AND DWG.SDR SWAA114867Channel · corrodedDURING SCHEDULE 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 847+13, LBL 12.50. REMOVED AND REPLACED CHANNEL PER SRM AND DWG.SDR SWAA114868Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER FLANGE CORRODED AT BS 986.5, LBL 43. REPAIRED FLANGE PER SRM.SDR SWAA114841Slide · out of positionDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA114840Light · brokenDURING SCHEDULED 22Y CHECK, FOUND FWD LAVATORY AFT WALL EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA114833Control Valve · faultyDIVERSION/DECLARED EMERGENCY. EMERGENCY DESCENT DUE TO CABIN PRESSURE REACHING 10,000; ALL OTHER COCKPIT INDICATIONS NORMAL. REMOVED AND REPLACED NR 1 ENGINE PRECOOLER CONTROL VALVE, NR 1 ENGINE HIGH STAGE REGULATOR, NR 1 ENGINE HIGH STAGE VALVE, AFT OUTFLOWSDR SWAA114843Window Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND LT FUSELAGE WINDOW FRAME STRUCTURE CRACKED ON POST, APPROX STR 19L. REPAIRED FRAME PER SRM.SDR SWAA114842Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 407, STR 16R. REPAIRED SKIN PER EA.SDR SWAA114790Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND RT AFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA114789Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+6, RBL 3. REMOVED AND REPLACED CHANNEL PER SRM AND EA.SDR SWAA114788Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND WEB CORRODED BETWEEN BS 420 TO BS 440, STR 17L. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA114787Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND WEB CORRODED BETWEEN BS 400 TO BS 420, STR 17L. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA114786Stabilizer · crackedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL STABILIZER CRACKED AT FWL 107. REPAIRED STABILIZER EPR SRM.SDR SWAA114785Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND WEB CORRODED BETWEEN BS 767 TO BS 787, STR 17L. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA114784Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER STIFFENER CRACKED AT STA 83.50. REMOVED AND REPLACED STIFFENER PER SRM AND DWG.SDR SWAA114783Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 847+13 RBL 3.00. REPAIRED CHANNEL PER SRM AND EA.SDR SWAA114782Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 847+13, LBL 8.10. REPAIRED CHANNEL PER SRM AND EA.SDR SWAA114781Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 847+13, LBL 3.00. REPAIRED CHANNEL PER SRM AND EA.SDR SWAA114780Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+6, LBL 3.00. REPAIRED CHANNEL PER SRM AND EA.SDR SWAA114779Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+6, LBL 8.10. REPAIRED CHANNEL PER SRM AND EA.SDR SWAA114778Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+6, LBL 8.10. REPAIRED CHANNEL PER SRM AND EA.SDR SWAA114777Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+6, RBL 3.0. REPAIRED CHANNEL PER SRM AND EA.SDR SWAA114775Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT HORIZONTAL STABILIZER HINGE HOUSING FITTING ATTACH LUGS CORRODED. REPAIRED LUGS IAW EA.SDR SWAA114774Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR FORWARD LOWER CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA114776Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 759.5 TO BS 780, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA114773Lens · missingDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT SIDEWALL LIGHT LENS MISSING. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA114737Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND UPPER HORIZONTAL FLANGE FLOORBEAM CRACKED AT 294.5, LBL 54. REPAIRED BEAM IAW SRM AND DWG.SDR SWAA114736Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND WEB CORRODED BETWEEN BS 440 TO BS 460, STR 17RL. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA114735Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND WEB CORRODED BETWEEN BS 616 TO BS 639, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA114734Failsafe · crackedDURING SCHEDULED 20Y CHECK, FOUND FAIL SAFE ANGLE CRACKED AT BS 927, BETWEEN STR 21R TO STR 22R. REPAIRED ANGLE PER SRM.SDR SWAA114733Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 277, BETWEEN STR 10 TO STR 11L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA114791Frame · crackedDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR STUB FRAME CRACKED AT UPPER CORNER. REPAIRED FRAME PER EA AND DWG.SDR SWAA114717Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 434, STR 1. REPAIRED SKIN PER EA.SDR SWAA114704Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+6, LBL 3.0. REPAIRED CHANNEL PER EA.SDR SWAA114703Skin · crackedDURING SCHEUDLED 22Y CHECK, FOUND SKIN CRACKED AT BS 492, STR 16L. REPAIRED SKIN PER EA AND ER.SDR SWAA114677Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 727B+6, RBL 8.1. REPAIRED CHANNEL PER EA.SDR SWAA114676Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 847+13, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA114614Frame · crackedDURING SCHEDULED 22Y CHECK FOUND, R1 DOOR CUTOUT FWD FRAME CRACKED AT BS 294.5+6, BETWEEN STR 17R TO STR 16R. REPAIRED FRAME IAW SRM.SDR SWAA114613Shear Tie · crackedDURING SCHEDULED 22Y CHECK FOUND, SHEAR TIE CRACKED AT BS 277, BETWEEN STR 9L TO STR 10L. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to Boeing 737-5H4