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 SWAA092785Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 782.5 TO BS 785, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA092826Wire · chafedDECLARED EMERGENCY. PRESSURIZATION LOST AT 36,000FT, CABIN AT 10,000FT INITIALLY. QRH FOLLOWED & DESCENT INITIATED. CABIN CONTROLLABLE ONLY IN MANUAL DESCENT. MASKS DEPLOYED AUTOMATICALLY. FOUND OUTFLOW VALVE WIRE CHAFED AT AFT CARGO COMPT. REPAIRED PER SDR SWAA092818Lens · looseDURING SCHEDULED MV2 CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT LOOSE AT ROW 15. REMOVED AND REPLACED LENS PER MM.SDR SWAA092754Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 304, WL 238. REPAIRED SKIN PER SWA EA.SDR SWAA092753Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 303, WL 238. REPAIRED SKIN PER SWA EA.SDR SWAA092752Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 304, WL 257. REPAIRED SKIN PER SWA EA.SDR SWAA092747Light · looseBULLNOSE EMERGENCY EXIT LIGHT LOOSE AT ROW 15. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA092690Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 972 TO BS 973, ABOVE STR 24L. REPAIRED SKIN PER SRM.SDR SWAA092672Charger · inoperativeEMERGENCY EXIT LIGHTS CAME ON WITH THE EMERGENCY EXIT LIGHT SWITCH IN THE ARMED POSITION. ALL C/B'S CHECK, ALL ELECTRICAL BUSSES POWERED NORMALLY. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA092666Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 930, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA092665Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 871, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA092654Skin · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 360, STR 1L. REPAIRED SKIN PER SRM.SDR SWAA092653Flap · delaminatedDURING SCHEDULED 2HC1 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA092652Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 911, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA092630Skin · crackedDURING MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 519, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA092629Skin · crackedFUSELAGE SKIN CRACKED AT BS 482A, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA092578Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT AFT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA092557Strip · looseEEPLS CLEAR STRIP LOOSE. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA092548Outflow Valve · inoperativeDIVERSION, CABIN PRESSURE CONTROLLER INOP. REMOVED AND REPLACED OUTFLOW VALVE PER MM.SDR SWAA092514Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 954, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA092513Landing Gear · obstructedAIR TURNBACK, LT MLG FAILED TO FULLY RETRACT AFTER TAKEOFF. CYCLED GEAR SEVERAL TIMES, NO HELP. GEAR GOES DOWN AND LOCKED NORMALLY. FOUND GEAR IMPACTED WITH ICE. REMOVED ICE PER MM.SDR SWAA092490Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT OVERWING EXTERNAL EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA092363Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED SLIDE PER MT.SDR SWAA092307Slide · out of positionR2 DOOR EVAC SLIDE FELL OUT OF CONTAINER, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MM.SDR SWAA092028Ballast · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BALLAST PER MM.SDR SWAA091948Fuse · blownL1 DOOR LIGHT INOP. REMOVED AND REPLACED FUSE PER MM.SDR SWAA091950Light · missingR2 DOOR EMERGENCY EXIT LIGHT MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA091949Cover · missingDURING SCHEDULED MV2 CHECK, FOUND RT WING EMERGENCY EXIT LIGHT COVER MISSING. REMOVED AND REPLACED COVER PER MM.SDR SWAA091920Skin · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT ELEVATOR TAB LOWER SURFACE O/B END DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA091919Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 739A, RBL 23, WL 208. REPAIRED BEAM PER AAR EA.SDR SWAA091856Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF COMPARTMENT, DID NOT DEPLOY. INSTALLED SLIDE PER MT.SDR SWAA091740Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 767, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA091734Bulkhead · crackedDURING SCHEDULED MV1 CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7, WL 182. REPAIRED WEB PER SWA EA.SDR SWAA091733Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 783, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA091709Window · arcedON APPROACH OBSERVED L1 WINDSHIELD SPARKING. WINDOW HEAT WORKED NORMAL. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA091696Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727A, RBL 23, WL 208. REPAIRED BEAM PER AAR EA.SDR SWAA091671Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 663, RBL 24, WL 207. REPAIRED BEAM PER SWA EA.SDR SWAA091670Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 665, LBL 25, WL 207. REPAIRED BEAM PER SWA EA.SDR SWAA091669Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 661, BBL 0, BETWEEN WL 208 TO WL 207. REPAIRED BEAM PER SWA EA.SDR SWAA091668Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 661, BETWEEN RBL 1 TO LBL 1, WL 208. REPAIRED BEAM PER SWA EA.SDR SWAA091612Support Beam · crackedDURING SCHEDULED 18Y CHECK, FOUND MLG WHEEL WELL AFT BULKHEAD SUPPORT BEAM CRACKED AT BS 728, LBL 47. REPAIRED BEAM PER SRM.SDR SWAA091602Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LT FLOORBEAM VERTICAL WEB CRACKED AT BS 710.5, BBL 0, WL 203. REPAIRED WEB PER SI.SDR SWAA091601Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 291, WL 254, RT SIDE. REPAIRED SKIN PER ER.SDR SWAA091553Skin · crackedDURING SCHEDULED SPV CHECK, FOUND GALLEY DOOR SKIN CUTOUT CRACKED AT BS 291, WL 254. REPAIRED SKIN PER ER.SDR SWAA091415Sign · looseRT OVERWING EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED SIGN PER MM.SDR SWAA091379Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA091346Bear Strap · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT BS 303, WL 257. REPAIRED SKIN PER EA.SDR SWAA091291Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 882, STR 25R. REPAIRED SKIN PER SRM & EA.SDR SWAA091293Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER AND BATTERY PACK PER MM.SDR SWAA091292Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT WING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED M1136 MODULE AND BATTERY PACK PER MM.
Back to Boeing 737-5H4