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 SWAA002640Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 6 EA. BS 178 BULKHEAD WEB CRACKS, RBL 7 TO LBL 7, WL 187.5 TO WL 214. REPAIRED BULKHEAD PER SRM.SDR SWAA002639Beam · crackedDURING SCHEDULED D CHECK, FOUND 14 EA. CRACKS AT BS 178 BULKHEAD VERTICAL BEAMS, WL 226 TO WL 231.75, RBL 17.1 & WL 226 TO WL 232.5, LBL 17.1. REPAIRED VERTICAL BEAMS PER RA 1-553-2403.SDR SWAA002638Bulkhead · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND 4 EA. BS 178 BULKHEAD WEB CRACKS AT RBL 5 TO LBL 5, WL 188 TO WL 201. REPAIRED BULKHEAD WEBS PER ACO 7154-53.SDR SWAA002626Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 3 EA. CRACKS AT BS 178 BULKHEAD WL 235, RBL 10, WL 214, LBL 7 & RBL 5. REPAIRED BULKHEAD PER SRM.SDR SWAA002611Light · inoperativeSEVERAL EEPLS BULBS INOP. R&R BULBS PER MM.SDR SWAA002589Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD RT SIDE CHORD CRACKED AT RBL 26, WL 207. R&R SIDE CHORD PER ACO 7342-53.SDR SWAA002597Lens · missingEEPLS 2 EA. LENS ASSY IS MISSING. R&R LENSES PER MM.SDR SWAA002596Wire · exposedEEPLS LOOSE & WIRING EXPOSED AT ROW 7. INSTALLED TRACK COVER LENS PER MM.SDR SWAA002590Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD CRACK EXTENDING FROM FASTENER HOLE AT WL 207, RLB 6. REPAIRED BULKHEAD PER RA 1-553-2411.SDR SWAA002583Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 7 EA. BS 178 BULKHEAD CRACKS EXTENDING FROM RBL 5.0 TO LBL 6.0. REPAIRED BULKHEAD PER SRM & RA 1-553-2411.SDR SWAA002582Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD LT SIDE CHORD CRACKED AT LBL 26.0, WL 207. R&R SIDE CHORD PER ACO 7338-53.SDR SWAA002551Cover · missingEEPLS TRACK COVER MISSING AT ROW 1. INSTALLED COVER PER MM.SDR SWAA002557Pressure Panel · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 663 BEADED PRESS WEB CRACKED, LBL 31. REPAIRED WEB PER TI-353-046.SDR SWAA002556Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 LH SIDE CHORD CRACKED, WL 218. R&R T-CHORD SECTION PER SRM.SDR SWAA002555Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE EXT SKIN CRACKED, BS 748-751, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA002537Battery · dischargedAFT LOWER EMERGENCY FLASHLIGHT INOP. R&R FLASHLIGHT BATTERY PER MM.SDR SWAA002507Cover · looseDURING SCHEDULED C2 CHECK, FOUND EEPLS TRACK COVER LOOSE AT ROW 12. SECURED TRACK COVER PER MM.SDR SWAA002498Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEB .5 CRACK AT WL 190, RBL 5.7. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA002496Wire · damagedEEPLS INOP AT ROWS 1 & 15. REPAIRED EEPLS WIRING AND REPLACED TRACK COVERS PER MM.SDR SWAA002492Tee Chord · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD CRACKED AT VERTICAL T-CHORD, WL 184, LBL 5.7. REPAIRED BULKHEAD SUPPORT TEE PER SRM.SDR SWAA002491Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD RT SIDE CHORD CRACKED AT WL 207, RBL 28. R&R SIDE CHORD PER ACO 7342-53.SDR SWAA002484Fitting · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND RT & LT MLG AFT BEAM FITTINGS CRACKED. R&R BEAM FITTINGS PER ACO 6384-57.SDR SWAA002483Lens · missingOVERHEAD EMERGENCY EXIT LIGHT LENS MISSING AT ROW 6. REPLACED LENS PER MM.SDR SWAA002480Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA CRACKS AT BS 178 BULKHEAD BETWEEN RBL 5.0 & LBL 5.0, WL 190 - WL 201. REPAIRED BULKHEAD PER SRM.SDR SWAA002467Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEB CRACKS AT WL 210.5 RBL 6.7, WL 213 LBL 6.7 & WL 190 LBL 5.7.SDR SWAA002434Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD RT SIDE CHORD CRACKED. R&R CHORD PER ACO 7342-53.SDR SWAA002433Floorbeam · corrodedDURING SCHEDULED D CHECK AT DALFORT, FOUND FLOOR BEAM CORRODED AT BS 986.5, RBL 4.75. REPAIRED FLOOR BEAM PER SRM.SDR SWAA002435Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEBS CRACKED AT RBL 5 WL 199, LBL 7 WL 201 & LBL 1 WL 188. REPAIRED BULKHEAD PER SRMSDR SWAA002421Wire · inoperativeDURING SCHEDULED C3 CHECK, FOUND EEPLS INOP AT ROWS 10 TO 15. RE-PINNED CONNECTOR WIRING PER MM.SDR SWAA002420Cover · looseDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK COVER LOOSE AT ROW 7. SECURED TRACK COVER PER MM.SDR SWAA002385Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND .5 INCH CRACK IN BS 178 BULKHEAD WEB, WL 198, RBL 5.0. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA002402Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD LT & RT SIDE CHORDS CRACKED. REMOVED AND REPLACED SIDE CHORDS PER ACO.SDR SWAA002387Cover · looseEEPLS COVER LOOSE AND BROKEN AT ROW 5. REPLACED TRACK COVER AND 1 BULB (P/N 0L3071BPL5GPL).SDR SWAA002399Cover · looseEEPLS TRACK COVER LOOSE AT ROW 7. RESECURED TRACK COVER PER PER MM.SDR SWAA002344Wire · exposedEEPLS WIRES EXPOSED AT ROWS 2 AND 3. SECURED EEPLS WIRING PER MM.SDR SWAA002343Slide · dislodgedFWD SVC DOOR EMERGENCY EVAC SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002261Bulb · inoperativeDURING SCHEDULED C1 CHECK, FOUND EEPLS INOP BETWEEN ROWS 3 & 5. REMOVED AND REPLACED BULBS PER MM.SDR SWAA002213Battery Pack · inoperativeDURING SCHEDULED D-CHECK AT DALFORT, FOUND BOTH FWD EMERGENCY FLASHLIGHTS INOP. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA002133Light · inoperativeEEPLS INOP IN FWD SECTION. REPAIRED EEPLS PER MM.SDR SWAA002121Cover · brokenDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK BROKEN AT ROW 8. REMOVED AND REPLACED TRACK COVER PER MM.SDR SWAA002111Slide · dislodgedDURING FWD ENTRY DOOR CLOSURE, EMERGENCY EVAC SLIDE ENGAGED FRAME AND FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002100Solenoid · looseDECLARED EMERGENCY, DURING LANDING, GEAR EXTENDED, RECEIVED 3 GREEN AND 3 RED LIGHT INDICATIONS. ACOMMPLISHED QRH MANUAL EXTENSION WHICH RESULTED IN 3 GREEN LIGHTS. LOOSE WIRE FOUND ON GEAR HANDLE SOLENOID. SECURED WIRE, CLEANED WIRE AND LUBED GEAR HANDLE PSDR SWAA002112Light · inoperativeEEPLS INOP IN SEVERAL LOCATIONS. INSERTED LOOSE CONNECTOR PINS PER MM.SDR SWAA002053Bracket · brokenFWD ENTRY DOOR EMERGENCY EVAC SLIDE BRACKET BROKEN. REMOVED AND REPLACED BRACKET ASSY PER MM.SDR SWAA002070Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE FALLING OUT OF CASE. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002039Light · looseEEPLS LOOSE AT EMERGENCY EXIT ROW. SECURED EEPLS TRACK PER MM.SDR SWAA002023Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA002026Valve · vibratesAIR TURNBACK, FLUTTERING SOUND IN COCKPIT DURING CLIMBOUT. PACKS TURNED OFF AIRSPEED BELOW 200 KTS AND ENG POWER ADJ. STILL FLUTTERING. REMOVED AND REPLACED EQUIPMENT COOLING VALVE AND C/W AIRFRAME VIBRATION CONDITIONAL INSPECTION.SDR SWAA002003Light · looseSEVERAL EEPLS LIGHTS LOOSE AT MID-CABIN. SECURED LIGHTS PER MM.SDR SWAA001947Light · looseEGRESS LIGHT LENS ASSY LOOSE AT ROW 6. REMOVED AND REPLACED LIGHT ASSY PER MM.
Back to Boeing 737-5H4