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 SWAA041586Web · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR FWD LOWER CORNER WEB, CRACKED. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA041463Lens · brokenDURING SCHEDULED PM CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT LENS AT ROW 11 ABC, BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA041455Slide · damagedR2 DOOR EVAC SLIDE HIGH PRESSURE INDICATION. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041446Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 663, RBL 40, CRACKED. REPAIRED BEADED PRESSURE WEB PER SRM.SDR SWAA041408Fastener · looseDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR EVAC SLIDE GIRT BAR HOOKS LOOSE. REMOVED AND REPLACED L1 DOOR EVAC SLIDE HOOK FASTENERS PER MM.SDR SWAA041401Pin · brokenAIR TURNBACK, AFTER TAKEOFF RIGHT MLG RED WARNING LIGHT ILLUMINATED, AND WITH GEAR LEVER IN OFF POSITION BOTH RED AND GREEN LIGHTS ILLUMINATED. CYCLED GEAR, NO HELP. REMOVED AND REPLACED RIGHT MLG TRUNNION PIN PER MM.SDR SWAA041400Circuit Card · faultyAFTER TAKEOFF THE RIGHT MLG RED WARNING LIGHT REMAINED ON, AND WITH MLG LEVER IN OFF POSITION BOTH RIGHT MLG RED AND GREEN LIGHTS ILLUMINATED. CREW CYCLED GEAR, ALL INDICATIONS NORMAL. CHECKED RESISTANCE ON PINS FROM GEAR LOGIC SHELF TO UPLOCK AND DOWNLOCK SSDR SWAA041391Lens · looseRT OVERWING EMERGENCY EXIT SIGN LENS, LOOSE. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA041390Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT R2 DOOR CUTOUT, LOWER FORWARD CORNER, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041376Sign · looseRT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED OVERWING SIGN PER MM.SDR SWAA041374Gate · crackedDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR UPPER GATE CRACKED. REMOVED AND REPLACED R1 DOOR UPPER GATE PER MM.SDR SWAA041346Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA041318Fitting · crackedDURING SCHEDULED A2 CHECK, FOUND NLG ACTUATOR ATTACH FITTING GUSSET, CRACKED. REMOVED AND REPLACED NLG FITTING PER SRM.SDR SWAA041277Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE DOOR CABLE PER MM.SDR SWAA041245Light · looseEEPLS LIGHT AT ROW 8 DEF LOOSE. SECURED LIGHT ASSEMBLY PER MM.SDR SWAA041229Lens · crackedDURING SCHEDULED PM CHECK, FOUND BULLNOSE LIGHT LENS AT ROW 8 ABC CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA041225Lens · looseDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT BULLNOSE LENS BETWEEN ROWS 16 DEF AND 17 DEF, LOOSE. SECURED BULLNOSE LIGHT LENS PER MM.SDR SWAA041204Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED SLIDE CABLE PER MM.SDR SWAA041203Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 944, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041202Shear Tie · crackedDURING SCHEDULED SERVICE CHECK, FOUND SHEAR TIE AT BS 520, STRINGER 10R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041201Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 524, STRINGER 10R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041131Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT LOWER FWD CORNER. REPAIRED SKIN PER EA.SDR SWAA041101Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM SECTION PER EA.SDR SWAA041100Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM AT BS 770, RBL3, CORRODED. REPAIRED BEAM PER EA.SDR SWAA041102Pressure Panel · crackedDURING SCHEDULED RON, FOUND NOSE W/W WEB AT LT BS 259, WL 174, CRACKED. REPAIRED WEB PER EA.SDR SWAA041086Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 937, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041085Lamp · inoperativeDURING SCHEDULED C2 CHECK, FOUND RT EMERGENCY EXIT LIGHT INOP. RELAMPED EMERGENCY EXIT LIGHT PER MM.SDR SWAA041084Girt Bar · looseDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR EVAC SLIDE GIRT BAR FWD FITTING RIVET, LOOSE. REMOVED AND REPLACED R1 DOOR EVAC SLIDE GIRT BAR FWD FITTING RIVET PER MM.SDR SWAA041066Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 428 + 13, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041030Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN BEHIND LT WING TO BODY FAIRING AT BS 767, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040969Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBOARD T/E FLAP DELAMINATED. REMOVED AND REPLACED RT WING OUTBOARD T/E FLAP PER MM.SDR SWAA040968Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING NR 2 LEADING EDGE SLAT DELAMINATED. REMOVED AND REPLACED LT WING NR 2 LEADING EDGE SLAT PER MM.SDR SWAA040923Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND MLG UPPER DECK BEADED WEB AT BS 665 TO BS 673, LBL 30 TO LBL 35, CRACKED. REPAIRED WEB PER SRM.SDR SWAA040922Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND COCKPIT NR 1 WINDOW LT POST, OUTBOARD UPPER CORNER CRACKED. REPAIRED WINDOW POST PER SRM.SDR SWAA040904Support · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM SUPPORT AT BS 660, BL 0, CRACKED. REPAIRED FLOORBEAM SUPPORT PER EA.SDR SWAA040866Bulkhead · crackedDURING SCHEDULED SPV, FOUND 3 EACH CRACKS AT BS 178 BULKHEAD WEB, LBL .57 TO RBL 17.1, WL 178 TO WL 230. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA040819Slide · looseL1 DOOR EVAC SLIDE INADVERTENTLY PULLED FROM CASE. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040818Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040827Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED R2 DOOR EVAC SLIDE CABLE PER MM.SDR SWAA040826Lens · crackedDURING SCHEDULED C2 CHECK, FOUND FWD EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED FWD LIGHT LENS PER MM.SDR SWAA040798Slide · out of adjustR2 DOOR EVACUATION SLIDE PRESSURE INDICATOR OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.SDR SWAA040758Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STRINGER 21L AND BS 938, STRINGER 23R. REPAIRED SKIN PER SRM.SDR SWAA040729Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND NR 3 L/E SLAT LOWER SKIN SURFACE CRACKED 30 INCHES FROM INBD END. REPAIRED SLAT SKIN PER SRM.SDR SWAA040712Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA040711Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND UPPER MLG W/W BEADED WEB CRACKED AT BS 665, OUTBD OF NR 2 SEAT TRACK. REPAIRED WEB PER SWA EA.SDR SWAA040710Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR AFT LOWER CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA040687Slide · out of adjustL2 DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA040682Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR LOWER FRAME CRACKED AT STOP FITTING. REPAIRED FRAME PER BAC DRAWING.SDR SWAA040681Lens · looseDURING SCHEDULED 1/4D CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA040680Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR AFT FRAME CRACKED AT STOP FITTINGS. REMOVED AND REPLACED R1 DOOR PER MM.
Back to Boeing 737-5H4