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 SWAA2014121635058Floor Support · crackedLONGITUDINAL BEAM UPPER CHORD CRACKED AT BS 671.25, RBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2014120834733Duct · faultyDIVERSION, DECLARED EMER, SMELL OF SMOKE IN CABIN AT OVERWING EXITS. FOUND RT PACK CONDITIONED AIR DUCT BROKEN. R & R RT PACK CONDITIONED AIR DUCT ASSEMBLY IAW MM.SDR SWAA2014120834790Lens · looseL1 DOOR LOWER EMER EXIT LIGHT COVER LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2014123035348Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 727B+10, LOWER FWD WINDOW CORNER. REPAIRED SKIN IAW EA.SDR SWAA2014123035347Skin · crackedLEFT FUSELAGE SKIN CRACKED AT STATION 887+10, UPPER AFT WINDOW CORNER. REPAIRED SKIN IAW EA.SDR SWAA2014123035346Skin · crackedLEFT FUSELAGE SKIN CRACKED AT STATION 767+10, UPPER AFT WINDOW CORNER. REPAIRED SKIN IAW EA.SDR SWAA2014123035345Skin · crackedLEFT FUSELAGE SKIN CRACKED AT STATION 727C+10, UPPER AFT WINDOW CORNER. REPAIRED SKIN IAW EA.SDR SWAA2014123035344Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 887+10, UPPER AFT WINDOW CORNER. REPAIRED SKIN IAW EA.SDR SWAA2014123035343Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 727E+10, LOWER FWD WINDOW CORNER. REPAIRED SKIN IAW EA.SDR SWAA2014122335250Skin · crackedLEFT FUSELAGE SKIN CRACKED AT STATION 867+10, LOWER FWD WINDOW CUT OUT. REPAIRED SKIN IAW SB.SDR SWAA2014122335242Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 807+10, LOWER FWD WINDOW CUT OUT. REPAIRED SKIN IAW SB.SDR SWAA2014122335241Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 767+10, LOWER FWD WINDOW CUT OUT. REPAIRED SKIN IAW SB.SDR SWAA2014121935170Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 847+10, UPPER AFT WINDOW CUT OUT CORNER. REPAIRED SKIN IAW SB.SDR SWAA2014121935166Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 827+10, LOWER FWD WINDOW CUT OUT CORNER. REPAIRED SKIN IAW SB.SDR SWAA2014120834773Lens · looseFORWARD ENTRY EXIT SIGN LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2014121134938Flap Track · corrodedLEFT NR 4 FLAP TRACK LOWER FLANGE CORRODED AT LOCATION X12. REPAIRED FLANGE IAW CMM.SDR SWAA2014121134937Flap Track · corrodedLEFT WING NR 4 FLAP TRACK LOWER FLANGE CORRODED AT LOCATION X4. REPAIRED FLANGE IAW CMM.SDR SWAA2014121134936Flap Track · corrodedLEFT WING NR 4 FLAP TRACK CORRODED ON LOWER FLANGE LOCATION X-13. REPAIRED FLANGE IAW CMM.SDR SWAA2014121134935Flap Track · corrodedLEFT WING NR 4 FLAP TRACK UPPER FLANGE CORRODED AT LOCATION X14. REPAIRED FLANGE IAW CMM.SDR SWAA2014121134921Flap Track · corrodedLEFT WING NR 4 FLAP TRACK UPPER FLANGE CORRODED AT LOCATION X-13. REPAIRED FLANGE IAW CMM.SDR SWAA2014120834789Light · brokenFORWARD ENTRY EMER EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014120834772Casting · crackedLEFT WING INBD NR 4 GND SPOILER HINGE BOLT CASTING CRACKED. R & R NR 4 SPOILER IAW AMM.SDR SWAA2014121935158Skin · delaminatedLEFT WING INBD TE FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FLAP IAW SRM.SDR SWAA2014121535018Lens · brokenFORWARD LAVATORY WALL EMER EXIT SIGN LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014120534712Lens · missingLEFT EMER EXIT BULLNOSE LIGHT LENS MISSING AT ROW 6. INSTALLED LENS IAW AMM.SDR SWAA2014120434689Cover · looseFORWARD EXIT SIGN COVER LOOSE. SECURED SIGN COVER IAW MM.SDR SWAA2014120434674Charger · inoperativeAFT EMER LIGHT FAULTY AT BS 727+17, WL 213. R & R BATTERY CHARGER IAW MM.SDR SWAA2014121635045Flap Track · corrodedRIGHT WING NR 5 FLAP TRACK CORRODED ON AFT INBD HOLE. REPAIRED FLAP TRACK IAW CMM.SDR SWAA2014121134917Tie Clip · crackedTIE CLIP CRACKED AT BS 1121, STRINGER 2R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014120434667Sign · looseR1 DOOR SIDEWALL EXIT SIGN LIGHT ASSEMBLY LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014120434651Battery · dischargedEMERGENCY EXIT LIGHTS FAULTY. R & R BATTERY IAW MM.SDR SWAA2015010535469Doubler · crackedFUSELAGE INTERNAL SKIN DOUBLER CRACKED AT STATION 227.8 TO 235.8, WL 207. 5 RT SIDE. REPAIRED SKIN IAW EA.SDR SWAA2014120834768Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 277 TO 294.5, STRINGER 13R. R &R ANGLE IAW SRM & DWG.SDR SWAA2014120334609Spoiler · crackedLEFT WING INBD NR 4 GND SPOILER CRACKED. R & R SPOILER IAW AMM.SDR SWAA2015010235441Seat Track · corrodedSEAT TRACK CORRODED AT STATION 332, RBL 21. REPAIRED SEAT TRACK IAW SB & EA.SDR SWAA2014123035328Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 986.5, RBL 6 TO 45. REPAIRED FLOORBEAM IAW EA.SDR SWAA2014123035318Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 986.5, RBL 6 TO LBL 6. REPAIRED BEAM IAW EA.SDR SWAA2014121935177Angle · corrodedCORROSION ON Z ANGLE AT STATION 277 TO 360, STRINGER 17L FLOOR AREA FWD CABIN. R & R ANGLE IAW SRM.SDR SWAA2014121535017Angle · crackedVERTICAL ANGLE CRACKED AT BS 328, LBL 45. R & R ANGLE IAW SRM & DWG.SDR SWAA2014121134920Fitting · crackedFORWARD GALLEY DOOR CUT OUT FITTING CRACKED AT BS 337.6, STRINGER 8R. R & R FITTING IAW SRM & DWG.SDR SWAA2014120934847Support Bracket · crackedLEFT WING MID FLAP OTBD SUPPORT BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2014120834767Floorbeam · corrodedFLOORBEAM CORRODED AT BS 312, BETWEEN LBL 8 TO RBL 8. REPAIRED BEAM IAW SRM.SDR SWAA2014120134568Retaining Clip · brokenFORWARD ENTRY EMER EXIT LIGHT COVER RETAINING CLIPS BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014121735104Support Angle · crackedRIGHT WING FIXED TE SUPPORT ANGLE CRACKED AT RSS 533+12. R & R ANGLE IAW SRM & DWG.SDR SWAA2014121535016Support Angle · crackedAFT CARGO COMPARTMENT SUPPORT ANGLE CRACKED BETWEEN BS 727D TO 727E, BETWEEN STRINGER 27R TO 27L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014121234951Fitting · wornL1 DOOR EMER EVAC SLIDE GIRT BAR FITTING SHIMS WORN. R & R FITTING ASSEMBLY IAW AMM.SDR SWAA2014121234950Support Angle · crackedLEFT WING TE SUPPORT ANGLE CRACKED AT WBL 71.24. R & R ANGLE IAW SRM & DWG.SDR SWAA2014121234944Fitting · wornR1 DOOR EMER EVAC SLIDE GIRT BAR FITTING SHIMS WORN. R & R FITTING ASSEMBLY IAW AMM.SDR SWAA2014120334610Angle · crackedRIGHT WING FIXED TE ANGLE CRACKED AT RSS 533+12. R & R ANGLE IAW SRM & DWG.SDR SWAA2014120234588Support Angle · crackedLEFT WING SUPPORT ANGLE CRACKED AT TE INTERNAL CAVITY AT LEVEL WS 531. R & R ANGLE IAW SRM & DWG.
Back to Boeing 737-3H4