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 SWAA2015092944365Slat · corrodedRIGHT WING NR 4 LE SLAT OTBD MAIN SLAT TRACK, CORRODED ON BOTTOM SIDE. R & R SLAT IAW CHM.SDR SWAA2015092444241Lens · damagedFORWARD GALLEY EXIT LIGHT LENS DAMAGED. R & R LENS IAW AMM.SDR SWAA2015092444240Door Frame · crackedC1 DOOR CUT OUT FWD SIDE, FRAME CRACKED IN FRAME WEB AT NR 5 DOOR STOP FITTING AT LOWER OTBD CORNER OF AREA. R & R FRAME IAW ACO, SRM & DWG.SDR SWAA2015092344212Spar · crackedLEFT WING REAR SPAR UPPER CHORD, CRACKED AT RSS 221. REPAIRED CHORD IAW EA.SDR SWAA2015091844043Shear Web · crackedSHEAR WEB CRACKED, BETWEEN BS 351.2 - 348.2, BETWEEN STRINGER 15L - 17L. R & R SHEAR WEB IAW SRM & DWG.SDR SWAA2015091743988Crease Beam · corrodedRIGHT CREASE BEAM INBD CHORD CORRODED, BETWEEN BS 985 - 995, RBL 46. R & R CHORD IAW SRM & DWG.SDR SWAA2015091443854Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 847 - 867. R & R WEB IAW SRM & DWG.SDR SWAA2015091043585Skin · crackedFUSELAGE SKIN CRACKED AT BS 803, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015090943532Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 2L. R & R STRINGER SPLICE IAW EA & AMM.SDR SWAA2015090243452Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 867 - 887. R & R WEB IAW DWG & SRM.SDR SWAA2015090243442Skin · crackedFUSELAGE SKIN CRACKED AT BS 804, STRINGER 1L. REPAIRED SKIN IAW SRM.SDR SWAA2015090143415Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 827 - 847. R & R WEB IAW SRM & DWG.SDR SWAA2015082743255Bulkhead · crackedBULKHEAD VERTICAL BEAM WEB CRACKED AT BS 178, LBL 17. REPAIRED WEB IAW SRM.SDR SWAA2015082042999Attach Angle · crackedL1 DOOR CUTOUT, LOWER AFT CORNER, DOOR TRIM TO SKIN ATTACH ANGLE CRACKED. REPAIRED ANGLE IAW DWG.SDR SWAA2015081942957Light · inoperativeL1 DOOR EMER LIGHT BULB AFT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015081742862Cover · unsecureFORWARD EMER EXIT LIGHT COVER FELL OFF. REINSTALLED COVER IAW SIP.SDR SWAA2015092244176Skin · crackedFORWARD LOWER CORNER OF AFT GALLEY DOOR CUT OUT CRACKED. REPAIRED CUT OUT IAW SRM.SDR SWAA2015092244163Rib · crackedRIGHT WING RIB LOWER CHORD CRACKED, AT WBL 135.5, BETWEEN STRINGER 2 - 3. REPAIRED CHORD IAW EA.SDR SWAA2015092144110Carriage · corrodedRIGHT WING OTBD MAIN FLAP, NR 8 CARRIAGE FASTENER HOLES FOR A FRAME MOUNTING CORRODED. R & R CARRIAGE IAW CMM.SDR SWAA2015091643955Attach Fitting · crackedL1 DOOR SURROUND STRUCTURE, ATTACH CLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2015091043646Shear Tie · corrodedL1 DOOR CUT OUT AROUND FASTENER SHEAR TIE CORRODED AT BS 302, STRINGER 14L. R & R CLIP IAW SRM & DWG.SDR SWAA2015082643234Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 787, STRINGER 25R. R & R CLIP IAW SRM & DWG.SDR SWAA2015082543179Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 787, STRINGER 24R. R & R STRINGER CLIP IAW SRM & DWG.SDR SWAA2015082543178Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 787, STRINGER 24L. R & R STRINGER CLIP IAW SRM & DWG.SDR SWAA2015092444247Support Fitting · crackedRIGHT WING REAR SPAR MLG FWD SUPPORT FITTING, CRACKED AT FASTENER HOLE RSS 220, UPPER ROW AT UPPER SPAR CHORD. REPAIRED FITTING ER & EA.SDR SWAA2015092444246Spar · crackedRIGHT WING REAR SPAR WEB AT UPPER CHORD CRACKED AT FASTENER HOLE RSS 222. REPAIRED CHORD IAW EA.SDR SWAA2015091743987Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500B, BETWEEN BL 0 TO LBL 6. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015091743986Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500A, BETWEEN RBL 5 TO LBL 3. R & R SHEAR TIE IAW SRM.SDR SWAA2015091443762Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500C, STRINGER 24R. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2015090143414Beam · crackedLONGITUDINAL BEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED CHORD IAW EA & ER.SDR SWAA2015081742892Sign · unsecureRIGHT OVERWING EMER EXIT ROW SIGN FELL OFF. SECURED SIGN IAW AMM.SDR SWAA2015081342792Strap · crackedLOWER FLOORBEAM STRAP CRACKED AT BS 342, RBL 60. REPAIRED STRAP IAW SRM.SDR SWAA2015081242771Light · inoperativeLEFT EMER LIGHT INOPERATIVE AT ROW 22. RELAMPED LIGHT IAW AMM.SDR SWAA2015081242766Flap · delaminatedRIGHT WING INBD AFT FLAP DELAMINATED 4" ON TRAILING EDGE. R & R AFT FLAP IAW AMM.SDR SWAA2015102745391Tip Cap · delaminatedRIGHT HORIZONTAL STABILIZER TIP DELAMINATED AT LE. REPAIRED TIP IAW AMM.SDR SWAA2015102345272Structure · crackedRIGHT WING EXTERIOR REAR SPAR, UPPER CHORD CRACKED AT WING STATION RSS 222.14. REPAIRED CHORD IAW EA.SDR SWAA2015102345271Structure · crackedLEFT WING EXTERIOR REAR SPAR UPPER CHORD, CRACKED AT WING STATION RSS 222.14. REPAIRED CHORD IAW EA.SDR SWAA2015092944364Support Fitting · corrodedRIGHT WING NR 7 FLAP TRACK AFT SUPPORT FITTING CORRODED. REPAIRED FITTING IAW SRM.SDR SWAA2015092444245Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT FASTENER HOLE RSS 222. REPAIRED WEB IAW ER & EA.SDR SWAA2015092444244Support Fitting · crackedLEFT WING REAR SPAR, MLG AFT SUPPORT FITTING CRACKED AT INBD HOLE, RSS 222. REPAIRED FITTING ER & EA.SDR SWAA2015092344222Stringer · corrodedSTRINGER CORRODED AT BS 996, STRINGER 21R. REPAIRED STRINGER IAW ER & EA.SDR SWAA2015092344220Support Fitting · corrodedRIGHT WING NR 8 FLAP, AFT TRACK SUPPORT FITTING CORRODED AT OTBD BOLT HOLE, UPPER SURFACE. R & R FITTING IAW SRM & DWG.SDR SWAA2015092144108Frame · crackedFORWARD CARGO COMPARTMENT, FRAME CRACKED AT BS 500B, STRINGER 20R. REPAIRED FRAME IAW SRM.SDR SWAA2015092144107Attach Fitting · corrodedLEFT WING NR 1 FLAP TRACK, AFT OTBD ATTACH FITTING CORRODED ON UPPER SURFACE. R & R FITTING IAW SRM & DWG.SDR SWAA2015090343480Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 847 - 867. R & R WEB IAW SRM & DWG.SDR SWAA2015081842925Frame · crackedFORWARD CARGO, AFT CARGO FRAME OTBD FLANGE, UPPER RADIUS FILLER CRACKED. REPAIRED FLANGE IAW SRM & DWG.SDR SWAA2015081842924Strap · crackedFORWARD CARGO, AFT CARGO FRAME INNER FLANGE STRAP CRACKED. R & R STRAP IAW SRM & DWG.SDR SWAA2015081242755Glowstrip · loosePHOTO LUMINESCENT STRIP LOOSE BETWEEN ROW 8 TO ROW 9. SECURED STRIP IAW MM.SDR SWAA2015101244821Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD CRACKED AT MLG SUPPORT FITTING RSS 224, UPPER INBD. REPAIRED CHORD IAW EA & ER.SDR SWAA2015092844326Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947, BETWEEN STRINGER 25R - 26R. R & R SHEAR TIE IAW SRM & DWG.
Back to Boeing 737-3H4