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 SWAA053992Bear Strap · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN BEAR STRAP CORRODED AT FWD CARGO DOOR CUTOUT UPPER CORNERS. REPAIRED SKIN PER SRM.SDR SWAA053991Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE BULKHEAD WEB CRACKED AT BS 178, RBL 5.7, WL 187. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA053976Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053975Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA053958Sign · looseRT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA053957Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053946Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 320, R1 DOOR CUTOUT, AFT LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA053945Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 660, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053944Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 46.5 TO LBL 46.5. REMOVED AND REPLACED FLOORBEAM UPPER CAP PER SRM.SDR SWAA053929Stiffener · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BULKHEAD ANGLE STIFFENER CORRODED AT BL 0. REPAIRED ANGLE STIFFENER PER ACO & SRM.SDR SWAA053928Stiffener · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BULKHEAD CHANNEL STIFFENER CORRODED AT BL 0. REPAIRED CHANNEL STIFFENER PER ACO & SRM.SDR SWAA053927Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 328, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA053914Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD ATTACH MOUNT BRACKET CRACKED. REMOVED AND REPLACED MOUNT BRACKET PER MM.SDR SWAA053913Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BLKHD DOME WEB PANEL NR 6 CRACKED AT 9 O'CLOCK POSITION. REPAIRED DOME WEB PER SWA EA.SDR SWAA053892Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OTBD T/E AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA053788Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 947.5, LBL 16 TO RBL 6. REPAIRED FLOORBEAM PER SRM.SDR SWAA053764Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 1016, RBL 12 TO RBL 36. REPAIRED FLOORBEAM PER SRM.SDR SWAA053763Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053762Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, STR 14R TO STR 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA053765Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA053736Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053735Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM UPPER CHORD CRACKED AT BS 294.5, LBL 22 TO LBL 27. REPAIRED FLOORBEAM PER SRM.SDR SWAA053734Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 520, STR 10R. REPAIRED STRINGER PER SWA EA.SDR SWAA053733Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 405, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA053710Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE LOWER SKIN CORRODED BETWEEN BS 465 TO BS 471, AT NR 1 DME ANTENNA. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA053709Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 482, STR 21L. REPAIRED BELTFRAME PER SWA EA.SDR SWAA053708Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 482A, STR 21L. REPAIRED BELTFRAME PER SWA EA.SDR SWAA053707Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA053713Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA053712Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA053711Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 844, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA053689Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 967, RBL 18 TO RBL 42. REPAIRED FLOORBEAM PER SRM.SDR SWAA053688Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 2 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA053687Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053685Wire · brokenDURING SCHEDULED SPECIAL VISIT, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REPAIRED WIRE NR W1150-559-20 PER WDM AND MM.SDR SWAA053684Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA053683Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME LOWER CORNER. REPAIRED FRAME PER BFG ER.SDR SWAA053660Stiffener · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BLKHD STIFFENER CHANNEL CORRODED AT 6 O'CLOCK POSITION. REPAIRED STIFFENER CHANNEL PER SWA ACO AND BAC DRAWING.SDR SWAA053659Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 344, BETWEEN BL 0 TO LBL 7.REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053658Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 328, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053657Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 312, RBL 35. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053656Door Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053655Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 361.5, STR 17L. REPAIRED SKIN PER BFG ER.SDR SWAA053686Link · brokenEXTREME VIBRATION FELT AFTER LANDING. FOUND RT MLG UPPER TORSION LINK BROKEN. RT MLG SHIMMY DAMPNER SHAFT BENT. RT MLG LOWER STRUT WARPED. NR 3 AND NR 4 MLG TIRES DAMAGED. NR 1, NR 3, NR 4 AND NR 6 L/E SLATS DAMAGED. REMOVED AND REPLACED RT MLG ASSY, RT SDR SWAA053639Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 663, LBL 32. REPAIRED WEB PER SRM.SDR SWAA053638Post · crackedDURING SCHEDULED 1/2D CHECK, FOUND L1 COCKPIT WINDOW POST CRACKED AT UPPER OUTBOARD CORNER. REPAIRED WINDOW POST PER SRM.SDR SWAA053627Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA053587Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME AT NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053586Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME AT STOP FITTING, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA053588Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 304, STR 19R. REPAIRED SKIN PER SWA EA AND SRM.
Back to Boeing 737-5H4