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 SWAA043557Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM BETWEEN BS 400 AND BS 420, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION PER EA.SDR SWAA043556Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING LOWER RIB CHORD AT WBL 135.5, CRACKED. REPAIRED RIB CHORD PER ACO.SDR SWAA043555Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING LOWER RIB CHORD AT WBL 135.5, CRACKED. REPAIRED RIB CHORD PER ACO.SDR SWAA043538Hook · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EVAC SLIDE GIRT BAR AFT HOOK, CORRODED. REMOVED AND REPLACED GIRT BAR HOOK PER MM.SDR SWAA043537Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR FRAME STRINGER AT BS 360, STRINGER 14L, CRACKED. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA043531Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 797, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043512Skin · crackedFUSELAGE SKIN AT BS 517, STRINGER 17R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043509Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND BELT FRAME AT BS 616, STRINGER 17R, CRACKED. REPAIRED BELT FRAME PER T1-153-018.SDR SWAA043506Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT WINDOW CUTOUT, BS 482A + 10, STRINGER 13R, CRACKED. REPAIRED SKIN PER ER.SDR SWAA043494Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 380, STRINGER 20L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043493Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND R1 DOOR CUTOUT LOWER AFT CORNER SKIN CRACKED. REPAIRED SKIN PER ER.SDR SWAA043498Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND BUTT STRAP AT BS 907, STRINGER 4R, CRACKED. REPAIRED BUTT STRAP PER SRM.SDR SWAA043497Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT PRESSURE BULKHEAD AT BS 1016, BL 0, 4 INCHES ABOVE CENTER WEB, CRACKED. REPAIRED AFT BULKHEAD PER ER.SDR SWAA043496Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 10R AT BS 908, CRACKED. REPAIRED STRINGER SECTION PER SRM.SDR SWAA043495Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 797 AND BS 817, STRINGER 13L. REPAIRED SKIN SECTIONS PER ER.SDR SWAA043480Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND LT WING OUTBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED OUTBOARD T/E AFT FLAP PER MM.SDR SWAA043479Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED OUTBOARD T/E AFT FLAP PER MM.SDR SWAA043478Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 482, STRINGER 14R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043461Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH CRACKS ON FLOORBEAM WEB AND FLOORBEAM UPPER CAP AT CENTER FLOORBEAM, BS 663.75. REPAIRED FLOORBEAM CHORD AND UPPER CAP PER ER.SDR SWAA043453Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 445, STRINGER 10R, CRACKED. REPAIRED SKIN PER ACO.SDR SWAA043452Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH SHEAR TIES CRACKED AT BS 360, BETWEEN STRINGERS 13L AND 15L. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA043451Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS BETWEEN BS 767 AND BS 787, STRINGER 14R. REPAIRED SKIN SECTIONS PER SRM.SDR SWAA043450Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND BUTT STRAP AT BS 908, STRINGER 11L, CRACKED. REPAIRED BUTT STRAP PER SRM.SDR SWAA043430Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER FWD CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA043413Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L TO STR 20 R. REPAIRED FRAME PER SRM.SDR SWAA043407Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS STR 4R CRACKED AT BS 908. REPAIRED STRINGER ASSY PER SRM.SDR SWAA043406Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 482A FRAME CRACKED BETWEEN STR 20L & STR 21L. REPAIRED FRAME PER SRM.SDR SWAA043405Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 BULKHEAD WEB CRACKED AT LBL 6, WL 208. REPAIRED WEB PER SRM.SDR SWAA043400Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BOTH L1 DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA043384Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED PRESSURE WEB AT BS 663.75, LBL 39.5, CRACKED. REPAIRED PRESSURE WEB PER EA.SDR SWAA043364Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 932, STRINGER 23L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043350Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EACH CRACKS AT BS 1016 PRESSURE BULKHEAD DOME WEB CENTER SECTION AT 7 O'CLOCK AND 12 O'CLOCK POSITION. REPAIRED WEB SECTIONS PER EA.SDR SWAA043348Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 790, STRINGER 17L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043347Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 482 + 16, STRINGER 10L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043346Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE AT BS 360, BETWEEN STRINGERS 14L AND 15L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043345Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STINGER CLIP AT BS 706, STRINGER 10R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043335Carriage · wornWHEN FLAPS SELECTED TO 5 DEGREES, HALF WAY BETWEEN 2 & 5 DEGREES FELT VIBRATION, AS FLAPS MOVE INTO WHITE BAND OF 5 DEGREES, VIBRATION WORSE. REMOVED AND REPLACED RT INBOARD FORE FLAP INBOARD AND OUTBOARD CARRIAGES, PER MM.SDR SWAA043329Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA043315Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING LOWER RIB CHORD AT WBL 135.5, CRACKED. REPAIRED RT WING RIB CHORD PER EA.SDR SWAA043310Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED LT T/E AFT FLAP PER MM.SDR SWAA043309Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED RT T/E AFT FLAP PER MM.SDR SWAA043308Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA043300Lens · detachedFWD OVERHEAD EMERGENCY EXIT LIGHT LENS DETACHED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA043293Skin · delaminatedDURING SCHEDULED A1 CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED RT WING OUTBOARD T/E FLAP PER MM.SDR SWAA043292Cable · misroutedDURING SCHEDULED A1 CHECK, FOUND R2 AND L2 DOOR EVAC SLIDE GIRT BAR CABLES MISROUTED. REROUTED CABLES PER MM.SDR SWAA043291Skin · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 846, STRINGER 25R CORRODED. REPAIRED SKIN PER SRM.SDR SWAA043290Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 380, STRINGER 22L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043273Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER BETWEEN BS 695 AND BS 706, STRINGER 17L, CRACKED. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA043271Cover · looseEEPLS STRIP COVER FROM ROW 17 DEF TO ROW 19 DEF, LOOSE. REMOVED AND REPLACED EEPLS STRIP COVER PER MM.SDR SWAA043253Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STRINGER 21L REMOVED AND REPLACED STRINGER CLIPS PER SRM.
Back to Boeing 737-5H4