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 SWAA2016030249593Skin · crackedLEFT WING UPPER SKIN HOLE CRACKED AT RSS 268, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030249592Skin · crackedLEFT WING UPPER SKIN HOLE CRACKED, AT RSS 230.34, AFT ROW. REPAIRED SKIN IAW EA.SDR SWAA2016030249591Skin · crackedLEFT WING UPPER SKIN HOLE CRACKED, AT RSS 248.875, 4TH ROW FROM AFT, 4.75" FROM TE. REPAIRED SKIN IAW EA.SDR SWAA2015123047507Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 837 - 907. REPAIRED BEAM IAW SRM.SDR SWAA2015102645318Skin · crackedSKIN CRACKED AT BS 912, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2015102345281Attach Angle · damagedL1 DOOR EMER EVAC SLIDE GIRT BAR ATTACHMENT ANGLE DAMAGED. R & R ANGLE IAW SRM.SDR SWAA2015102245244Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2015102145180Charger · inoperativeRIGHT OVERWING EMER EXIT SIGN INOPERATIVE. R & R BATTERY CHARGER IAW AMM.SDR SWAA2015102145179Light · inoperativeLEFT OVERWING EMER EXIT AISLE LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SWAA2015122347379Skin · delaminatedRIGHT WING TE INBD FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP IAW SRM.SDR SWAA2015121447073Angle · crackedINTERCOSTAL L ANGLE SUPPORT CRACKED, BETWEEN BS 277 - 291, BETWEEN STRINGER 12R - 13R. R & R L ANGLE IAW EA.SDR SWAA2015121147026Stringer Clip · crackedSTRINGER CLIP CRACKED, AT BS 277, STRINGER 10R. R & R CLIP IAW IAW EA.SDR SWAA2015121147025Support · crackedINTERCOSTAL ANGLE SUPPORT CRACKED, BETWEEN BS 277 - 291, STRINGER 1R. R & R SUPPORT IAW EA.SDR SWAA2015121147024Support · crackedINTERCOSTAL ANGLE SUPPORT CRACKED, BETWEEN BS 277 - 291, BETWEEN STRINGER 11R - 12R. R & R SUPPORT IAW EA.SDR SWAA2015113046519Spar · crackedLEFT WING TE UPPER SPAR CHORD CRACKED AT RSS 222.2. REPAIRED CHORD IAW EA.SDR SWAA2015112346291Spar · crackedRIGHT WING TE UPPER SPAR CHORD, CRACKED AT RSS 222.2. REPAIRED CHORD IAW EA.SDR SWAA2015102045174Lens · crackedFORWARD EMER EXIT LIGHT LENS CRACKED. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015110245674Fitting · corrodedLEFT WING MLG STABILIZER ASSEMBLY, TE FWD FITTING CORRODED. R & R FITTING IAW SRM & AMM.SDR SWAA2015110245597Attach Fitting · corrodedLEFT MLG STABILIZER BEAM ATTACH OTBD FITTING CORRODED. R & R FITTING IAW DWG & SRM.SDR SWAA2015110245644Seat Track · corrodedSEAT TRACK WEB CORRODED, BETWEEN BS 500D TO 520, RBL 24.75 AT UPPER FASTENER ROW. R & R WEB IAW SRM & DWG.SDR SWAA2015110245599Light · brokenRIGHT SIDEWALL EXIT LIGHT BROKEN AT ROW 9. R & R LIGHT IAW AMM.SDR SWAA2015102045144Fitting · crackedRIGHT WING NR 6 FLAP TRACK FAIRING SIDEWALL FITTING CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2015102045080Wedge · delaminatedRIGHT WING, NR 5 SLAT WEDGE DELAMINATED ON INBD END. REPAIRED WEDGE IAW DWG.SDR SWAA0156120147191Web · crackedLEFT WING WEB CRACKED AT RSS 224.14, OTBD FIRST UPPER OPEN HOLE. REPAIRED WEB IAW EA.SDR SWAA2015121647190Structure · crackedRIGHT WING CRACK FOUND IN THE CHORD INBD OF RSS 224.14, FIRST UPPER ROW OPEN FASTENER HOLE & SECOND LOWER ROW OPEN FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2015120547150Structure · crackedLEFT WING UPPER CHORD CRACKED INBD OF RSS 224.14 FIRST TWO OPEN FASTENER HOLES. REPAIRED CHORD IAW EA.SDR SWAA2015113046517Fitting · crackedRIGHT WING FITTING CRACKED OTBD OF RSS 224.14, IN THE FIRST THREE UPPER ROW OPEN FASTENER HOLES. R & R FITTING IAW EA.SDR SWAA2015113046516Fitting · crackedLEFT WING FITTING CRACKED, FOUND ON AT RSS 224.14, OTBD FIRST BOTTOM FASTENER HOLE. R & R FITTING IAW EA.SDR SWAA2015101945076Shear Tie · corrodedSHEAR TIE, CORRODED AT BS 947.5, BETWEEN STRINGER 24L - 26L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015120846875Structure · crackedLEFT WING CHORD CRACKED, ON UPPER CHORD AT REAR SPAR FIRST FASTENER INBD & OTBD OF RSS 224.14. REPAIRED CHORD IAW EA.SDR SWAA2015120846874Spar · crackedLEFT WING REAR SPAR WEB, CRACKED AT REAR SPAR, SECOND FASTENER INBD OF RSS 224.14. REPAIRED WEB IAW EA.SDR SWAA2015112346345Beam · crackedSTUB BEAM LOWER CHORD CRACKED AT BS 639 RT FASTENER HOLE. R & R CHORD IAW SRM.SDR SWAA2015112346344Skin · crackedLEFT WING CRACKED NOTED COMMON TO WING SKIN AT TE ROW, BETWEEN RSS 213 - 295. REPAIRED SKIN IAW EA.SDR SWAA2015102045153Attach Angle · corrodedL1 DOOR GIRT BAR ATTACH ANGLE CORRODED AT BS 312, LBL 58. R & R ANGLE IAW SRM.SDR SWAA2015101645025Lens · mislocatedFORWARD ENTRY EMER EXIT BULKHEAD LIGHT LENS MISS LOCATED. R & R LENS IAW AMM.SDR SWAA2015101644991Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK M1137, VOLTAGE LOW. R & R BATTERY PACK IAW AMM.SDR SWAA2015112346343Support Fitting · crackedLEFT WING LG BEAM FWD SUPPORT FITTING, CRACKED AT UPPER SPAR CHORD, BETWEEN RSS 223 - 220, BETWEEN HOLE 5 - 8. R & R FITTING IAW ER & EA.SDR SWAA2015112346342Support Fitting · crackedLEFT WING LG BEAM AFT SUPPORT FITTING, CRACKED AT FASTENER HOLE COMMON TO UPPER FASTENER ROW TO UPPER SPAR CHORD AT RSS 223, HOLE 5. R & R FITTING IAW ER & EA.SDR SWAA2015112346341Spar · crackedLEFT WING REAR SPAR WEB CRACKED, AT FASTENER HOLE COMMON TO UPPER FASTENER ROW TO UPPER SPAR CHORD AT RSS 223, HOLE 5. REPAIRED WEB IAW ER & EA.SDR SWAA2015102045152Attach Angle · crackedL1 DOOR FRAME ATTACH ANGLE CRACKED AT BS 348.2, STRINGER 15L. R & R ANGLE IAW DWG & SRM.SDR SWAA2015101544929Light · inoperativeR2 DOOR EMER EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015101544923Light · inoperativeLEFT EMER LIGHT INOPERATIVE AT ROW 21. RELAMPED LIGHT IAW AMM.SDR SWAA2015101544922Light · inoperativeR1 DOOR EXTERNAL EMER LIGHT LAMP INOPERATIVE. RELAMPED LAMP IAW AMM.SDR SWAA2015101544917Light · inoperativeRIGHT EMER LIGHT INOPERATIVE AT ROW 23. RELAMPED LIGHT IAW AMM.SDR SWAA2015101444907Slide · out of positionL2 DOOR EMER EVAC SLIDE PRESS GAUGE OUT OF POSITION. REPOSITIONED SLIDE IAW SIP.SDR SWAA2015101444906Fuse · inoperativeRIGHT EMER LIGHT BATTERY PACK M1669 FUSE INOPERATIVE, BETWEEN ROW 12 - 16. R & R FUSE IAW AMM.SDR SWAA2015101444900Slide · out of adjustR2 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2015101444899Strap · crackedLOWER FLOORBEAM SPLICE STRAP CRACKED AT BS 328. REPAIRED STRAP IAW SRM.SDR SWAA2015101444898Cover · brokenFORWARD ENTRY EXIT LIGHT COVER BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015121147032Crease Beam · corrodedCREASE BEAM WEB CORRODED, BETWEEN BS 986.5 - 1006. R & R WEB IAW SRM & DWG.
Back to Boeing 737-3H4