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 SWAA2015102345293Support Angle · crackedLEFT WING WIPER WEB SUPPORT ANGLE CRACKED AT RSS 550. R & R ANGLE IAW SRM.SDR SWAA2015102245236Stiffener · crackedAFT CARGO FWD BULKHEAD, HORIZONTAL STIFFENER, CRACKED AT BS 727, STRINGER 27R. R & R STIFFENER IAW SRM.SDR SWAA2015102145187Support Angle · crackedLEFT WING NR 1 PYLON, OTBD UPPER TE PANEL SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015101945078Web · corrodedAFT ENTRY DOOR THRESHOLD WEB CORRODED AT BS 983, LBL 60. R & R WEB IAW SRM.SDR SWAA2015101645027Fairing · crackedLEFT WING NR 2 FLAP TRACK, CANOE FAIRING AFT TAIL CONE CRACKED AT FASTENER HOLES. R & R FAIRING IAW SRM.SDR SWAA2015100944740Support Angle · crackedLEFT WING NR 1 PYLON INBD UPPER TE PANEL SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2015100144461Light · inoperativeLEFT OVERWING EXIT WINDOW LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SWAA2015100144435Valve · faultyDIVERSION, DECLARED EMER, CABIN ALTITUDE WARNING HORN & LIGHT ON, DURING CLIMB OUT PASSING FL190. NO AUTO FAIL OR ASSOCIATED LIGHTS OR INDICATIONS. OFF SCHEDULE DESCENT LIGHT ON DURING DESCENT. CABIN ALTITUDE REACHED 17,000'. MASKS DEPLOYED IN CABIN AUTOMASDR SWAA2015111346039Spar · crackedLEFT WING REAR SPAR, UPPER CHORD SPLICE CRACKED AT UPPER INBD FASTENER HOLE, COMMON TO MLG SUPPORT BEAM AFT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015111346038Spar · crackedRIGHT WING REAR SPAR UPPER CHORD, CRACKED IN UPPER INBD FASTENER HOLE, COMMON TO MLG SUPPORT BEAM AFT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015111045935Skin · crackedR2 DOOR CUT OUT AT LOWER FWD CORNER CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2015110245594Support Fitting · corrodedLEFT WING NR 4 FWD INBD FLAP TRACK SUPPORT FITTING CORRODED. REPAIRED FITTING IAW EO & EA.SDR SWAA2015102645294Strap · crackedFLOORBEAM STABILIZER STRAP CRACKED AT BS 320, LBL 48. REPAIRED STRAP IAW SRM.SDR SWAA2015102345292Shear Tie · corrodedSHEAR TIE CORRODED AT BS 887, BETWEEN STRINGER 27L - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015102145189Stiffener · crackedHORIZONTAL STIFFENER CRACKED AT BS 178, RBL 16. R & R STIFFENER IAW SRM.SDR SWAA2015011544941Crease Beam · corrodedAFT CARGO COMPARTMENT, CREASE BEAM WEB CORRODED, BETWEEN BS 907 - 927, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015100744658Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 360, STRINGER 11L. R & R WEB IAW SRM & DWG.SDR SWAA2015092944396Lens · looseAFT CABIN OVERHEAD EXIT SIGN LENS COVER LOOSE. R & R COVER IAW AMM.SDR SWAA2015092944389Light · inoperativeR1 DOOR EXTERNAL EXIT SLIDE LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015111646087Bracket · crackedFORWARD CARGO BAY LT BRACKET CRACKED AT BS 500C, BETWEEN STRINGER 25R - 26R. R & R LT BRACKET IAW DWG & SRM.SDR SWAA2015110245593Rib · crackedLEFT WING RIB INTERNAL AREA, UPPER CHORD CRACKED AT WBL 114.00 ON REAR SPAR. REPAIRED CHORD IAW EO & EA.SDR SWAA2015102345291Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 500B, BETWEEN STRINGER 28R - 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015101544940Stringer · corrodedAFT CARGO COMPARTMENT STRINGER CORRODED, BETWEEN BS 887-4 TO 887+3.5, STRINGER 21R. R & R STRINGER IAW SRM.SDR SWAA2015101344859Shear Tie · corrodedFORWARD CARGO BAY FRAME SHEAR TIE CORRODED AT BS 500B, BETWEEN STRINGER 26L - 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015100944738Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 500C, BETWEEN, STRINGER 28R - 27R. R & R SHEAR TIE IAW SRM.SDR SWAA2015100744657Shear Tie · corrodedFRAME SHEAR TIE, CORRODED AT BS 480, STRINGER 27R. R & R SHEAR TIE IAW DWG.SDR SWAA2015100544579Bracket · corrodedAFT CARGO COMPARTMENT BRACKET CORRODED AT BS 887, BETWEEN STRINGER 23L - 25L. REPAIRED BRACKET IAW SRM & DWG.SDR SWAA2015100144418Fairing · delaminatedLEFT WING NR 3 FLAP FAIRING DELAMINATED INBD AFT SIDE. REPAIRED NR 3 FLAP FAIRING IAW EA.SDR SWAA2015092944369Light · inoperativeRIGHT LOWER EMER EXIT LIGHT COVER INOPERATIVE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015092944368Lens · missingRIGHT OVERWING LOWER EXIT SIGN LENS COVER MISSING. R & R LENS IAW AMM.SDR SWAA2015092944367Light · inoperativeLEFT LOWER EMER EXIT LIGHT COVER INOPERATIVE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015092844310Cover · brokenFRONT RT EMER EXIT LIGHT COVER BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015112346282Frame · corrodedFRAME CORRODED AT BS 727E, LBL 7. R & R FRAME IAW EA & DWG.SDR SWAA2015110245592Support Fitting · looseLEFT WING NR 4 FWD INBD FLAP TRACK SUPPORT FITTING LOOSE. REPAIRED FITTING IAW EO & EA.SDR SWAA2015101344864Plate · crackedLEFT SIDE WING TO BODY FAIRING PLATE CRACKED AT BS 727, AT LOWER FUSELAGE. R & R PLATE IAW SRM.SDR SWAA2015101244826Lens · brokenRIGHT OVERHEAD STOWAGE BIN BULLNOSE, LIGHT LENS BROKEN AT ROW 1. R & R LENS IAW AMM.SDR SWAA2015100944762Frame · crackedFRAME STUB BEAM INNER CHORD LOWER FASTENER HOLE CRACKED AT BS 616, STRINGER 17R. REPAIRED CHORD IAW EA.SDR SWAA2015100844728Fairing · crackedLEFT WING LOWER TE PANEL JUST INBD OF NR 3 FLAP TRACK FAIRING, CRACKED ON UPPER SURFACE. REPAIRED FAIRING IAW SRM.SDR SWAA2015101144628Intercostal · crackedR1 DOOR INTERCOSTAL WEB CRACKED, BETWEEN BS 277 - 291.5, STRINGER 14R. R & R WEB IAW EA.SDR SWAA2015092944359Light · inoperativeLEFT OVERWING EMER EXIT LIGHT INOPERATIVE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015092844332Cover · looseR2 DOOR EXIT LIGHT COVER LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015092844323Cover · missingLEFT FWD EXIT SIGN COVER MISSING. INSTALLED SIGN IAW SIP.SDR SWAA2015112446403Stringer · corrodedSTRINGER CORRODED AT BS 420, STRINGER 25R. R & R STRINGER IAW SRM & DWG.SDR SWAA2015112346288Skin · crackedRIGHT WING UPPER SKIN, CRACKED AT AFT SPAR FASTENER, STATION 175. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015112346304Stringer · corrodedFORWARD CARGO COMPARTMENT, FWD OF DOOR CUT OUT CORRODED, BETWEEN BS 420 - 440, STRINGER 25R. R & R STRINGER IAW SRM.SDR SWAA2015111846170Fitting · corrodedR1 DOOR AFT GIRT BAR FLOOR BRACKET FITTING CORRODED. R & R FITTING IAW AMM.SDR SWAA2015111846169Fitting · corrodedR1 DOOR ESCAPE SLIDE GIRT BAR FLOOR BRACKET FITTING CORRODED. R & R FITTING IAW AMM.SDR SWAA2015110245652Fitting · crackedRIGHT WING NR 5 INBD GND SPOILER FITTING CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2015102345276Fitting · crackedL1 DOOR LOWER HINGE CUT OUT FITTING CRACKED AT BS 303.9, WL 236.1. R & R FITTING IAW SRM & DWG.SDR SWAA2015102045143Fitting · crackedRIGHT WING NR 6 FLAP TRACK FAIRING SIDEWALL FITTING CRACKED. R & R FITTING IAW SRM & DWG.
Back to Boeing 737-3H4