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 SWAA042511Gusset · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR AFT LOWER GUSSET CRACKED. REMOVED AND REPLACED GUSSET PER BAC DRAWING.SDR SWAA042488Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND R2 AND L2 DOOR EVAC SLIDE CABLES MISROUTED. ROUTED R2 AND L2 DOOR EVAC SLIDE CABLES PER MM.SDR SWAA042405Skin · corrodedDURING SCHEDULED C4 CHECK, FOUND LT WING SKIN AT WING STATION 132, STRINGER 3, CORRODED. REPAIRED SKIN PER EA.SDR SWAA042389Transmission · inoperativeNO FLAP EXTENSION WITH NORMAL HYD, ALT FLAPS USED TO EXTEND LEADING EDGE. ALT FLAP DRIVE C/B TRIPPED. REMOVED AND REPLACED NR 3, 5 AND 6 FLAP TRANSMISSIONS AND JACKSCREWS PER MM.SDR SWAA042365Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 942, STRINGER 23L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042364Clip · brokenDURING SPV, FOUND L2 DOOR EVAC SLIDE GIRT BAR HOOK, AFT MOUNTING SCREWS CLIP-NUT, BROKEN. REMOVED AND REPLACED L2 DOOR EVAC SLIDE CLIP-NUT PER MM.SDR SWAA042352Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 525, STR 10R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042324Spindle · wornWHEN FLAPS LOWERED TO 5, THE AIRCRAFT SHUTTERED. NO ROLL, FELT IN CONTROLS. REMOVED AND REPLACED LT WING OUTBOARD AFT FLAP NR 1 AND NR 2 TOGGLES, SEQ CARRIAGE, SPINDLE. RT WING OUTBOARD AFT FLAP NR 7 AND NR 8 TOGGLES, SEQ CARRIAGE, SPINDLE PER MM.SDR SWAA042297Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 COCKPIT UPPER WINDOW POST CRACKED. REPAIRED WINDOW POST PER SRM.SDR SWAA042280Sleeve · missingDURING FLIGHT, NR 1 ENGINE THRUST REVERSER UNLOCKED LIGHT, ENGINE LIGHT AND REVERSER LIGHT ILLUMINATED. UPON LANDING FOUND NR 1 THRUST REVERSER SLEEVE DEPARTED. REMOVED AND REPLACED NR 1 ENGINE THRUST REVERSER OUTBOARD SLEEVE PER MM.SDR SWAA042279Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE AT BS 807, STR 27L, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA042278Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA042277Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 772, RBL 8 TO LBL 3, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA042276Gusset · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178, BULKHEAD LOWER GUSSET AFT CORNER CRACKED. REMOVED AND REPLACED GUSSET PER BAC DRAWING.SDR SWAA042264Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT AT ROW 11 ABC, INOP. RELAMPED EMERGENCY EXIT LIGHT PER MM.SDR SWAA042263Lamp · inoperativeDURING SCHEDULED PM CHECK, FOUND EMERGENCY EXIT LIGHTS AT ROWS 6 ABC, 8 ABC, INOP. RELAMPED EMERGENCY EXIT LIGHTS PER MM.SDR SWAA042235Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT R2 DOOR CUTOUT AFT LOWER CORNER, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042234Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R2 DOOR AFT LOWER FRAME AT LOWER STOP, CRACKED. REMOVED AND REPLACED LOWER FRAME PER BAC DRAWING.SDR SWAA042226Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 930, STRINGER 25R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042201Battery · inoperativeDURING SCHEDULED RON, FOUND FWD ENTRY EMERGENCY EXIT LIGHTS RANDOMLY ILLUMINATE. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA042126Battery · inoperativeDURING SCHEDULED A2 CHECK, FOUND AFT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA042106Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND KEEL BEAM OUTER FLANGE AT BS 718 TO BS 726, LBL 11, CORRODED. REPAIRED KEEL BEAM FLANGE PER EA.SDR SWAA042111Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 927, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042096Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM WEB AT BS 663, RBL 39, CRACKED. REPAIRED FLOORBEAM WEB PER SRM.SDR SWAA042077Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND AFT SERVICE DOOR CUTOUT FWD LOWER CORNER, CRACKED. REPAIRED DOOR CUTOUT PER EA.SDR SWAA042037Snubber · inoperativeL2 DOOR WILL NOT OPEN. REMOVED AND REPLACED L2 DOOR SNUBBER PER MM.SDR SWAA042043Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 664, LBL 31.5, CRACKED. REPAIRED PRESSURE WEB PER SRM.SDR SWAA042042Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR CUTOUT LOWER FWD CORNER, CRACKED. REPAIRED AFT ENTRY DOOR CUTOUT PER EA.SDR SWAA042027Cover · damagedEEPLS COVER AT ROW 1 ABC, DISCOLORED. REMOVED AND REPLACED EEPLS COVER PER MM.SDR SWAA042024Slide · out of adjustDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA042023Structure · crackedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO DOOR LOWER T-CHORD, CRACKED. REMOVED AND REPLACED T-CHORD PER SRM.SDR SWAA042031Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME, LOWER AFT CORNER CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA042020Skin · delaminatedDURING SCHEDULED A1 CHECK, FOUND LT WING OUTBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED LT OUTBOARD AFT T/E FLAP PER MM.SDR SWAA041982Cover · damagedDURING SCHEDULED C2 CHECK, FOUND EEPLS COVER AT ROW 7 ABC, DAMAGED. REMOVED AND REPLACED EEPLS COVER PER MM.SDR SWAA041969Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN AT BS 516, STRINGER 16R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041879Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 935, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041837Slide · out of adjustDURING SCHEDULED PM CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041836Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 935, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041825Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 946, STRINGER 24L. REPAIRED SKIN PER SWS EA.SDR SWAA041801Floorbeam · corrodedDURING OTS, FOUND FLOORBEAM AT BS 270, LBL 4, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA041758Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 944, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041726Slide · dislodgedR2 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041687Slide · dislodgedR2 DOOR EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA041686Lens · looseLEFT OVERWING EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS COVER PER MM.SDR WVE2004F00020Frame · crackedLT FS 718 BETWEEN STRINGERS 10L AND 12L IS CRACKED 1 INCH LING IN RADIUS OF FRAME FLANGE. POSSIBLE STRESS RELIEF CRACK. REPAIR IAW REO 601R-53-61-193 REV A. (EA09200402463)SDR WVE2004F00019Frame · crackedRT FS 718 BETWEEN STRINGERS 10R AND 12R IS CRACKED 1 INCH LONG IN RADIUS OF FRAME FLANGE. POSSIBLE STRESS RELIEF CRACK. REPAIR IAW MFG REO 601R5-53-61-193 REV A.SDR SWAA041665Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 AND R2 DOOR EVAC SLIDE CABLES MISROUTED. REROUTED L2 AND R2 DOOR EVAC SLIDE CABLES PER MM.SDR SWAA041664Strip · wornDURING SCHEDULED C2 CHECK, FOUND EEPLS FLOOR STRIP AT ROW 10 ABC TO ROW 13 ABC, WORN. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA041640Slide · out of adjustDURING SCHEDULED A2 CHECK, FOUND L2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L2 DOOR EVAC SLIDE PER MM.SDR SWAA041598Strip · looseEEPLS PHOTOLUMINESCENT STRIP AT ROW 7 ABC, LOOSE. SECURED PHOTOLUMINESCENT STRIP PER MM.
Back to Boeing 737-5H4