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 SWAA2016060652367Support Fitting · corrodedLEFT WING NR 4 INBD FLAP TRACK, FORWARD SUPPORT FITTING CORRODED AT WBL 66.5. REPAIRED FITTING IAW EA.SDR SWAA2016052652128Frame · corrodedFRAME CORRODED AT BS 360, LBL 2. REPAIRED FRAME IAW ER & EA.SDR SWAA2016051151704Support Fitting · crackedRIGHT WING AFT SUPPORT FITTING FASTENER HOLE CRACKED ON REAR SPAR AT RSS 222.5. R & R FITTING IAW SRM & DWG.SDR SWAA2016050451533Link Assy · corrodedLEFT MLG SWING LINK CORRODED ON HOLES. REPAIRED SWING LINK IAW CMM.SDR SWAA2016050451532Link Assy · corrodedRIGHT MLG SWING LINK HOLES CORRODED. REPAIRED SWING LINK IAW CMM.SDR SWAA2016042251223Actuator · leakingRIGHT WING NR 6 FLIGHT SPOILER ACTUATOR EXTERNAL HYD LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2016042251222Actuator · leakingLEFT WING NR 3 FLIGHT SPOILER ACTUATOR EXTERNAL HYD LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2016042251219Sign · looseLEFT OVERHEAD BIN EMER EXIT SIGN LOOSE AT ROW 2. R & R SIGN IAW AMM.SDR SWAA2016060852641Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 27R - 26R. R & R SHEAR TIE IAW SRM.SDR SWAA2016060852640Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 27R - 27L. R & R SHEAR TIE IAW SRM.SDR SWAA2016060652266Frame · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 25L - 26L. R & R FRAME IAW SRM & DWG.SDR SWAA2016052652127Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727D, BETWEEN STRINGER 26L - 27L. REPAIRED SHEAR TIE IAW ER & EA.SDR SWAA2016052352016Link · damagedLEFT MLG BEAM SWING LINK ASSEMBLY PITTED ON AFT FACE OF AFT FITTING LOWER BOLT HOLE. R & R SWING LINK IAW AMM.SDR SWAA2016051851905Fitting · crackedLEFT WING NR 3 FAIRING INBD FLAP, OTBD TRACK INTERFACE FITTING CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2016051351752Bracket · corrodedBRACKET CORRODED AT BS 794.3, STRINGER 25.26R. R & R BRACKET IAW DWG.SDR SWAA2016051251719Strap · corrodedAFT CARGO FLOOR STRAP CORRODED AT BS 794.3, BETWEEN STRINGER 25R - 26R. R & R STRAP IAW DWG.SDR SWAA2016051251718Threshold · corrodedAFT CARGO THRESHOLD WEB CORRODED. R & R WEB IAW DWG.SDR SWAA2016051251717Fitting · corrodedAFT CARGO INBD INTERCOSTAL THRESHOLD CLIP CORRODED AT BS 794. R & R CLIP IAW DWG.SDR SWAA2016050551590Angle · crackedRIGHT WING NR 6 FAIRING INBD FLAP, OTBD TRACK ANGLE CRACKED AT LEVEL OF WBL 198.6. R & R ANGLE IAW SRM & DWG.SDR SWAA2016050451547Crossbeam · crackedAFT CARGO DOOR FWD END OF CROSSBEAM E CRACKED AT UPPER FASTENER HOLE, 3RD HOLE AFT FROM FITTING. REPAIRED CROSSBEAM E IAW SRM & DWG.SDR SWAA2016042951413Angle · crackedLEFT WING ANGLE CRACKED OTBD SIDE ON INBD FLAP OUTBOARD TRACK FAIRING 3 AT LEVEL OF WBL 198.6. R & R ANGLE IAW SRM & DWG.SDR SWAA2016042251217Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 440, STRINGER 2R. R & R CLIP IAW SRM.SDR SWAA2016042251216Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 440, STRINGER 1. R & R CLIP IAW SRM.SDR SWAA2016042251215Stringer · crackedSTRINGER CRACKED AT BS 440, STRINGER 2R. R & R STRINGER IAW SRM.SDR SWAA2016051851909Bracket · crackedRIGHT AFT NAC STRUT BRACKET CRACKED AT FAIRING ATTACH POINT. R & R BRACKET IAW DWG & SRM.SDR SWAA2016051251721Bracket · crackedLEFT WING PULLEY BRACKET CRACKED AT RSS 230.00. R & R BRACKET IAW SRM & DWG.SDR SWAA2016050551571Splice Plate · crackedLEFT WING REAR SPAR UPPER TE SPLICE PLATE CRACKED AT RSS 202. R & R SPLICE PLATE IAW SRM & DWG.SDR SWAA2016052652131Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT 5 O'CLOCK POSITION ON LOWER VERTICAL FASTENER ON UPPER CHORD ABOUT RSS 222. REPAIRED CHORD IAW ER & EA.SDR SWAA2016042151205Angle · crackedLEFT WING REAR SPAR RSS 280, FIRE BOX RIB LOWER ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2016041851038Battery · dischargedFORWARD FLASHLIGHT BATTERY LOW. R & R BATTERY IAW MM.SDR SWAA2016052652150Splice · crackedRIGHT WING REAR SPAR UPPER CHORD SPLICE CRACKED ON FASTENER HOLE AT RSS 222.5. REPAIRED CHORD IAW EA.SDR SWAA2016052652138Splice · crackedLEFT WING REAR SPAR UPPER CHORD SPLICED CRACKED AT RSS 222.5. REPAIRED SPLICE IAW EA.SDR SWAA2016052352027Doubler · crackedRIGHT WING NR 6 SLAT FIXED LE INTERNAL NOSE BEAM DOUBLER CRACKED AT TAI DUCT CUT OUT. R & R SLAT IAW SRM.SDR SWAA2016051951953Skin · crackedRIGHT WING UPPER SKIN FASTENER HOLE CRACKED AT RSS 249. R & R SKIN IAW EA & SRM.SDR SWAA2016051951952Skin · crackedLEFT WING UPPER SKIN MOST AFT FASTENER HOLES CRACKED, BETWEEN RSS 235 - 267. REPAIRED SKIN IAW EA.SDR SWAA2016051951949Skin · crackedRIGHT WING UPPER SKIN CRACKED AT RSS 237, AFT FASTENER ROW. REPAIRED SKIN IAW EA.SDR SWAA2016051351754Splice · crackedBUTT JOINT SPLICE STRAP CRACKED AT BS 360, STRINGER 3R. REPAIRED SPLICE IAW EA.SDR SWAA2016042951436Floor Support · crackedLONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 662, RBL 24.8, CTR WING BOX. REPAIRED CHORD IAW EA.SDR SWAA2016060652504Spar · crackedRIGHT WING AFT SPAR UPPER CHORD CRACKED IN NR 5 OPENED FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2016060652503Spar · crackedLEFT WING AFT SPAR UPPER CHORD CRACKED INDICATION IN NR 5 OPENED FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2016060152184Slide · out of positionR2 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2016052352006Connector · missingG1 GALLEY EMER EXIT LIGHT CONNECTOR MISSING. R & R CONNECTOR ASSEMBLY IAW AMM.SDR SWAA2016051951927Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 727E, STRINGER 27L. REPAIRED SHEAR TIE IAW EA.SDR SWAA2016051651802Intercostal · crackedFORWARD GALLEY DOOR INTERCOSTAL CRACKED AT BS 277, STRINGER 14R. REPAIRED INTERCOSTAL IAW EA.SDR SWAA2016051351757Intercostal · crackedFORWARD GALLEY DOOR INTERCOSTAL WEB CRACKED AT BS 277, STRINGER 14R. REPAIRED INTERCOSTAL IAW EA.SDR SWAA2016051251716Web · crackedRIGHT NLG WW SIDE WEB CRACKED AT BS 251 - 243. REPAIRED WEB IAW SRM.SDR SWAA2016051051681Scuff Plate · crackedAFT CARGO DOOR SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2016042551295Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 4L. R & R CHANNEL IAW DWG & EA.SDR SWAA2016041851011Acm · leakingAIR TURN BACK, DECLARED EMER JUST OUT OF 10,000'. FLIGHT ATTENDANT CALLED TO INFORM OF SMOKE SMELL IN CABIN. FOUND RT ACM LEAKED OIL INTERNALLY. R & R RT ACM IAW MM.SDR SWAA2016041550952Lens · looseRIGHT OVERWING EXIT LOWER EMER EXIT LIGHT LENS COVER LOOSE. SECURED LENS IAW EA.
Back to Boeing 737-3H4