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 SWAA2016011347953Support Angle · crackedFRAME SUPPORT ANGLE CRACKED AT BS 847, STRINGER 1R. R & R ANGLE IAW SRM.SDR SWAA2016011247907Attach Angle · crackedE & E BAY FWD AIRSTAIR DOOR, CUT OUT ATTACH ANGLE CRACKED AT BS 336, BETWEEN STRINGER 21L - 22L. R & R ANGLE IAW SRM.SDR SWAA2016010747743Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 907, STRINGER 9L. R & R CLIP IAW SRM.SDR SWAA2016010647683Skin · crackedLEFT WING UPPER SKIN FASTENER HOLES CRACKED, BETWEEN RSS 248 - 254. REPAIRED SKIN IAW EA.SDR SWAA2015123147550Fitting · crackedRIGHT WING CLIP CRACKED AT RSS 234. R & R CLIP IAW SRM.SDR SWAA2015121547101Skin · crackedL1 DOOR FWD SIDE, OUTER SKIN CRACKED, FROM BOTTOM ON DOOR EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2015120946888Wire Harness · faultyON CLIMB OUT, ABOUT 6 - 7K WITH POWER SET FOR CLIMB THRUST, NR 1 EGT FLUCTUATED UP TO 1018 EGT SEVERAL TIMES, THEN BACK. ENG VIB ALSO JUMPED TO ABOUT 1.8. R & R NR 1 ENG HARNESS UPPER RT IAW AMM.SDR SWAA2015120946887Stiffener · crackedMAIN LANDING GEAR WW VERTICAL STIFFENER BULKHEAD CRACKED AT BS 663, RBL 6.15. REPAIRED STIFFENER IAW EA.SDR SWAA2015120746771Lens · crackedFORWARD CTR AISLE EXIT LIGHT LENS CRACKED. R & R LENS IAW AMM.SDR SWAA2016012548334Floor Support · corrodedAFT CARGO COMPARTMENT FLOOR SUPPORT CORRODED, BETWEEN BS 867 - 847, BETWEEN STRINGER 25L - 25R. R & R SUPPORT IAW SRM.SDR SWAA2016012148223Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 847 - 867, WL 208. R & R WEB IAW SRM.SDR SWAA2016012048193Support Angle · corrodedAFT BULKHEAD SUPPORT ANGLE CORRODED, BETWEEN STRINGER 21R - 25R. R & R ANGLE IAW SRM.SDR SWAA2016011948079Structure · crackedFORWARD CARGO DOOR HANDLE FLAPPER DOOR CUT OUT CRACKED AT AFT UPPER CORNER. REPAIRED CUT OUT IAW ER & EA.SDR SWAA2016011548013Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 218, IN FASTENER HOLE COMMON TO UPPER CHORD. REPAIRED WEB IAW EA.SDR SWAA2016011548012Spar · crackedRIGHT WING REAR SPAR, WEB CRACKED AT RSS 224, UPPER FASTENER HOLE COMMON TO FWD & AFT MLG FITTINGS. REPAIRED WEB IAW EA.SDR SWAA2016011347948Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 663, STRINGER 10L. R & R CLIP IAW SRM.SDR SWAA2016011247906Support · corrodedAFT BULKHEAD LOWER SUPPORT, CORRODED AT BS 947, BETWEEN STRINGER 25R - 25L. R & R SUPPORT IAW SRM.SDR SWAA2016010747742Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500, STRINGER 8R. R & R CLIP IAW SRM.SDR SWAA2016010447632Crease Beam · corrodedLEFT CREASE BEAM CORRODED AT STATION 420 - 440. REPAIRED BEAM IAW SRM.SDR SWAA2015123147560Skin · crackedRIGHT WING UPPER SKIN TE CRACKED AT RSS 270.5. REPAIRED SKIN IAW EA.SDR SWAA2015123147559Skin · crackedRIGHT WING UPPER SKIN TE CRACKED AT RSS 251. REPAIRED SKIN IAW EA.SDR SWAA2015123147558Skin · crackedRIGHT WING UPPER SKIN TE CRACKED AT RSS 241. REPAIRED SKIN IAW EA.SDR SWAA2015122947497Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 727E, STRINGER 10R. R & R CLIP IAW SRM.SDR SWAA2015121747249Seat Track · corrodedSEAT TRACK CORRODED AT BS 696, RBL 45.5. R & R SEAT TRACK IAW SRM.SDR SWAA2015121146970Skin · crackedSKIN CRACKED AT BS 361.5, STRINGER 4R. REPAIRED SKIN IAW SRM.SDR SWAA2015120746764Sign · inoperativeFORWARD ENTRY DOOR, EMER EXIT LIGHT SIGN INOPERATIVE. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2015120746802Slide · out of adjustR2 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW AMM.SDR SWAA2016030749674Frame · crackedFORWARD E & E COMPARTMENT FRAME FAIL SAFE CHORD CRACKED AT BS 360, STRINGER 20R. REPAIRED FRAME IAW EA.SDR SWAA2016012548332Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STRINGER 28L - 28R. REPAIRED SHEAR TIE IAW ER & EA.SDR SWAA2016012548333Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STRINGER 28L - 28R. REPAIRED SHEAR TIE IAW ER & EA.SDR SWAA2016011948139Support Fitting · corrodedRIGHT WING NR 5 GND SPOILER ACTUATOR, INBD SUPPORT FITTING HINGE BORES FOR SPOILER CORRODED. R & R FITTING IAW SRM.SDR SWAA2016010647682Fitting · crackedUPPER SHEAR TIE FITTING CRACKED AT RS 179.56. R & R FITTING IAW DWG & SRM.SDR SWAA2015123047508Strap · crackedLEFT WING REAR SPAR, UPPER STRAP AT STATION 236 CRACKED. R & R STRAP IAW SRM.SDR SWAA2015122347372Skin · crackedFUSELAGE SKIN CRACKED AT BS 360, STRINGER 3 - 4R. REPAIRED SKIN IAW EA.SDR SWAA2015121447077Flap · delaminatedLEFT WING OTBD FORE FLAP DELAMINATED AT INBD SIDE TE CORNER. REPAIRED FOR FLAP IAW SRM.SDR SWAA2015120746801Casting · crackedRIGHT WING, INBD SPOILER CASTING CRACKED, AT FWD ATTACH FITTING. R & R CASTING IAW SRM.SDR SWAA2015120446718Wedge · delaminatedLEFT WING LE NR 2 SLAT, OTBD TE WEDGE DELAMINATED ON CORNER. R & R NR 2 SLAT IAW MM.SDR SWAA2016020948783Skin · crackedL1 DOOR HINGE CUT OUT CRACKED AT BS 304, WL 260. REPAIRED CUT OUT IAW SRM.SDR SWAA2016012548331Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STRINGER 2L - 3L. REPAIRED SKIN IAW ER & EA.SDR SWAA2016012548330Shear Tie · corrodedSHEAR TIE CORRODED AT BS 420, BETWEEN STRINGER 24R - 25R. R & R SHEAR TIE IAW ER & SRM.SDR SWAA2016012548329Shear Tie · corrodedSHEAR TIE CORRODED AT BS 420, BETWEEN STRINGER 24R - 25R. R & R SHEAR TIE IAW SRM.SDR SWAA2016012048207Skin · crackedL1 DOOR HINGE FASTENER HOLE CUT OUT CRACKED AT BS 304, WL 259. REPAIRED SKIN IAW SRM.SDR SWAA2016012048192Crease Beam · corrodedCREASE BEAM WEB CORRODED, BETWEEN BS 480 - 500, STRINGER 17R. R & R WEB IAW SRM.SDR SWAA2016012048206Skin · crackedL1 DOOR HINGE CUT OUT CRACKED, AT BS 304, WL 262. REPAIRED CUT OUT IAW SRM.SDR SWAA2016011948140Skin · crackedPNEUMATIC SERVICE DOOR SKIN CUT OUT CRACKED AT THE FWD LT CORNER. REPAIRED CUT OUT IAW SRM.SDR SWAA2016011948113Skin · crackedL1 DOOR HINGE CUT OUT CRACKED AT BS 303, WL 259. REPAIRED CUT OUT IAW SRM.SDR SWAA2016011948105Frame · crackedFRAME CRACKED AT BS 360, STRINGER 20R. REPAIRED FRAME IAW ER & EA.SDR SWAA2016011548030Keelbeam · corrodedFORWARD CARGO COMPARTMENT ON FWD END OF KEEL BEAM CORRODED AT BS 540, STRINGER 28L. REPAIRED BEAM IAW ER & EA.SDR SWAA2016011247916Skin · crackedLEFT WING UPPER PLANK TE SKIN CRACKED, BETWEEN RSS 229 - 254. REPAIRED SKIN IAW EA & ER.SDR SWAA2016011247914Spar · crackedLEFT WING NR 5 HOLE ONLY IN REAR SPAR RSS 222, CRACKED AT WEB. REPAIRED WEB IAW EA.
Back to Boeing 737-3H4