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 SWAA050400Hook · corrodedDURING SCHEDULED 1/2D CHECK, FOUND GIRT BAR FLOOR FITTING ASSY AT BS 344, LBL 59, CORRODED. REMOVED AND REPLACED GIRT BAR FITTING ASSY PER SRM.SDR SWAA050399Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 25L AT BS 970, CORRODED. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA050384Bolt · wornDURING SCHEDULED C2 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BOLT PER MM.SDR SWAA050383Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR LOWER FRAME AT AFT LOWER STOP, CRACKED. REMOVED AND REPLACED FWD SERVICE DOOR MM.SDR SWAA050382Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 937, STRINGER 23R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050372Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT FWD LT CORNER OF AIR CONDITIONER CUTOUT, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050371Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT AFT ENTRY DOOR UPPER HINGE CUTOUT, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050367Stringer · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER AT BS 941, STRINGER 23R, CRACKED. REPAIRED STRINGER SECTION PER SRM.SDR SWAA050347Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT BETWEEN ROWS 16 DEF AND 17 DEF, INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA050321Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT AFT ENTRY DOOR UPPER AFT CORNER, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050320Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT AFT SERVICE DOOR UPPER HINGE, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050319Frame · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR FWD FRAME AT THIRD STOP CRACKED. REPAIRED FRAME PER EA.SDR SWAA050303Bottle · lowL1 DOOR EVAC SLIDE INDICATION, LOW PRESSURE. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.SDR SWAA050299Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT EXTERIOR EMERGENCY EXIT LIGHT AND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA050272Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING NR 4 L/E SLAT DELAMINATED. REMOVED AND REPLACED NR 4 L/E SLAT PER MM.SDR SWAA050233Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND LT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED LT WING T/E AFT FLAP PER MM.SDR SWAA050221Tab · failedDURING SCHEDULED C1 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB PER MM.SDR SWAA050220Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND LT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED LT WING T/E AFT FLAP PER MM.SDR SWAA050209Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 787, STRINGER 25L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050154Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND RT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED T/E FLAP PER MM.SDR SWAA050146Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA050137Bushing · wornDURING SCHEDULED C2 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BUSHING PER MM.SDR SWAA050089Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA050072Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR LOWER EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA050062Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RT HORIZONTAL STAB SKIN AT BS 140, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050052Light · looseAFT ENTRY EMERCENCY EXIT SIGN LOOSE. REMOVED AND REPLACED LIGHT ASSEMBLY PER MM.SDR SWAA050050Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND LT WING INBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA050047Battery · inoperativeDURING SCHEDULED A2 CHECK, FOUND FWD SERVICE DOOR EMERGENCY ESCAPE SLIDE LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA050045Fastener · missingL1 DOOR EVAC SLIDE MOUNTING FASTENER MISSING. REMOVED AND REPLACED FASTENER PER MM.SDR SWAA050025Structure · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 4 L/E SLAT DELAMINATED. REMOVED AND REPLACED NR 4 L/E SLAT PER MM.SDR SWAA050023Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RT HORIZONTAL STAB, LOWER SKIN AT STA 140, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043716Stiffener · corrodedDURING SCHEDULED RON CHECK, FOUND FLOOR SUPPORT STIFFENER CORRODED AT BS 270, LBL 4, WL 207.5. REPAIRED STIFFENER PER SWA EA.SDR SWAA043711Slide · out of adjustL1 DOOR EVACUATION SLIDE OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA043705Pressure Panel · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EA CRACKS AT NLG W/W CEILING WEB, BS 259.5, LT & RT SIDES OF ACCESS PANEL. REPAIRED WEB PER SRM.SDR SWAA043703Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 930, STRINGER 24L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043631Tee Fitting · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR LOWER OUTBOARD TEE FITTING, CRACKED. REMOVED AND REPLACED TEE FITTING PER SRM.SDR SWAA043624Fitting · looseAFT SERVICE DOOR EVAC SLIDE FWD GIRT BAR FITTING LOOSE. REINSTALLED SCREWS PER MM.SDR SWAA043611Strap · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRAP AT NAC STA 234, NR 2 ENGINE PYLON, CRACKED. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA043616Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 518, STRINGER 12L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043607Skin · crackedFUSELAGE SKIN AT BS 931, ABOVE STRINGER 25L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043591Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 277, STRINGER 15R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043575Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT AFT SERVICE DOOR CUTOUT LOWER CORNER CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043574Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 665, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA043572Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 663, STRINGER 10L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043571Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT ENTRY DOOR, UPPER HINGE CUTOUT LOWER CORNER SKIN, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043570Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 932, STRINGER 25R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043569Spindle · wornDURING SCHEDULED SERVICE CHECK, RT WING OUTBOARD T/E AFT MID FLAP SPINDLE HAS EXCESSIVE PLAY. REMOVED RT SPINDLE PER MM.SDR SWAA043568Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA043567Fitting · wornDURING SCHEDULED C3 CHECK, LT ELEVATOR INBOARD TAB HINGE FAILED FREE PLAY CHECK. REMOVED AND REPLACED INBOARD HINGE FITTING PER MM.SDR SWAA043558Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR CUTOUT FWD CORNER, CRACKED. REPAIRED SKIN PER EA.
Back to Boeing 737-5H4