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 SWAA970549Frame · damagedBELTLOADER CONTACTED FUSELAGE SKIN UNDER AFT CARGO DOOR CAUSING BELTFRAME AND SHEAR TIE DAMAGE AT BS 827. REPAIRED PER BOEING SRM.SDR SWAA970542Skin · damagedDURING SCHEDULED BC4 CHECK, FOUND A FUSELAGE SKIN GOUGE AT BS 1004, BELOW S19R. REPAIRED PER BOEING SRM.SDR SWAA970546Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD WEB CRACKED AT LBL 4.7. REPAIRED PER BOEING SRM.SDR SWAA970545Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 384, 20 BELOW 3RD CABIN WINDOW RIGHT SIDE. REPAIRED PER BOEING SRM.SDR SWAA970544Floorbeam · damageDURING SCHEDULED D-CHECK, FOUND FLOORBEAM DAMAGED AT BS 312, AT LBL 18 TO 45. REPAIRED PER BOEING SRM.SDR SWAA970543Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947, AT LBL 5, WL 208. REPAIRED PER BOEING SRM.SDR SWAA970541Skin · damagedDURING SCHEDULED C3 CHECK, FOUND A FUSELAGE SKIN DAMAGE AT BS 1006, RIGHT SIDE BELOW WL 208. REPAIRED PER BOEING SRM.SDR SWAA970532Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND CRACK INDICATION AT BS 178 BULKHEAD, WL 199.25 TO 199.75. REPAIRED PER TRAMCO EWO 97-0268 AND BOEING SRM.SDR SWAA970531Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND CRACK INDICATION AT BS 178 BULKHEAD, WL 212.25 TO 213. REPAIRED PER TRAMCO EWO 97-0268 AND BOEING SRM.SDR SWAA970530Wire · failedDURING WALKAROUND CHECK, FOUND SEVERAL INTERIOR EMERGENCY EXIT LIGHTS INOP. REPAIRED WIRING AND OP CHECKED PER BOEING M/M.SDR SWAA970529Skin · gougedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 784, AT S28R. REPAIRED PER BOEING SRM.SDR SWAA970520Frame · crackedDURING SCHEDULED D-CHECK, FOUND STUB FRAME CRACKED AT BS 296.5, RBL 56. REPLACED PER BOEING SRM.SDR SWAA970519Sill · corrodedDURING SCHEDULED D-CHECK, FOUND MOPSILL CORROSION AT BS 294 TO 334 AND BS 950 TO 996. REPAIRED PER BOEING SRM.SDR SWAA970518Rib · gougedDURING SCHEDULED C3 CHECK, FOUND LEFT WING RIB GOUGED AT SEAL RETAINER AT WING STA.208, PERPINDICULAR TO LOWER RIB FLANGE. REPAIRED PER SWA RA 1-357-0451.SDR SWAA970517Skin · damagedDURING SCHEDULED A2 CHECK, FOUND NUMEROUS AREA OF LIGHTNING STRIKE DAMAGE AT LEFT FUSELAGE SKIN ALONG WINDOWS 4, 5 AND 7. REPAIRED PER BOEING SRM.SDR SWAA970480Strap · crackedDURING SCHEDULED BC1 CHECK, FOUND LEFT FLOORBEAM STRAP CRACKED. REPAIRED PER BOEING SRM.SDR SWAA970481Tire · failedSECTION OF TREAD SEPARATED FROM NR 2 MAIN GEAR TIRE DURING TAKEOFF. INSPECTED, NO DAMAGE NOTED. REPLACED NR 2 MAIN GEAR WHEEL/TIRE ASSEMBLY PER BOEING M/M.SDR SWAA970407Light · inoperativeDURING WALKAROUND INSPECTION, FOUND WHITE FLOOR TRACK LIGHTING INOP IN AFT CABIN AREA. REMOVED AND REPLACED LIGHT ASSEMBLY AND LENS PER BOEING M/M.SDR SWAA970408Battery · dischargedDURING WALKAROUND INSPECTION, FOUND CABIN FLOOR TRACK LIGHTING INOP. REMOVED AND REPLACED BATTERY PACK AND HOUSING PER BOEING M/M.SDR SWAA970391Battery · dischargedDURING WALKAROUND INSPECTION, FOUND EMERGENCY AND LIGHTING AT OVERWING EXIT AND A SECTION OF FLOOR TRACK LIGHTING INOP. REMOVED AND REPLACED BATTERY PACK AND CHARGER UNIT PER BOEING M/M.SDR SWAA970409Skin · crackedDURING SCHEDULED D-CHECK, FOUND INTERIM REPAIR ON RT HORIZ STAB LOWER SPAR SKIN. INSTALLED PERMANENT REPAIR PER BOEING SRM.SDR SWAA970374Support · corrodedDURING SCHEDULED D-CHECK, FOUND BULKHEAD TO FLOOR SUPPORT CORRODED AT BS 482 FROM LBL 18 TO RBL 13. REPAIRED PER BOEING SRM.SDR SWAA970373Support · crackedDURING SCHEDULED D-CHECK, FOUND A FLOOR SUPPORT CRACK AT BS 540, BL 0 TO RBL 25, WL 208. REPLACED PER BOEING SRM.SDR SWAA970358Skin · gougedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 386, 4 ABOVE S17L. REPAIRED PER BOEING SRM.SDR SWAA970357Bulkhead Angle · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD SUPPORT ANGLE CRACKED AT BS 727, WL 162. REPLACED PER BOEING SRM.SDR SWAA970356Support · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM SUPPORT CORRODED AT BS 1014, LBL 39, WL 208. REPAIRED PER BOEING SRM.SDR SWAA970355Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 33 TO 37, WL 208. REPAIRED PER BOEING SRM.SDR SWAA970354Mopsill · crackedDURING SCHEDULED D-CHECK, FOUND GALLEY MOPSILL CHORD CRACKED AT BS 295, WL 208R. REPAIRED PER BOEING SRM.SDR SWAA970352Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORROSION AT BS 987, RBL 45 TO LBL 22, WL 208, AND AT BS 947, LBL 16, TO RBL 7. REPAIRED PER BOEING SRM.SDR SWAA970351Web · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR WEB CORRODED AT BS 1016, TO 1019, LBL 33 TO 37, WL 208. REPAIRED PER BOEING SRM.SDR SWAA970350Angle · corrodedDURING SCHEDULED D CHECK, FOUND Z ANGLE CORRODED AT BS 270, WL 208, LBL 11 TO RBL 11. REPAIRED PER BOEING SRM.SDR SWAA970349Support · corrodedDURING SCHEDULED D CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 328 TO 344, LBL 11, WL 208, ALSO AT BS 312-328, LBL 11, WL 208. REPAIRED PER BOEING SRM.SDR SWAA970348Lights · inoperativeDURING WALKAROUND, FOUND A SECTION OF CABIN EMERGENCY TRACK LIGHTING INOP. RECONNECTED 2 LIGHT ASSEMBLIES AND OP CHECKED PER BOEING M/M.SDR SWAA970935Wire · brokenDURING SCHEDULED RON CHECK, FOUND A SECTION OF FLOOR TRACK LIGHTING INOP. REPAIRED A BROKEN WIRE PER BOEING M/M.SDR SWAA970259Stringer · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER 18A WEB CRACKED RT SIDE, AT AFT I/B FASTENER HOLE BS 727. REPAIRED PER SWA RA 1-553-1612 AND ACO 6580-53.SDR SWAA970207Light · inoperativeDURING WALKAROUND CHECK, CABIN FLOOR TRACK LIGHTING AT ROW 7 INOP AND MISSING COVER. REPLACED LIGHT ASSEMBLY AND COVER, OP CHECKED PER BOEING M/M.SDR SWAA970208Light · inoperativeDURING SCHEDULED TERMINAL CHECK, FOUND CABIN FLOOR TRACK LIGHTING IN FWD CABIN AREA. RECONNECTED, SECURED AND OP CHECKED PER BOEING M/M.SDR SWAA970230Skin · gougedDURING SCHEDULED BC4 CHECK, FOUND FUSLAGE SKIN GOUGED BELOW FWD ENTRY DOOR 2 BELOW AFT LOWER CORNER. REPAIRED PER BOEING SRM AND TYPICAL REPAIR T1-A53-042.SDR SWAA970209Lights · inoperativeDURING SCHEDULED BC4 CHECK, FOUND CABIN FLOOR TRACK LIGHTING INOP AND WIRES EXPOSED IN SEVERAL CABIN LOCATIONS. RECONNECTED, SECURED AND OP CHECKED PER BOEING M/M.SDR SWAA970188Lights · inoperativeDURING WALKAROUND, FOUND 2 CABIN FLOOR TRACK LIGHTS INOP AT ROW 7. REPLACED AS REQUIRED PER BOEING M/M.SDR SWAA970187Lights · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND 2 CABIN FLOOR TRACK LIGHTS INOP. REPLACED AS REQUIRED PER BOEING M/M.SDR SWAA970186Lights · inoperativeDURING SCHEDULED C3 CHECK, FOUND CABIN FLOOR TRACK LIGHTING HAD CRACKED COVERS, INOP LAMPS THROUGHOUT CABIN. REPAIRED AND REPLACED AS REQUIRED PER BOEING M/M.SDR SWAA970096Frame · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND FWD ENTRY DOOR FRAME CRACKED 8 INCHES ABOVE HANDLE OUT FRAME. REPAIRED PER SWA RA 1-552-0264.SDR SWAA970140Gasper Fan · failedON ARRIVAL, NOTED SLIGHT BURNING ODOR IN FWD CABIN AREA. GASPER FAN CONTROL C/B TRIPPED DURING PREFLIGHT CHECK. DURING OVERNIGHT CHECK, REPLACED GASPER FAN MOTOR ASSY AND OP CHECKED PER BOEING M/M.SDR SWAA970090Light · inoperativeDURING WALKAROUND CHECK, FOUND EMERGENCY EXIT TRACK WIRES BROKEN AND 5 LIGHTS INOP. RECONNECTED WIRING, RESECURED COVER AND OP CHECKED PER BOEING M/M.SDR SWAA970144Windshield · crackedIN FLIGHT, CAPTAIN'S NR 1 WINDSHIELD ARCED AND CRACKED, CAUSING RESTRICTED VISIBILITY. AIRCRAFT RETURNED TO MDW AND LANDED WITHOUT INCDENT. REPLACED WINDOW AND WINDOW HEAT CONTROLLER PER BOEING M/M.SDR SWAA961446Slide · low pressDURING SCHEDULED RON CHECK, FOUND AFT ENTRY DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR SWAA961447Battery · dischargedDURING WALKAROUND INSPECTION, FOUND FWD RIGHT FLASHLIGHT NOT TESTING. REPLACED BATTERY PER BOEING M/M.SDR SWAA961394Skin · gougedDURING SCHEDULED BC3 CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 970, AT STRINGER 19L. REPAIRED SKIN PER SWA RA 1-553-1566.SDR SWAA961383Engine · failedNUMBER 2 ENGINE OIL QUANTITY DROPPED. CREW PERFORMED ENGINE SHUTDOWN CHECKLIST. AIRCRAFT DIVERTED TO ONT AND MADE AN UNEVENTFUL LANDING. REPLACED NUMBER 2 ENGINE PER BOEING M/M.
Back to Boeing 737-5H4