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 SWAA113319Web · crackedDURING SCHEDULED 22Y CHECK FOUND CRACKS FLIGHT DECK FLOOR WEB, BS 247 RBL 24. REPAIRED PER DOC.SDR SWAA113195Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B+13, STRINGER 16L. REPAIRED SKIN PER EA.SDR SWAA113257Skin · crackedDURING SCHEDULED OTS CHECK FOUND FSLG SKIN CRACK AT FS 893, STR 25R. REPAIRED PER DOC.SDR SWAA113262Skin · delaminatedDURING SCHEDULED SPV CHECK FOUND RT INBD FOREFLAP METAL BOND REPAIR (UPPER SURFACE) DELAMINATED. REPAIRED RIGHT I/B FOREFLAP PER SRMSDR SWAA113261Battery · dischargedDURING SCHEDULED MV2 CHECK FOUND FWD CABIN BULL NOSE EMERGENCY LTS AND 3 FWD GALLEY EMERGENCY LTS INOP. REMOVED AND REPLACED EMERGENCY AND BATTERY CHARGER AS PER AMM.SDR SWAA113180Skin · crackedDURING SCHEDULED OTS CHECK, FOUND RT WING NR 6 SLAT LOWER SKIN CRACKED AT O/B END. REPAIRED SKIN PER SRM.SDR SWAA113260Skin · crackedDURING SCHEDULED MV1 CHECK FOUND CRACK IN FUSELAGE SKIN STA 492, STR 162. REPAIRED PER SRM.SDR SWAA113259Skin · crackedDURING SCHEDULED MV1 CHECK FOUND FUSELAGE CRACK AT STA 843 JUST ABOVE STR 16L CRACK. REPAIRED PER SRM.SDR SWAA113189Coffeemaker · faultyON DESCENT FLIGHT ATTENDANT REPORTED A STRONG ELECTRICAL SMELL IN AFT GALLEY. REMOVED AND REPLACED COFFEEMAKER PER MM.SDR SWAA113150Shear Web · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR WEB CORRODED BETWEEN BS 380 TO BS 400, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA113065Skin · delaminatedDURING SCHEDULED OTS CHECK, FOUND RT WING I/B FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA113258Shear Tie · corrodedDURING SCHEDULED OTS CHECK FOUND CORROSION ON SHEAR TIE BS 867 STR 26 - 27 RT. REMOVED CORROSION ON SHEAR TIE PER SRM.SDR SWAA112983Connector · looseFWD EMERGENCY EXIT LIGHT INOP. SECURED CONNECTOR ON BATTERY PACK PER MM.SDR SWAA113055Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 492, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA113054Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 843, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA112847Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA112846Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND RT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA112844Shear Tie · corrodedDURING SCHEDULED OTS CHECK, FOUND SHEAR TIE CORRODED AT BS 987, BETWEEN STR 24L TO STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA112892Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA112845Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND RT OVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 1. RELAMPED LIGHT PER MM.SDR SWAA112790Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 10R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA112789Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 787, STR 8R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112788Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112787Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112786Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727C, STR 9R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112785Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112784Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112783Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727A, STR 6R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112782Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 639, STR 1. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112781Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 597, STR 9R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112780Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 520, STR 9R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112779Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 380, STR 8R. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112778Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112777Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112776Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 440, STR 8L. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112775Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 400, STR 8L. REMOVED AND REPLACED STRINGER PER SI.SDR SWAA112736Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112636Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 440 AT UPPER STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA112635Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112634Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CHORD CRACKED AT BS 616, WL 208. REMOVED AND REPLACED CHORD PER EA.SDR SWAA112633Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112632Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 767+3, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA112631Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 767+7, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA112550Battery · dischargedDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA112493Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 380+16, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA112492Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 967+5, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA112491Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 927+6, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA112490Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 747+16, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA112489Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 747+13, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA112488Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 747+7, STR 24L. REPAIRED SKIN PER SRM.
Back to Boeing 737-5H4