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 SWAA043252Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME AT BS 480, BETWEEN STRINGER 20R AND STRINGER 21R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA043242Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED RT OUTBOARD T/E AFT FLAP PER MM.SDR SWAA043241Cable · misroutedDURING SCHEDULED A2 CHECK, FOUND L2 AND R2 DOOR EVAC SLIDES GIRT BAR CABLES MISROUTED. REROUTED L2 AND R2 DOOR EVAC CABLES PER MM.SDR SWAA043212Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED RIGHT INBOARD T/E AFT FLAP PER MM.SDR SWAA043191Cover · looseEEPLS LIGHT STRIP FROM ROW 1 ABC TO ROW 3 ABC, LOOSE. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA043148Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CENTER WING LONGITUDINAL BEAM CRACKED AT BS 616, LBL 45.57. REPAIRED BEAM PER SWA EA.SDR SWAA043147Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING UPPER RIB CHORD CRACKED AT WBL 135.5, STR 2. REPAIRED RIB CHORD PER SWA EA.SDR SWAA043146Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 16L. REPAIRED FRAME PER SWA EA.SDR SWAA043133Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM FWD FLANGE AT BS 946, LBL 54, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA043132Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH FRAMES CRACKED AT BS 663.75, STRINGER 14R AND STRINGER 14L. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA043138Guide Vane · crackedDURING SCHEDULED C3 CHECK, FOUND NR 1 ENG 1ST STAGE LPT NGV CRACKED AT L/E. REMOVED AND REPLACED NR 1 ENG PER MM.SDR SWAA043118Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR AFT FRAME NEAR 4TH STOP FITTING FROM BOTTOM, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA043117Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 749, STRINGER 18L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043101Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING LOWER RIB CHORD AT WING STATION 135.5, BETWEEN STRINGER 2 AND STRINGER 3, CRACKED. REPAIRED RT WING RIB CHORD PER EA.SDR SWAA043100Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR CUTOUT FWD LOWER FRAME WEB CRACKED. REMOVED AND REPLACED FRAME WEB SECTION PER SRM.SDR SWAA043099Gusset · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR LOWER FWD FRAME AT LOWER STOP FITTING GUSSET CRACKED. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA043098Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM CHORD PER EA.SDR SWAA043078Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 971, STRINGER 21L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043070Stiffener · corrodedDURING SCHEDULED SERVICE CHECK, FOUND FLOOR STIFFENER UPPER CHORD AT BS 270, LBL 6, WL 207.5, CORRODED. REPAIRED FLOOR STIFFENER UPPER CHORD PER EA.SDR SWAA043062Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR LOWER FRAME AT AFT INBOARD LOWER STOP CRACKED. REMOVED AND REPLACED SERVICE DOOR PER MM.SDR SWAA043061Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 663.75, STRINGER 10L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043060Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 907 + 8, RBL 3, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA043018Gusset · crackedDURING SCHEDULED SERVICE CHECK, FOUND NLG ACTUATOR UPPER ATTACH FITTING GUSSET CRACKED. REMOVED AND REPLACED NLG ACTUATOR GUSSET PER SRM.SDR SWAA042976Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 967, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042965Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 470, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042968Fan · faultyAIR TURNBACK, F/A AND PAX COMPLAINED OF BURNING SMELL. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA042915Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, BELOW STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA042909Lamp · inoperativeDURING SCHEDULED C4 CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT AT ROW 2 DEF, INOP. RELAMPED LIGHT PER MM.SDR SWAA042908Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 877, STRINGER 24R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042833Skin · delaminatedRT WING NR 5 GROUND SPOILER DELAMINATED. REMOVED AND REPLACED RT NR 5 GROUND SPOILER PER MM.SDR SWAA042832Skin · delaminatedLEFT WING NR 4 GROUND SPOILER DELAMINATED. REMOVED AND REPLACED LEFT WING NR 4 GROUND SPOILER PER MM.SDR SWAA042800Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 749, STRINGER 18L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042787Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING OUTBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED LT AFT T/E FLAP PER MM.SDR SWAA042708Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING INBOARD T/E FLAP DELAMINATED. REMOVED AND REPLACED RT WING INBOARD T/E FLAP PER MM.SDR SWAA042650Slide · dislodgedR1 DOOR EVAC SLIDE FELL OUT, DID NOT DEPLOY. REINSTALLED R1 DOOR EVAC SLIDE PER MM.SDR SWAA042635Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 790, STRINGER 18L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042634Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 482, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042616Lens · brokenDURING SPV, FOUND BULL NOSE EMERGENCY EXIT LIGHT LENS AT ROW 2 DEF, BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA042598Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE EMERGENCY EXIT OVERHEAD LIGHT AND AFT ENTRY SIDEWALL EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA042597Power Supply · inoperativeDURING SCHEDULED PM CHECK, FOUND AFT ENTRY AND AFT SERVICE EMERGENCY EXIT OVERHEAD LIGHTS INOP. REMOVED AND REPLACED BATTERY POWER SUPPLY PER MM.SDR SWAA042586Slide · dislodgedL1 DOOR EVACV SLIDE FELL OUT, DID NOT DEPLOY. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA042582Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 L/E SLAT, DELAMINATED. REPAIRED SLAT PER EA.SDR SWAA042568Skin · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 467, BETWEEN STRINGER 28L AND STRINGER 28R, CORRODED. REPAIRED SKIN PER EA.SDR SWAA042556Skin · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 467, BETWEEN STRINGER 28L AND STRINGER 28R, CORRODED. REPAIRED SKIN PER EA.SDR SWAA042555Structure · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME UPPER HINGE BOX FITTING CUTOUT AT LOWER CORNER, CRACKED. REPAIRED HINGE BOX FITTING PER EA.SDR SWAA042554Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR AFT FRAME AT 3RD STOP, CRACKED. REPAIRED DOOR FRAME PER SRM.SDR SWAA042552Tab · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING AILERON TAB DELAMINATED. REMOVED AND REPLACED RT AILERON TAB PER MM.SDR SWAA042525Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA042524Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 663, RBL 36, CRACKED. REPAIRED WEB PER SRM.SDR SWAA042512Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME FWD OF TORQUE TUBE ACCESS PANEL UPPER FASTENER HOLE, CRACKED. REPAIRED DOOR FRAME PER SRM.
Back to Boeing 737-5H4