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 SWAA091242Spindle · wornDURING T/E FLAP EXTENSION FELT RIGHT ROLL REQUIRING RUDDER TRIM OF 2-3 UNITS. FOUND NR 7 T/E FLAP SPINDLE BEARING WORN. REMOVED AND REPLACED FLAP CARRIAGE & SPINDLE BEARING ASSY PER MM.SDR SWAA091249Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 794.2, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA091240Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727C+16 TO 727D, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA091239Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA091336Battery Pack · inoperativeFWD I/B EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA091200Bear Strap · corrodedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO DOOR BEAR STRAP SKIN CUTOUT CORRODED AT BS 450, STR 24R. REPAIRED SKIN PER ER.SDR SWAA091199Housing · brokenDURING SCHEDULED HC1 CHECK, FOUND LT EMERGENCY LIGHT BATTERY PACK HOUSING BROKEN. REMOVED AND REPLACED HOUSING PER MM.SDR SWAA091171Lens · out of positionL1 DOOR EMERGENCY EXIT LIGHT LENS FELL OFF. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA091111Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT EEPLS SIDEWALL LIGHT INOP. RELAMPED PER MM.SDR SWAA091098Sense Line · puncturedAIR TURNBACK / DECLARED EMERGENCY. ON TAKEOFF HAD 0 FAULT LIGHT ON FIRE DETECT SYS. THIS WAS FOLLOWED BY A NR 2 ENG OVERHEAT AND A NR 2 FIRE LIGHT. BOTH THE ENG OVERHEAT LIGHT AND FIRE LIGHT AS WELL AS THE FAULT LIGHT EXTINGUISHED WITHIN SECONDS. REMOVED ASDR SWAA091093Light · not seatedDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. RESEATED BULB PER MM.SDR SWAA091048Bear Strap · crackedDURING SCHEDULED 16Y CHECK, FOUND LT BEAR STRAP UPPER HINGE CUTOUT SKIN CRACKED AT BS 303, WL 257. REPAIRED SKIN PER AAR EA.SDR SWAA091047Stiffener · crackedDURING SCHEDULED 16Y CHECK, FOUND MLG BULKHEAD VERTICAL STIFFENER CRACKED AT BS 727, LBL 6. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA091046Stiffener · crackedDURING SCHEDULED 16Y CHECK, FOUND MLG BULKHEAD VERTICAL STIFFENER CRACKED AT BS 727, RBL 6. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA091008Bear Strap · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO BAY BEAR STRAP SKIN CORRODED AT BS 847, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN PER ER.SDR SWAA091007Pressure Panel · damagedDURING SCHEDULED 16Y CHECK, FOUND NOSE WHEEL WELL CEILING WEB DAMAGED AT BS 277, RBL 16. REPAIRED WEB PER EA.SDR SWAA090990Web · crackedDURING SCHEDULED HC1 CHECK, FOUND PRESSURE DECK ATTACHMENT WEB CRACKED AT BS 665, WL 204, RBL 41. REPAIRED WEB PER SRM.SDR SWAA090918Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA090917Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA090916Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 892, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA090915Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 931, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA090914Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND RT HORIZONTAL STABILIZER SKIN CRACKED. REPAIRED SKIN PER AAR EA.SDR SWAA090913Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND RADIO ALTIMETER CUTOUT BELLY SKIN CRACKED AT BS 410. REPAIRED SKIN PER AAR EA.SDR SWAA090912Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND RADIO ALTIMETER CUTOUT BELLY SKIN CRACKED AT BS 350. REPAIRED SKIN PER AAR EA.SDR SWAA090911Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND RADIO ALTIMETER CUTOUT BELLY SKIN CRACKED AT BS 390. REPAIRED SKIN PER AAR EA.SDR SWAA090910Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND NR 1 DME CUTOUT BELLY SKIN CORRODED BETWEEN BS 410 TO BS 465, LBL 0. REPAIRED SKIN PER SRM.SDR SWAA090909Wire · brokenDURING SCHEDULED 16Y CHECK, FOUND LT EMERGENCY EXIT LIGHT WIRE BROKEN AT MID CABIN. REPAIRED WIRE PER SWPM.SDR SWAA090896Light · inoperativeDURING SCHEDULED CV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA090895Strip · damagedDURING SCHEDULED CV CHECK, FOUND EEPLS STRIP DAMAGED BETWEEN ROW 11 TO ROW 17. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA090856Cover · looseDURING SCHEDULED SPV CHECK, FOUND RT SIDE EMERGENCY EXIT LIGHT COVER LOOSE. SECURED COVER PER MM.SDR SWAA090855Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 348, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA090854Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BETWEEN BS 303 TO BS 305. REPAIRED SKIN PER AAR EA.SDR SWAA090848Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN ANGLE CRACKED AT BS 188, STR 17L. REPAIRED ANGLE PER SRM.SDR SWAA090828Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 348, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA090773Keelbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND KEEL BEAM CORRODED AT BS 482, STR 28L. REPAIRED BEAM PER SRM.SDR SWAA090772Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482, BETWEEN STR 28L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA090883Control Cable · out of adjustABORTED TAKEOFF. ON TAKEOFF ROLL WITH ENGINE STABILIZED AT TAKEOFF N1 AIRCRAFT PULLED TO RIGHT. TAKEOFF REJECTED, STEERING OK WITH TILLER. ADJUSTED CABLE TENSION ON NOSE WHEEL STEERING CABLES NWSA/NWSB AND CHECKED RIG PER MM.SDR SWAA090707Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA090664Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD ENTRY DOOR ANGLE CRACKED AT BS 300, STR 11L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA090659Web · crackedDURING SCHEDULED 16Y CHECK, FOUND COCKPIT FLOOR WEB CRACKED AT BETWEEN BS 188 TO BS 196, STR 17L. REMOVED AND REPLACED WEB PER DWG.SDR SWAA090652Mount Bracket · crackedDURING SCHEDULED 16Y CHECK, FOUND R2 DOOR EMERGENCY EVACUATION SLIDE MOUNT BRACKETS CRACKED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA090651Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOOR SUPPORT FRAME CRACKED AT BS 706, BETWEEN LBL 24 TO LBL 63. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA090650Support Angle · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER WEB SUPPORT ANGLE CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA090649Light · crackedDURING SCHEDULED 18Y CHECK, FOUND AFT EMERGENCY EXIT LIGHT CRACKED. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA090648Attach Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND LT VERTICAL STABILIZER ATTACH FITTING LUGS CORRODED. REPAIRED FITTING PER SRM.SDR SWAA090647Lug · corrodedDURING SCHEDULED 18Y CHECK, FOUND RT VERTICAL STABILIZER ATTACH FITTING LUGS CORRODED. REPAIRED FITTING PER SRM.SDR SWAA090646Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 303, WL 258. REPAIRED SKIN PER AAR EA.SDR SWAA090645Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 303, WL 261. REPAIRED SKIN PER AAR EA.SDR SWAA090510Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 16L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA090509Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.
Back to Boeing 737-5H4