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 SWAA083589Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA083559Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA083558Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, BL 0. REPAIRED SKIN PER SRM.SDR SWAA083527Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA083467Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA083428Light · looseEEPLS STRIP LOOSE AT ROW 7 DEF. SECURED STRIP PER MM.SDR SWAA083427Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA083313Lens · out of positionBULLNOSE EMERGENCY EXIT LIGHT LENS FELL OFF AT ROW 21 DEF. INSTALLED LENS PER MM.SDR SWAA083311Pin · corrodedDURING SCHEDULED SPV CHECK, FOUND RT MLG TRUNNION PIN CORRODED. REMOVED AND REPLACED PIN PER MM.SDR SWAA083312Link · corrodedDURING SCHEDULED SPV CHECK, FOUND RT MLG TRUNNION LINK CORRODED. REMOVED AND REPLACED LINK PER MM.SDR SWAA083290Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA083261Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA083260Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA083262Battery · faultyDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT STAYS ON ALL THE TIME. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA083258Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 420 AND BS 440, STR 1. REPAIRED SKIN PER EA.SDR SWAA083259Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA083189Wire · chafedAIR TURNBACK/DECLARED EMERGENCY, AFTER ROTATION SMELLED SMOKE IN COCKPIT. INSPECTED AIRCRAFT FOUND WIRE BUNDLE AT P5 PANEL CHAFFED. REPAIRED WIRE CONNECTOR AT PANEL PER WDM.SDR SWAA083103Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 798, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA082903Battery · inoperativeFWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA082829Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER EA.SDR SWAA082865Lens · missingDURING SCHEDULED 16Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 20 DEF. INSTALLED LENS PER MM.SDR SWAA082830Battery · dischargedDURING SCHEDULED 16Y CHECK, FOUND FWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA082864Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 755, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA082878Battery · dischargedAFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA082875Glowstrip · delaminatedDURING SCHEDULED BRDG CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP DELAMINATED AT ROW 10 ABC. REMOVED AND REPLACED STRIP PER MM.SDR SWAA082877Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND NLG W/W CEILING PANEL WEB CRACKED AT RBL 7.5. REPAIRED WEB PER ACO.SDR SWAA082876Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD SERVICE DOOR LOWER FRAME CRACKED AT LOWER FWD CORNER. REPAIRED FRAME PER SRM.SDR SWAA082825Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 470, STR 1. REPAIRED SKIN PER SRM.SDR SWAA082824Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 406, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA082826Bulb · faultyNR 1 ENGINE OIL TEMP CLIMBED INTO RED BAND. NR 1 ENGINE WAS SHUTDOWN PER QRH. REMOVED AND REPLACED OIL TEMP BULB PER MM.SDR SWAA082820Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA082821Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT ELEVATOR UPPER SURFACE DELAMINATED. REPAIRED ELEVATOR PER SRM.SDR SWAA082823Stiffener · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL STIFFENER AT BS 178, RBL 5.7. REPAIRED STIFFENER PER SRM.SDR SWAA082822Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA082789Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 3L. REPAIRED FRAME PER SRM.SDR SWAA082790Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 2L. REPAIRED FRAME PER SRM.SDR SWAA082761Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA082760Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 386, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA082759Skin · wornDURING SCHEDULED BRDG CHECK, FOUND UPPER FUSELAGE SKIN WORN BETWEEN BS 980 AND BS 1002, BELOW DORSAL FIN. REPAIRED SKIN PER EA.SDR SWAA082751Skin · wornDURING SCHEDULED BRDG CHECK, FOUND UPPER FUSELAGE SKIN WORN BETWEEN BS 895 AND BS 930 BELOW DORSAL FIN. REPAIRED SKIN PER EA.SDR SWAA082714Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA082712Lamp · inoperativeDURING SCHEDULED C3 CHECK, FOUND LT FWD FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082713Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SERVICE DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA082699Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA082640Pressure Panel · crackedDURING SCHEDULED 16Y CHECK, FOUND NLG W/W CEILING PANEL CUTOUT WEB CRACKED AT RBL 7.5. REPAIRED WEB PER ACO.SDR SWAA082641Pressure Panel · crackedDURING SCHEDULED 16Y CHECK, FOUND NLG W/W CEILING PANEL CUTOUT WEB CRACKED AT LBL 7.5. REPAIRED WEB PER ACO.SDR SWAA082639Lens · brokenRIGHT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA082638Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA082637Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA082621Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 6L. REPAIRED WEB PER SRM.
Back to Boeing 737-5H4