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 SWAA2015102645344Door Sill · corrodedAFT CARGO DOOR, UPPER SILL CORRODED, BETWEEN BS 792 - 827 UPPER SURFACE. R & R WEB IAW DWG & SRM.SDR SWAA2015102645299Fitting · crackedFORWARD GALLEY SERVICE DOOR CUT OUT FITTING CRACKED AT BS 296, STRINGER 8R. R & R FITTING IAW SRM & DWG.SDR SWAA2015102645298Crease Beam · corrodedCREASE BEAM WEB CORRODED, BETWEEN BS 500B - 500C, WL 208, LT SIDE. R & R WEB IAW SRM.SDR SWAA2015102645297Crease Beam · corrodedCREASE BEAM WEB CORRODED, BETWEEN BS 500 TO BS 500, WL 208 RT SIDE. R & R WEB IAW SRM.SDR SWAA2015101344876Beam · corrodedRIGHT MLG WALKING BEAM HANGER CORRODED. REPAIRED BEAM IAW CMM.SDR SWAA2015100944739Bracket · crackedLEFT WING INBD FLAP, OTBD TRACK FAIRING, FLAPPER DOOR BRACKET CRACKED. R & R BRACKET IAW DWG.SDR SWAA2015100544530Skin · delaminatedRIGHT WING OTBD FORE FLAP UPPER SURFACE DELAMINATED. R & R FORE FLAP IAW MM.SDR SWAA2015121146971Frame · crackedFRAME WEB CRACKED AT BS 328, BETWEEN STRINGER 20R - 21R. FRAME WEB IAW EA.SDR SWAA2015112346325Spar · crackedRIGHT WING UPPER REAR SPAR CHORD CRACKED, BETWEEN RSS 224 - 14. REPAIRED CHORD IAW EA & ER.SDR SWAA2015112346324Spar · crackedLEFT WING UPPER REAR SPAR CHORD CRACKED, BETWEEN RSS 224 - 214. REPAIRED CHORD IAW ER & EA.SDR SWAA2015112346323Frame · crackedFRAME WEB CRACKED AT BS 500C, BETWEEN STRINGER 21R - 22R. REPAIRED FRAME IAW ER & EA.SDR SWAA2015112346283Frame · corrodedFRAME CORRODED AT BS 992.8, RBL 48. R & R FRAME IAW EA.SDR SWAA2015112346266Frame · crackedFRAME WEB CRACKED AT BS 500B, BETWEEN STRINGER 21R - 22R. REPAIRED FRAME IAW ER & EA.SDR SWAA2015111145971Crease Beam · corrodedRIGHT DOOR CREASE BEAM CORRODED, BETWEEN BS 963 - 986, RBL 48. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2015111045937Floorbeam · crackedFLOORBEAM UPPER CHORD, CRACKED AT BS 727B, LBL 45.5, AFT OTBD FASTENER. REPAIRED CHORD IAW ER & EA.SDR SWAA2015110945873Keelbeam · corrodedRIGHT KEEL BEAM CORRODED, BETWEEN BS 707 - 727, LOWER SURFACE. R & R KEEL BEAM IAW SRM.SDR SWAA2015110945872Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986, BETWEEN RBL 40 TO RBL 50. REPAIRED FLOORBEAM IAW ER & EA.SDR SWAA2015110645825Support Angle · crackedRIGHT WING AILERON WIPER, WEB SUPPORT ANGLE CRACKED AT RRS 550. R & R ANGLE IAW SRM.SDR SWAA2015110345682Attach Angle · crackedLEFT WING OTBD TE, OTBD FIRE BOX AFT INBD ATTACH ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2015110245656Floor Support · corrodedAFT CARGO FLOOR SUPPORT CORRODED AT BS 942, RBL 3. REPAIRED SUPPORT IAW SRM.SDR SWAA2015110245595Skin · delaminatedLEFT WING INBD FORE FLAP LOWER SKIN DELAMINATED. R & R FORE FLAP IAW AMM.SDR SWAA2015110245580Door Frame · corrodedAFT CARGO FRAME CORRODED AT BS 807, STRINGER 26L. R & R FRAME IAW SRM.SDR SWAA2015110245575Floor Support · corrodedAFT CARGO FLOOR SUPPORT, CORRODED AT BS 944, STRINGER 25L. REPAIRED SUPPORT IAW SRM.SDR SWAA2015102945512Floor Support · corrodedAFT CARGO FLOOR SUPPORT CORRODED AT BS 944, STRINGER 25R. REPAIRED SUPPORT IAW SRM.SDR SWAA2015102845437Support Beam · corrodedRIGHT WING MLG SUPPORT BEAM BORE CORRODED. REPAIRED BEAM ASSEMBLY IAW EO & EA.SDR SWAA2015102645343Floor Support · crackedLONGITUDINAL FLOORBEAM, WEB CRACKED BETWEEN BS 707 - 709, LBL 24.8. REPAIRED WEB IAW EA & AMM.SDR SWAA2015102645342Floor Support · corrodedAFT CARGO FLOOR SUPPORT CORRODED, AT BS 942, LBL 3. REPAIRED SUPPORT IAW SRM.SDR SWAA2015102645296Structure · crackedFLOORBEAM UPPER CHORD ATTACH STRAP CRACKED AT BS 727B, RBL 24.8, FWD OTBD FASTENER HOLE. R & R CHORD IAW ER & EA.SDR SWAA2015102645295Fitting · crackedAFT CARGO FRAME TO DOOR SILL CLIP CRACKED AT BS 807, STRINGER 25R. R & R CLIP IAW SRM.SDR SWAA2015102345275Beam · crackedLONGITUDINAL BEAM UPPER CHORD CRACKED AT BS 664+6, LBL 24.8. R & R CHORD IAW EA & SRM.SDR SWAA2015101945040Hinge Fitting · corrodedLEFT HORIZONTAL STABILIZER CTR SECTION HINGE FITTING CORRODED. R & R FITTING IAW CMM.SDR SWAA2015101645028Fairing · crackedRIGHT WING NR 8 FLAP TRACK, FAIRING AFT TAIL CONE CRACKED AT FASTENER HOLE OTBD SIDE. R & R FAIRING IAW SRM.SDR SWAA2015101544950Panel · crackedPANEL BREAK ASSEMBLY CRACKED AT BS 540, BETWEEN LBL 25 - 45. R & R PANEL ASSEMBLY IAW DWG & SRM.SDR SWAA2015101544949Panel · crackedPANEL BREAK ASSEMBLY CRACKED AT BS 540, BETWEEN LBL 45 - 65. R & R PANEL ASSEMBLY IAW DWG & SRM.SDR SWAA2015101544931Support Bracket · corrodedRIGHT WING REAR SPAR HYD SUPPORT BRACKET, CORRODED AT RSS 186.90. R & R BRACKET IAW SRM & DWG.SDR SWAA2015101544952Panel · crackedPANEL BREAK ASSEMBLY CRACKED AT BS 540, BETWEEN BL 0 TO RBL 25. R & R PANEL ASSEMBLY IAW DWG & SRM.SDR SWAA2015101544951Panel · crackedPANEL BREAK ASSEMBLY CRACKED AT BS 540, BETWEEN BL 0 TO LBL 25. R & R PANEL ASSEMBLY IAW DWG & SRM.SDR SWAA2015101444904Door Sill · corrodedAFT ENTRY DOOR INNER CHORD MOPSILL, CORRODED BETWEEN BS - BS 1006. R & R CHORD IAW SRM & DWG.SDR SWAA0811100144721Strap · crackedE & E COMPARTMENT FLOORBEAM STEP CRACKED AT BS 312, RBL 45. R & R STRAP IAW SRM.SDR SWAA2015100844720Strap · crackedE & E COMPARTMENT FLOORBEAM STRAP CRACKED AT BS 312, BL 0. R & R STRAP IAW DWG & SRM.SDR SWAA2015100744667Stringer Clip · corrodedSTRINGER CLIP CORRODED, AT BS 787, STRINGER 26L. R & R CLIP IAW SRM.SDR SWAA2015100144451Power Supply · brokenLEFT CTR EMER BATTERY PACK, FWD MOUNTING SCREW, INSERT BROKEN. R & R POWER SUPPLY IAW AMM.SDR SWAA2015100144450Cable · misroutedR2 DOOR EMER EVAC SLIDE CABLE MISROUTED. RE-ROUTED CABLE IAW AMM.SDR SWAA2015112346318Skin · delaminatedLEFT WING INBD FORE FLAP, UPPER SURFACE DELAMINATED AT INBD OF OTBD END. REPAIRED FORE FLAP IAW WO.SDR SWAA2015111946233Crossbeam · crackedAFT CARGO DOOR E BEAM CRACKED AT THE AFT END. REPAIRED CROSSBEAM E IAW EA.SDR SWAA2015111946232Crossbeam · crackedAFT CARGO DOOR E BEAM CRACKED AT THE FWD END. REPAIRED CROSSBEAM E IAW EA.SDR SWAA2015111346049Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED IN UPPER INBD FASTENER HOLE, COMMON TO MLG BEAM AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015111246008Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED IN UPPER INBD FASTENER HOLE COMMON TO MLG BEAM AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015110945871Scuff Plate · crackedAFT CARGO COMPARTMENT FWD CORNER SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW SRM & EA.SDR SWAA2015110245549Skin · crackedE & E COMPARTMENT DOOR SKIN CUT OUT CRACKED AT BS 378, BL 0. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4