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 SWAA2016011948149Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, STRINGER 27L. R & R SHEAR TIE PER SRM & DWG.SDR SWAA2016011948109Skin · crackedR1 DOOR UPPER HINGE CUT OUT CRACKED AT BS 290 RT, WL 257. REPAIRED CUT OUT IAW EA.SDR SWAA2016011147873Skin · corrodedFRAME SKIN WEB CORRODED AT BS 500A, BETWEEN STRINGER 28L - 28R. REPAIRED SKIN IAW SRM.SDR SWAA2016011147872Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 500A - 500B. R & R WEB IAW SRM & DWG.SDR SWAA2016011147871Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 500B - 500C. R & R WEB IAW SRM & DWG.SDR SWAA2016011147870Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 460 - 480. R & R WEB IAW SRM & DWG.SDR SWAA2016011147869Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 867 - BS 887. R & R WEB IAW SRM & DWG.SDR SWAA2016011147868Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 887 - 907. R & R WEB IAW SRM & DWG.SDR SWAA2016011147867Door Sill · corrodedFORWARD CARGO DOOR CUT OUT LOWER SILL WEB CORRODED BETWEEN BS 440 - 492.4. R & R WEB IAW DWG & SRM.SDR SWAA2016010847817Web · crackedAFT CARGO COMPARTMENT, WEB CRACKED ON LOWER SILL, LOCATED AT BS 794.3, BETWEEN STRINGER 23R - 25R. R & R WEB IAW SRM & DWG.SDR SWAA2016010647698Crossbeam · crackedAFT CARGO COMPARTMENT DOOR INTERNAL STRUCTURE AT INNER CHORD CRACKED ON HOLE, LOCATED 4.5" FROM AFT EDGE ON AFT END OF CROSSBEAM E. R & R CHORD IAW SRM & DWG.SDR SWAA2016010647697Door Sill · corrodedL1 DOOR MOP SILL CORRODED, BETWEEN BS 300 - 360, LBL 58. REMOVED MOP SILL IAW SRM & DWG.SDR SWAA2016010647696Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 727B - 727C. R & R WEB IAW SRM.SDR SWAA2016010647691Attach Fitting · crackedLONGITUDINAL FLOORBEAM CRACKED ATTACHMENT CLIP CRACKED AT BS 639, RBL 45.5. R & R CLIP IAW SRM & DWG.SDR SWAA2016010547651Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 277, STRINGER 10R. R & R CLIP IAW SRM.SDR SWAA2016010547647Frame · crackedFUSELAGE FRAME CRACKED AT STATION 500C, STRINGER 20L - 21L. REPAIRED FRAME IAW SRM.SDR SWAA2016010447597Door Sill · corrodedSILL WEB CORRODED AT STATION 300 - 330, RBL 59. REPAIRED WEB IAW SRM.SDR SWAA2015123147557Floor Support · corrodedFLOOR SUPPORT CORRODED AT STATION 316, RBL 11, WL 208. R & R SUPPORT IAW SRM.SDR SWAA2015122947489Skin · crackedFUSELAGE SKIN CRACKED AT STATION 747+3, STRINGER 18L. REPAIRED SKIN IAW EA.SDR SWAA2015122947488Skin · crackedFUSELAGE SKIN CRACKED AT STATION 727D+3, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2015122947487Skin · crackedFUSELAGE SKIN CRACKED AT STATION 767+3, STRINGER 18L. REPAIRED SKIN IAW EA.SDR SWAA2015122347409Skin · crackedLEFT WING UPPER SKIN CRACKED AT WBL 141, AFT EDGE. REPAIRED SKIN IAW EA.SDR SWAA2015122247361Skin · crackedFUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUT OUT. REPAIRED SKIN IAW SRM.SDR SWAA2015121747257Cover · brokenL1 DOOR EMER EXIT LIGHT COVER BROKEN. R & R COVER IAW MM.SDR SWAA2015121747256Angle · crackedRIGHT WING ANGLE CRACKED IN AILERON REAR SPAR BAY AT APPROX RSS 545. R & R ANGLE IAW SRM.SDR SWAA2015121747255Angle · crackedLEFT WING TE INTERIOR, FWD OF AILERON NR 2 HINGE, LT ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015121747254Cable · misroutedR2 DOOR EMER EVAC SLIDE LATCH CABLE MIS-ROUTED. RE-ROUTED CABLE IAW AMM.SDR SWAA2016021048904Bracket · crackedRIGHT WING BRACKET CRACKED AT RSS 234. R & R BRACKET IAW SRM & DWG.SDR SWAA2016020948802Rib · crackedLEFT WING LOWER RIB CHORD CRACKED ON WBL 135.50, BETWEEN STATION 2 & 3. REPAIRED CHORD IAW EA.SDR SWAA2016020248600Frame · crackedFORWARD GALLEY AREA, STUB FRAME WEB CRACKED AT BS 296.4, STRINGER 7R. REPAIRED STUB FRAME IAW EA.SDR SWAA2016020148537Hook · corrodedRIGHT EMER EXIT HATCH ESCAPE STRAP HOOK CORRODED. R & R HOOK IAW AMM.SDR SWAA2016020148529Hook · corrodedLEFT EMER EXIT HATCH ESCAPE STRAP HOOK CORRODED. R & R HOOK IAW AMM.SDR SWAA2016013048458Slat Track · corrodedRIGHT WING NR 4 SLAT, OTBD MAIN TRACK CORRODED. R & R NR 4 SLAT, OTBD TRACK IAW MM.SDR SWAA2016013048457Slat Track · corrodedLEFT WING NR 2 SLAT, OTBD MAIN TRACK CORRODED. R & R NR 2 SLAT TRACK IAW AMM.SDR SWAA2016012548343Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 440, STRINGER 26L. R & R ANGLE IAW SRM & DWG.SDR SWAA2016012248310Floorbeam · corrodedFLOORBEAM UPPER FLANGE, T CHORD CORRODED AT BS 986, LBL 40. R & R T CHORD IAW SRM & EA.SDR SWAA2016012148244Skin · crackedRIGHT WING UPPER SKIN CRACKED FASTENER HOLES AFT OF REAR SPAR, BETWEEN RSS 265 - 270. REPAIRED SKIN IAW EA.SDR SWAA2016012148243Skin · crackedRIGHT WING UPPER WING SKIN TE CRACKED AT FASTENER HOLE RSS 255.5. REPAIRED SKIN IAW EA.SDR SWAA2016012048214Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 15R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2016011948157Skin · crackedLEFT WING UPPER SKIN CRACKED, AT FASTENER HOLE AFT OF REAR SPAR, AT RSS 270. REPAIRED SKIN IAW ER & EA.SDR SWAA2016011948148Intercostal · crackedINTERCOSTAL CRACKED, BETWEEN BS 277 - 291.5, STRINGER 19R. R & R INTERCOSTAL IAW ER & EA.SDR SWAA2016011948147Angle · crackedFORWARD GALLEY ANGLE CRACKED, BETWEEN BS 291.5 - 277, BETWEEN STRINGER 10R - 11R. R & R ANGLE IAW EA.SDR SWAA2016011948129Link · corrodedRIGHT MLG BEAM, SWING LINK CORRODED. REPAIRED SWING LINK IAW EA.SDR SWAA2016011948128Link · corrodedLEFT MLG BEAM, SWING LINK CORRODED. REPAIRED SWING LINK IAW EA.SDR SWAA2016011948127Skin · crackedLEFT WING UPPER WING SKIN AFT SPAR, AFT FASTENER HOLE CRACKED, BETWEEN RSS 267 - 237.5. REPAIRED SKIN IAW EA.SDR SWAA2016011548038Support Angle · crackedLEFT WING AILERON INBD CTR HINGE FITTING, LOWER INBD PANEL SUPPORT ANGLE CRACKED AT AFT END. R & R ANGLE IAW DWG.SDR SWAA2016011548037Intercostal · crackedINTERCOSTAL & FRAME SUPPORT STRUCTURE CRACKED, BETWEEN BS 277 - 291.5, STRINGER 11R. R & R INTERCOSTAL IAW ER & EA.SDR SWAA2016011147866Floorbeam · corrodedFLOORBEAM CORRODED AT BS 967, BETWEEN RBL 27 - 42. REPAIRED FLOORBEAM IAW EA.SDR SWAA2016011147865Shear Web · corrodedSHEAR WEB CORRODED AT BS 987, BETWEEN LBL 35 - 39. R & R SHEAR WEB IAW SRM & DWG.SDR SWAA2016010747759Stiffener · crackedVERTICAL STIFFENER HOLE CRACKED AT BS 663, RBL 6.15. R & R STIFFENER IAW SRM & DWG.
Back to Boeing 737-3H4