Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2015063041238Intercostal · crackedFLOOR SUPPORT INTERCOSTAL CRACKED AT STATION 550, LBL 52. R & R INTERCOSTAL IAW SRM.SDR SWAA2015061640696Slat · delaminatedLEFT WING NR 2 SLAT DELAMINATED BOTH UPPER INBD & OTBD TE CORNERS. R & R NR 2 SLAT IAW AMM.SDR SWAA2015061540671Lens · looseLEFT OVERWING EMER EXIT LENS LOOSE. SECURED LENS MM.SDR SWAA2015061540669Lens · looseRIGHT OVERWING EMER EXIT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2015061540659Engine · overtempNR 1 ENGINE OVERTEMPED AFTER TAKEOFF, 957 DEGREES FOR 30 SECONDS. R & R THE NR 1 ENGINE IAW MT.SDR SWAA2015061540658Sensor · out of adjustDURING APPROACH, LOWERED LANDING GEAR AND THREE RED & THREE GREEN LIGHTS. WENT AROUND, CYCLED GEAR, AND RECEIVED THREE GREEN LIGHTS, NO RED. ADJUSTED LANDING GEAR LEVER CONTROL POSITION SWITCH SENSOR IAW MM.SDR SWAA2015062240999Skin · delaminatedLEFT WING INBD FORE FLAP OUTER SURFACE SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2015061640800Light · inoperativeLEFT EMER EXIT LOWER SIGN BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2015063041223Stringer · crackedSTRINGER CRACKED AT STATION 482, STRINGER 28R. REPAIRED STRINGER IAW EA.SDR SWAA2015061540672Hinge · brokenNUMBER 4 INBD SPOILER ACTUATOR HINGE BROKEN. R & R SPOILER IAW MM.SDR SWAA2015061540656Probe · faultyPERFORMED AN AIR TURNBACK AND AN EMERGENCY WAS DELARED, DUE TO A FUEL QTY INDICATOR BEING ERRATIC AND WITH A FUEL IMBALANCE. R & R LEFT TANK NR 6 PROBE IAW MM.SDR SWAA2015061540655Wire Harness · faultyPERFORMED AN AIR TURNBACK AND AN EMERGENCY WAS DELARED, DUE TO THE FUEL QTY INDICATOR WAS ERRATIC WITH A FUEL IMBALANCE. R & R LEFT TSD FUEL TANK HARNESS IAW MM.SDR SWAA2015061240631Hinge · brokenFOUND THE RIGHT WING INBOARD GROUND SPOILER OUTBD HINGE BROKEN. R & R THE SPOILER IAW MM.SDR SWAA2015061240630Hinge · brokenFOUND THE LEFT WING INBD GROUND SPOILER OUTBOARD HINGE BROKEN. R & R THE SPOILER IAW MM.SDR SWAA2015061140568Pmc · faultyPERFORMED AN AIR TURN BACK AND DECLARED AN EMERGEMCY DUE TO NR 2 ENGINE N1 INDICATIONS ERRATIC. R & R NR 2 ENGINE PMC & T12 SENSOR IAW MM.SDR SWAA2016030249576Scuff Plate · crackedAFT BAG BIN DOOR CUT OUT FWD SCUFF PLATE, LOWER CORNER CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2015062341092Skin · crackedFUSELAGE CHEM-MILLED SKIN CRACKED BETWEEN BS 515.5 TO 517, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2015061740814Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2015061040554Lens · looseLEFT OVERWING EXIT LIGHT LENS LOOSE. R & R LENS IAW MMSDR SWAA2015061040553Battery Pack · dischargedRIGHT OVERWING EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2015062341091Skin · crackedFUSELAGE CHEM-MILLED SKIN CRACKED BETWEEN BS 392 TO 393, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015062341090Skin · crackedFUSELAGE CHEM-MILLED SKIN CRACKED BETWEEN BS 521 TO 530, STRINGER 2R. REPAIRED SKIN IAW ER & EA.SDR SWAA2015062341089Skin · crackedFUSELAGE CHEM-MILLED SKIN CRACKED BETWEEN BS 521 TO 528, STRINGER 1. REPAIRED SKIN IAW ER & EA.SDR SWAA2015061140575Wire · brokenTHE R2 DOOR EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPAIRED THE EMERGENCY LIGHT WIRE IAW SWP.SDR SWAA2015060940480Lug · brokenNUMBER 5 GND SPOILER INBD ATTACHMENT LUG BROKEN. R & R NR 5 GND SPOILER IAW MM.SDR SWAA2015060940481Lens · looseRIGHT OVERWING EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2015060840466Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT ROW 1 DEF. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015060840440Lens · brokenL1 DOOR EXIT LIGHT LENS BROKEN. R & R LENS IAW MM.SDR SWAA2015060840437Lug · brokenNUMBER 4 GND SPOILER HAS BROKEN HINGE LUG. R & R NR 4 SPOILER IAW MM.SDR SWAA2015071041790Door Frame · crackedL2 DOOR STUB FRAME CRACKED AT BS 947.5+11, STRINGER 17L. REPAIRED STUB FRAME IAW EO & EA.SDR SWAA2015070841544Bulkhead · crackedFORWARD PRESS BULKHEAD VERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7. REPAIRED WEB IAW EO & EA.SDR SWAA2015060840441Intercostal · crackedFLOORBEAM INTERCOSTAL BETWEEN STATION 312 & 328, LBL 45 CRACKED. R & R INTERCOSTAL IAW SRM.SDR SWAA2015060840436Door Frame · crackedR1 DOOR FWD FRAME CRACKED AT UPPER HINGE CUT OUT. R & R DOOR IAW MM.SDR SWAA2015071341835Door Frame · crackedSTUB FRAME CRACKED AT BS 947+11, STRINGER 17R, 9 O CLOCK AFT GALLEY DOOR. REPAIRED STUB FRAME IAW EA.SDR SWAA2015071041719Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, BETWEEN STRINGER 27L - 27R. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2015070941682Structure · crackedINNER CHORD CRACKED AT BS 348.2, STRINGER 17L. R & R CHORD IAW EO & EA.SDR SWAA2015070941692Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 747, BETWEEN STRINGER 26L TO 27L. REPAIRED FRAME IAW SRM.SDR SWAA2015070941691Channel · crackedAFT CARGO COMPARTMENT CHANNEL CRACKED AT BS 727E, LBL 3.0. REPAIRED CHANNEL IAW SRM & DWG.SDR SWAA2015070841539Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 4L. R & R SPLICE IAW EO & EA.SDR SWAA2015070641308Web · crackedWEB CRACKED BETWEEN BS 294.5 - 312, BETWEEN STRINGER 27R - 28L. R & R WEB IAW SRM & DWG.SDR SWAA2015070641301Channel · corrodedCHANNEL CORRODED AT BS 767+5, LBL 3.0. REPAIRED CHANNEL IAW EA.SDR SWAA2015070641294Fitting · crackedCLIP CRACKED AT BS 294.5, STRINGER 23L. R & R CLIP IAW SRM & DWG.SDR SWAA2015062241022Skin · delaminatedLEFT WING INBD FORE FLAP DELAMINATED ON UPPER SKIN AT 49.50 FROM OTBD EDGE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015061840884Skin · delaminatedLEFT WING INBD FORE FLAP DELAMINATED ON UPPER SKIN. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015061840883Channel · corrodedAFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 767+5, RBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2015061640798Fitting · crackedANGLE CLIP CRACKED AT BS 323.7, STRINGER 21L. R & R ANGLE CLIP IAW SRM & DWG.SDR SWAA2015061640777Skin · delaminatedLEFT WING INBD FORE FLAP DELAMINATED ON UPPER SKIN. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015061640776Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 10L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015061140597Stringer Clip · crackedTHE STRINGER CLIP WAS FOUND CRACKED AT BS 360, STRINGER 2L. R&R THE STRINGER CLIP IAW THE SRM.SDR SWAA2015061040563Tie Clip · crackedTIE CLIP CRACKED AT STATION 360, STRINGER 2R. R & R CLIP IAW SRM.
Back to Boeing 737-3H4