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 SWAA2016012748404Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+3, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2016022649476Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED AT FASTENER HOLE UPPER ROW, APPROX RSS 223. REPAIRED CHORD IAW ER & EA.SDR SWAA2016012548354Light · inoperativeRIGHT EMER EXIT LIGHT INOPERATIVE ABOVE STOW BIN AT ROW 1. RELAMPED LIGHT IAW AMM.SDR SWAA2016022949529Skin · crackedL1 DOOR THE LOWER AFT CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SRM & EA.SDR SWAA2016022649452Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 19L - 22L. REPAIRED FRAME IAW SRM.SDR SWAA2016020348627Plate · brokenR1 DOOR CUT OUT AFT THRESHOLD FRAME FAIRING PLATE BROKEN. R & R PLATE IAW SRM & DWG.SDR SWAA2016012548316Flap · delaminatedLEFT WING OTBD AFT TE FLAP DELAMINATED ON INBD CORNER AFT EDGE. R & R AFT FLAP IAW AMM.SDR SWAA2016030749708Floorbeam · corrodedFLOORBEAM UPPER FLANGE CORRODED AT BS 986.5, BETWEEN RBL 6 - RBL 45. REPAIRED FLANGE IAW EA.SDR SWAA2016030749707Pressure Panel · crackedMAIN WW WEB CRACKED AT BS 663, RBL 28.5. REPAIRED WEB IAW EA.SDR SWAA2016030149553Bracket · crackedLEFT WING BRACKET CRACKED, AT RSS 235, COMMON TO UPPER SPAR CHORD. R & R BRACKET IAW SRM.SDR SWAA2016030149551Seat Track · corrodedCABIN AFT WET AREA TIE DOWN TRACK CORRODED, AT BS 986.5, RBL 18. R & R TIE DOWN TRACK IAW SRM & DWG.SDR SWAA2016022949528Attach Angle · corrodedR2 DOOR CUT OUT CREASE BEAM, INNER CHORD AFT ATTACH ANGLE CORRODED, BETWEEN BS 992.8 - 1006, RBL 56. R & R ANGLE IAW SRM & DWG.SDR SWAA2016022949527Crease Beam · corrodedR2 DOOR CUT OUT CREASE BEAM, INNER CHORD CORRODED, BETWEEN BS 951 - 992.8, RBL 56. R & R CHORD IAW SRM & DWG.SDR SWAA2016022949526Pressure Panel · crackedMAIN WW VERTICAL WEB CRACKED, AT BS 663, LBL 41. REPAIRED WEB IAW EA.SDR SWAA2016022949505Spar · crackedLEFT WING UPPER REAR SPAR, CHORD CRACKED AT RSS 222. REPAIRED CHORD IAW EA.SDR SWAA2016022349269Link Assy · corrodedRIGHT MLG BEAM ATTACH LINK ASSEMBLY CORRODED. REPAIRED LINK ASSEMBLY IAW EA.SDR SWAA2016021949236Support Fitting · corrodedRIGHT MLG AFT SUPPORT FITTING, CORRODED INSIDE OF UPPER INBD HOLE. REPAIRED FITTING ER & EA.SDR SWAA2016021949235Spar · crackedRIGHT WING UPPER REAR SPAR CHORD, CRACKED AT RSS 222. REPAIRED CHORD IAW ER & EA.SDR SWAA2016021249007Tee Fitting · crackedFORWARD GALLEY DOOR FRAME INTERCOSTAL T CHORD CRACKED AT BS 334, STRINGER 8R. R & R T CHORD IAW SRM & DWG.SDR SWAA2016020948779Link Assy · corrodedLEFT MLG BEAM ATTACH LINK ASSEMBLY CORRODED. R & R LINK ASSEMBLY IAW EA & DWG.SDR SWAA2016030749706Skin · crackedFORWARD ENTRY DOOR CUT OUT UPPER FWD CORNER CRACKED AT BS 312. REPAIRED CUT OUT IAW EA.SDR SWAA2016030149557Pin · corrodedRIGHT MLG TRUNNION PIN CORRODED. R & R PIN IAW MM.SDR SWAA2016022549411Link · corrodedRIGHT MLG SWING LINK CORRODED. REPAIRED LINK IAW EA.SDR SWAA2016022549410Link · corrodedLEFT MLG SWING LINK CORRODED. REPAIRED LINK IAW EA.SDR SWAA2016021649105Skin · crackedRIGHT UPPER WING SKIN CRACKED FASTENER HOLES IMMEDIATELY FWD OF THE UPPER REAR SPAR FASTENERS AT RSS 220. REPAIRED SKIN IAW EA.SDR SWAA2016021649091Skin · crackedRIGHT WING UPPER SKIN CRACKED, IN AFT ROW OF OPEN FASTENER HOLES, AT RSS 238. REPAIRED SKIN IAW EA.SDR SWAA2016021649090Skin · crackedRIGHT WING UPPER SKIN, CRACKED IN AFT ROW OF OPEN FASTENER HOLES, BETWEEN RSS 254 - 264. REPAIRED SKIN IAW EA.SDR SWAA2016021249006Scuff Plate · crackedR1 DOOR LOWER AFT CORNER SCUFF PLATE CRACKED AT FWD ATTACH FASTENER HOLE. R & R SCUFF PLATE IAW DWG & SRM.SDR SWAA2016020148548Angle · crackedCENTER WING BOX REAR SPAR ANGLE CRACKED AT RBL 6.30 & WBL 176.4. R & R ANGLE IAW SRM & DWG.SDR SWAA2016012248292Actuator · faultyCROSS FEED VLV LIGHT ILLUMINATED BRIGHT WITH SELECTOR IN CLOSED POSITION. R & R FUEL SOV CROSS FEED VLV ACTUATOR IAW MM.SDR SWAA2016022949534Rib · crackedRIGHT WING INNER UPPER RIB CHORD CRACKED, AT STATION 114, FWD OF MLG TRUNNION FITTING. REPAIRED CHORD IAW EA.SDR SWAA2016022949525Strap · crackedFLOORBEAM LOWER STABILIZATION STRAP CRACKED AT BS 328, RBL 48. REPAIRED STRAP IAW EA.SDR SWAA2016022949545Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 201. REPAIRED WEB IAW EA.SDR SWAA2016022549369Skin · delaminatedLEFT WING NR 3 FLIGHT SPOILER, DELAMINATED ON UPPER SURFACE. R & R NR 3 FLIGHT SPOILER IAW AMM.SDR SWAA2016021849170Skin · crackedLEFT UPPER WING SKIN HOLE CRACKED AT RSS 220, 5" FWD OF TE. REPAIRED SKIN IAW EA.SDR SWAA2016021849169Skin · crackedLEFT UPPER WING SKIN HOLE CRACKED AT RSS 249 AFT ROW, .5" FWD OF TE. REPAIRED SKIN IAW ER & EA.SDR SWAA2016021849168Skin · crackedLEFT UPPER WING SKIN HOLE CRACKED AT RSS 253 AFT ROW, .5" FWD OF TE. REPAIRED SKIN IAW EA.SDR SWAA2016021148969Support Fitting · crackedLEFT WING MLG SUPPORT BEAM INNER FWD SUPPORT FITTING UPPER HOLE CRACKED. R & R FITTING IAW SRM & EA.SDR SWAA2016012648384Skin · crackedRIGHT WING INSPAR SKIN, CRACKED AT WBL 175 AT FASTENER HOLE REAR SPAR. REPAIRED SKIN IAW EA.SDR SWAA2016012148246Angle · crackedRIGHT WING TE INBD PANEL AFT L ANGLE CRACKED. R & R L ANGLE IAW SRM.SDR SWAA2016012148245Angle · crackedLEFT WING INBD FLAP, OTBD TRACK FAIRING OTBD AFT L ANGLE CRACKED. R & R L ANGLE IAW SRM.SDR SWAA2016012048213Angle · crackedLEFT WING INBD FLAP, OTBD TRACK FAIRING, INBD AFT L ANGLE CRACKED. R & R L ANGLE IAW SRM.SDR SWAA2016012048187Uplock Sensor · faultyAIR TURN BACK, AFTER RAISING GEAR HANDLE ON TAKEOFF, THE NOSE GEAR RED LIGHT & GREEN LIGHT REMAINED ON. R & R NOSE UPLOCK SENSOR IAW AMM.SDR SWAA2016012048186Downlock Sensor · faultyAIR TURN BACK, AFTER RAISING GEAR HANDLE ON TAKEOFF, THE NOSE GEAR RED LIGHT & GREEN LIGHT REMAINED ON. R & R NOSE DOWNLOCK SENSOR IAW AMM.SDR SWAA2016022349294Skin · crackedLEFT WING AFT UPPER SKIN CRACKED, BETWEEN RSS 235 - 275, IN FASTENER HOLE REAR SPAR AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016021649150Skin · crackedRIGHT WING AFT UPPER SKIN TE, CRACKED AT RSS 255. REPAIRED SKIN IAW EA.SDR SWAA2016021649149Skin · crackedRIGHT WING AFT UPPER SKIN TE, CRACKED AT RSS 253.5. REPAIRED SKIN IAW EA.SDR SWAA2016021649148Skin · crackedRIGHT WING AFT UPPER SKIN TE SKIN, CRACKED AT RSS 247.5. REPAIRED SKIN IAW EA.SDR SWAA2016021649147Skin · crackedRIGHT WING AFT UPPER SKIN TE CRACKED AT RSS 237. REPAIRED SKIN IAW EA.SDR SWAA2016021048914Skin · delaminatedLEFT WING INBD EDGE FORE FLAP DELAMINATED ON UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.
Back to Boeing 737-3H4