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 SWAA2016031549915Floorbeam · corrodedFUSELAGE FLOORBEAM CORRODED, AT STATION 986, RBL 42 TO LBL 45. REPAIRED BEAM IAW SRM & EA.SDR SWAA2016031449850Crease Beam · corrodedLEFT CREASE BEAM CORRODED, BETWEEN BS 986 - 992, STRINGER 17L. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2016031449849Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT BS 1002, STRINGER 17R. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2016031049784Support · corrodedPASSENGER LT CABIN FLOOR STRUCTURE SUPPORT CORRODED, AT BS 984, LBL 16. R & R SUPPORT IAW SRM.SDR SWAA2016030749677Skin · crackedFUSELAGE SKIN CRACKED AT BS 867+2, STRINGER 6L. REPAIRED SKIN IAW SRM.SDR SWAA2016030749676Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+2, STRINGER 8R. REPAIRED SKIN IAW EA.SDR SWAA2016030749675Skin · crackedFUSELAGE SKIN CRACKED AT BS 307, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2016030449647Skin · crackedFUSELAGE SKIN CRACKED AT BS 908+5.5, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2016030249585Angle · crackedRIGHT STUB BEAM LOWER FASTENER ANGLE CRACKED AT BS 616. REPAIRED ANGLE IAW EA.SDR SWAA2016030249575Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 793, STRINGER 26R. R & R CLIP IAW SRM & DWG.SDR SWAA2016022349318Lens · looseL1 DOOR EMER EXIT SIGN LOOSE LENS. R & R LENS IAW AMM.SDR SWAA2016033150476Support Fitting · crackedLEFT MLG AFT SUPPORT FITTING CRACKED AT NR 5 HOLE, AFT SIDE OF HOLE. R & R FITTING IAW EA.SDR SWAA2016033050433Support Fitting · crackedRIGHT AFT MLG SUPPORT FITTING CRACKED AT NR 5 HOLE, AFT SIDE OF HOLE. R & R FITTING IAW EA.SDR SWAA2016032850257Stiffener · crackedRIGHT MAIN GEAR WW REAR SPAR VERTICAL STIFFENER CRACKED AT BS 663, RBL 6.15. REPAIRED STIFFENER IAW EA.SDR SWAA2016032150010Skin · crackedLEFT WING UPPER SKIN CRACKED AT HOLE NR 78. REPAIRED SKIN IAW EA.SDR SWAA2016032150009Skin · crackedLEFT WING UPPER SKIN CRACKED AT HOLE NR 71. REPAIRED SKIN IAW EA.SDR SWAA2016030949772Intercostal · crackedMAIN CABIN INTERCOSTAL ATTACH ANGLE CRACKED AT BS 277, STRINGER 10R. R & R INTERCOSTAL IAW DWG & SRM.SDR SWAA2016030749685Frame · crackedLEFT STUB BEAM FRAME WEB INNER CHORD CRACKED, AT BS 639, WL 208. REPAIRED FRAME IAW EA.SDR SWAA2016030149558Roller · missingRIGHT WING MID FLAP, FWD OTBD GUIDE ROLLER MISSING. R & R ROLLER IAW CMM.SDR SWAA2016022949504Attach Angle · crackedMAIN CABIN INTERCOSTAL ATTACH ANGLE CRACKED AT BS 290, STRINGER 10R. R & R ANGLE IAW DWG & SRM.SDR SWAA2016022649454Attach Angle · crackedMAIN CABIN INTERCOSTAL ATTACH ANGLE CRACKED AT BS 289, STRINGER 11R. R & R ANGLE IAW DWG & SRM.SDR SWAA2016033050432Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 221, AT FITTING CUT OUT. REPAIRED SPAR WEB IAW EA.SDR SWAA2016032850285Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 221, AT FITTING CUT OUT. REPAIRED WEB IAW EA.SDR SWAA2016032150071Roller · damagedRIGHT WING NR 7 FLAP TRACK FAIRING, A FRAME INBD ROLLER DAMAGED. R & R ROLLER ASSEMBLY IAW CMM.SDR SWAA2016032150045Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 908, STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2016032150044Skin · crackedFORWARD ENTRY DOOR UPPER HINGE CUT OUT CRACKED AT BS 305, WL 258. REPAIRED CUT OUT IAW EA.SDR SWAA2016031649952Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 360, BETWEEN STRINGER 28L & 28R. REPAIRED FRAME IAW SRM.SDR SWAA2016031649951Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 360, BETWEEN STRINGER 27R & 28R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016031449848Cusp Web · corrodedLEFT MAIN CABIN CUSP WEB CORRODED AT BS 430, STRINGER 17L. REPAIRED WEB IAW EA.SDR SWAA2016031149804Cusp Web · corrodedRIGHT MAIN CABIN CUSP WEB CORRODED, AT BS 390. R & R CUSP WEB IAW DWG & SRM.SDR SWAA2016030949771Intercostal · crackedFORWARD GALLEY DOOR SURROUND, FWD INTERCOSTAL WEB CRACKED, BETWEEN BS 277 - 291.5, STRINGER 14R. R & R INTERCOSTAL IAW SRM & EA.SDR SWAA2016030449653Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 8R. R & R CLIP IAW SRM & DWG.SDR SWAA2016030249584Angle · crackedLEFT WING INBD FLAP, OTBD TRACK 3 FAIRING ANGLE CRACKED, UPPER POSITION INTERNAL AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2016022349340Lens · missingFORWARD ENTRY EMER EXIT INDICATOR LENS MISSING. INSTALLED LENS IAW MM.SDR SWAA2016022349337Stiffener · crackedLEFT WING NR 3 INBD FLAP, OTBD TRACK STIFFENER CRACKED. R & R STIFFENER IAW DWG & SRM.SDR SWAA2016022349317Light · looseRIGHT LUMINESCENT FLOOR STRIP LOOSE AT ROW 8. SECURED LIGHT IAW AMM.SDR SWAA2016041851074Light · inoperativeLEFT OVERWING EMER EXIT HANDLE LIGHT INOPERATIVE. RELAMPED LIGHT IAW WDM.SDR SWAA2016040650634Frame · crackedFRAME CRACKED AT BS 291.5, STRINGER 10R. REPAIRED FRAME IAW EA.SDR SWAA2016040550612Attach Angle · crackedLEFT WING NR 3 INBD FLAP, OTBD TRACK FAIRING, OTBD FWD LOWER PANEL ATTACH ANGLE CRACKED. R & R ANGLE IAW DWG & SRM.SDR SWAA2016040550603Frame · corrodedAFT PIT FRAME CORRODED AT BS 747, BETWEEN STRINGER 27L - 26L. REPAIRED FRAME IAW SRM.SDR SWAA2016032450184Crease Beam · crackedRIGHT CREASE BEAM CRACKED AT STATION 616. REPAIRED CREASE BEAM IAW EA.SDR SWAA2016032250110Crease Beam · corrodedCREASE BEAM CORRODED AT BS 320, RBL 58. R & R CREASE BEAM IAW SRM.SDR SWAA2016032150015Skin · crackedRIGHT WING UPPER TE SKIN, AFT OF SPAR CHORD CRACKED FASTENER HOLES, BETWEEN RSS 230 - RSS 253. REPAIRED SKIN IAW EA & ER.SDR SWAA2016031749960Threshold · corrodedAFT CARGO DOOR THRESHOLD WEB CORRODED AT STATION 794 - 847. REPAIRED WEB IAW SRM.SDR SWAA2016031649958Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 908, STRINGER 6L. R & R SPLICE IAW SRM.SDR SWAA2016031649950Crease Beam · crackedRIGHT CREASE BEAM CORRODED AT STATION 294 - 328. REPAIRED CREASE BEAM IAW SRM.SDR SWAA2016031649947Fitting · crackedLEFT WING REAR SPAR FITTING CRACKED AT NR 5 HOLE. R & R FITTING IAW EA.SDR SWAA2016031549921Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 360, STRINGER 3R. R & R SPLICE IAW EA.SDR SWAA2016031549920Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 360, STRINGER 4R. R & R SPLICE IAW EA.SDR SWAA2016031449847Door Frame · crackedR1 DOOR CUT OUT AFT FRAME STRUCTURE, T CHORD CRACKED AT BS 332, AT DOOR STOP NR 1. R & R T CHORD IAW SRM & DWG.
Back to Boeing 737-3H4