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 SWAA095551Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT RADIO ALTIMETER CUTOUT, BETWEEN BS 410 TO BS 450. REPAIRED SKIN PER AAR EA.SDR SWAA095534Lens · missingDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LIGHT ASSY PER MM.SDR SWAA095533Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM LOWER CHORD CORRODED AT BS 482. REPAIRED BEAM PER SRM.SDR SWAA095528Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT MLG BEAM CORRODED ON LOWER SURFACE. REPAIRED BEAM PER AAR EA.SDR SWAA095527Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED. REMOVED AND REPLACED SKIN PER SWA WA.SDR SWAA095526Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND CLIP ASSY CRACKED AT BS 300.5, WL 259. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095519Tab · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING AILERON TAB AFT I/B CORNER DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA095518Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA095517Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA095513Module · faultyDECLARED EMERGENCY, SMOKE AND FUMES FILLED AIRCRAFT WHEN INITIATING DESCENT FROM FL 350. SMOKE DISSIPATED AFTER RUNNING SMOKE AND FUMES CHECKLIST. REMOVED AND REPLACED HYDRAULIC SYS PRESSURE MODULE, CHECK VALVES, AND COALESCER BAGS.SDR SWAA095511Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA095405Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR SKIN CRACKED. REPAIRED SKIN PER AAR EA.SDR SWAA095404Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706, RBL 24.5. REPAIRED WEB PER SWA EA.SDR SWAA095402Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA095401Flap · puncturedDURING SCHEDULED 20Y CHECK, FOUND LT WING O/B FORE FLAP L/E PUNCTURED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA095377Fitting · looseDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT FLOOR GIRT BAR LATCH FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA095374Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA095373Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 303, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095376Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 762, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA095375Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 499, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA095336Attach Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND LT LOWER FUSELAGE UNDER L1 DOOR CUTOUT, STUB FRAME TO WEB ATTACH ANGLE CRACKED BS 320, LBL 58. REPAIRED ANGLE PER BAC DWG.SDR SWAA095335Attach Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND LT LOWER FUSELAGE UNDER L1 DOOR CUTOUT, STUB FRAME TO WEB ATTACH ANGLE CRACKED BS 328, LBL 58. REPAIRED ANGLE PER BAC DWG.SDR SWAA095329Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA095337Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 977, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA095264Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND BULKHEAD ATTACH CHORD CORRODED AT BS 219, BETWEEN BL 0 TO LBL 5. REPAIRED CHORD PER AAR EA.SDR SWAA095230Wedge · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 3 SLAT T/E WEDGE UPPER SURFACE DELAMINATED. REMOVED AND REPLACED WEDGE PER SRM.SDR SWAA095263Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 670 TO BS 675, RBL 24.5. REPAIRED CHORD PER SWA EA.SDR SWAA095162Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.SDR SWAA095161Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING LOWER RIB CHORD CRACKED, WBL 135.5, BETWEEN S2 TO S3. REPAIRED CHORD PER ACO.SDR SWAA095139Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 819, BETWEEN STR 22L TO STR 23L. REPAIRED SKIN PER SRM.SDR SWAA095092Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 916, STR 24L. REPAIRED SKIN PER AAR EA.SDR SWAA095087Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA095140Skin · crackedDURING HC1 CHECK, FOUND SKIN CRACKED AT BS 727D, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA095078Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA095124Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 750, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA095067Slide · unserviceableDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA095044Web · corrodedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO PIT FLOORBEAM VERTICAL SUPPORT WEB CORRODED BETWEEN BS 927 TO BS 947, STR 26R. REMOVED AND REPLACED WEB PER BAC DWG.SDR SWAA095043Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 943, STR 23L. REPAIRED SKIN PER AAR EA.SDR SWAA095023Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095007Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND LT AFT EMERGENCY EXIT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA095006Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706, LBL 24.5. REMOVED AND REPLACED WEB PER AAR EA.SDR SWAA095005Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095004Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095003Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095002Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095001Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095000Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094999Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094998Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094984Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-5H4