N975AX, cancelled May 22, 2017
Service difficulty reports · 96
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N975AX' AND deregistration_id = 'N975AX-2017-05-22' 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 n_number = 'N975AX' AND deregistration_id = 'N975AX-2017-05-22' 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 ABXA9700363Fitting · corrodedDURING C-CHECK, THE AFT JACK PAD ATTACH FITTING WAS FOUND CORRODED. THE FITTING WAS REPLACED IAW DC-9 SRM 51-30-2.SDR ABXA9700359Frame · crackedDURING C-CHECK, WHILE ACCOMPLISHING AD 78-07-05, THE MAIN FRAME AT STA 737 LEFT WAS FOUND CRACKED. THE FRAME WAS REPAIRED IAW S/B 53-131 AND REA D953-17522-MR.SDR ABXA9700357Seat Track · corrodedDURING C-CHECK, THE SEAT TRACK AT STA 195RBL 44, WAS FOUND CORRODED. THE SEAT TRACK WAS REPAIRED IAW REA D953-17543-DE AND THE DC9 SRM. 51-30-1.SDR ABXA9700422Carriage · wornDURING C-CHECK, THE FLAP CARRIAGE ROLLERS WERE FOUND WORN. THE CARRIAGE WAS REPLACED IAW DC9 SUP MM 27-51-5.SDR ABXA9700381Frame · crackedDURING C-CHECK, WHILE ACCOMPLISHING AD 78-07-05, THE FUSELAGE MAIN FRAME AT STA 737LT WAS FOUND CRACKED. THE FRAME WAS REPAIRED IAW REA D953-17522-MR AND S/B 53-131.SDR ABXA9700380Angle · crackedDURING C-CHECK, THE LOWER PYLON TO FUSELAGE ATTACH ANGLE WAS FOUND CRACKED. THE ANGLE WAS REPAIRED IAW DC9 SRM 54-04, FIG.10.SDR ABXA9700377Angle · crackedDURING C CHECK, THE LOWER PYLON TO FUSELAGE ATTACH ANGLE WAS FOUND CRACKED. THE ANGLE WAS REPAIRED IAW DC-9 SSRM DRAWING NR K-05683.SDR ABXA9700368Doubler · crackedDURING C-CHECK, THE FUSELAGE SKIN DOUBLER AT THE MAIN ENTRY DOOR WAS FOUND CRACKED. THE DOUBLER WAS REPLACED IAW DC-9 SRM 51-30-5.SDR ABXA9700365Damper Crank · corrodedDURING C-CHECK, THE AILERON DAMPER CRANK WAS FOUND CORRODED. THE DAMPER WAS REPLACED IAW DC-9 MM 27-10-4.SDR ABXA9700364Vane · delaminatedDURING C-CHECK, THE FLAP AFT MOVEABLE VANE WAS FOUND DELAMINATED. THE VANE WAS REPLACED IAW DC-9 MM 27-51-2.SDR ABXA9700361Vane · corrodedDURING C-CHECK, THE FLAP FORWARD MOVEABLE VANE WAS FOUND CORRODED. THE VANE WAS REPLACED IAW DC-9 MM 27-51-1.SDR ABXA9700360Doubler · crackedDURING C-CHECK, THE ENGINE PYLON BULKHEAD DOUBLER WAS FOUND CRACKED. THE DOUBLER WAS REPLACED IAW DC-9 SRM 51-30-5.SDR ABXA9700356Frame · crackedDURING C-CHECK, WHILE ACCOMPLISHING AD 78-07-05, THE MAIN FRAME AT STA 737 RT, WAS FOUND CRACKED. THE FRAME WAS REPAIRED IAW REA DC953-17522-MR.SDR ABXA9700355Frame · crackedDURING C-CHECK, WHILE ACCOMPLISHING AD 78-07-05, THE MAIN FRAME AT STA 737 LT WAS FOUND CRACKED. THE FRAME WAS REPAIRED IAW REA DC953-17522-MR.SDR ABXA9700354Angle · crackedDURING C CHECK, THE LOWER PYLON TO FUSELAGE ATTACH ANGLE WAS FOUND CRACKED. THE ANGLE WAS REPAIRED IAW DC9 SRM 54-04, FIG.10.SDR ABXA9700676Vane · corrodedTHE RIGHT WING FORWARD FLAP VANE WAS CORRODED ALONG THE TRAILING EDGE. REPLACED ALL HONEYCOMB CORE, DOUBLERS AND SKINS IAW DC-9 SRM.SDR ABXA9700674Vane · delaminatedTHE RIGHT AFT FLAP VANE HAD LARGE AREA'S OF DELAMINATION ON BOTH THE UPPER AND LOWER TRAILING EDGE. REPLACED ALL HONEYCOMB CORE, DOUBLERS AND SKINS IAW DC9 SRM.SDR ABXA9700378Cowl Frame · gougedDURING C-CHECK, THE UPPER COWL INBOARD LONGERON FRAME WAS FOUND GOUGED. THE COWL WAS REPAIRED IAW ABX DWG K05013.SDR ABXA9700375Angle · crackedDURING C-CHECK, THE PYLON UPPER FUSELAGE ATTACH ANGLE AT STA 1072, WAS FOUND CRACKED. THE ANGLE WAS REPAIRED IAW DC-9 SRM 54-04, FIG.10.SDR ABXA9700374Tr Fairing · crackedDURING C-CHECK, THE LOWER THRUST REVERSER BUCKET FAIRING WAS FOUND CRACKED. THE FAIRING WAS REPLACED IAW DC-9 SRM 51-30-2.SDR ABXA9700373Angle · crackedDURING C-CHECK, THE PYLON UPPER SPAR CAP ANGLE AT THE OUTBOARD END WAS FOUND CRACKED. THE ANGLE WAS REPLACED IAW REA D954-17521.SDR ABXA9700370Angle · crackedDURING C CHECK, THE SEAT TRACK ATTACH ANGLE AT STA 1041 LONG 27 LT, WAS FOUND CRACKED. THE ANGLE WAS REPLACED IAW DC-9 SRM 51-30-1 AND 51-30-5.SDR ABXA9700358Angle · crackedDURING C-CHECK, THE VENTRAL STAIR RIGHT HINGE ATTACH ANGLE WAS FOUND CRACKED. THE ANGLE WAS REPLACED IAW DC9 SRM 51-10-4.SDR ABXA9700372Tr Fairing · crackedDURING C-CHECK, THE UPPER THRUST REVERSER BUCKET FAIRING WAS FOUND CRACKED. THE FAIRING WAS REPLACED IAW DC-9 SRM 51-30-2.SDR ABXA9700371Carriage · wornDURING C-CHECK, THE FLAP CARRIAGE ASSEMBLY WAS FOUND WORN. THE CARRIAGE ASSEMBLY WAS REPLACED IAW DC-9 SUP MM 27-51-5.SDR ABXA9700369Guide Rail · gougedDURING C-CHECK, THE GUIDE RAIL AT STA 218 LBL 45, WAS FOUND GOUGED. THE GUIDE RAIL WAS REPLACED IAW DC-9 SRM.SDR ABXA9700366Tab · wornDURING C-CHECK, THE AILERON TRIM TAB INBOARD HINGE WAS FOUND WORN. THE TRIM TAB WAS REPLACED IAW DC-9 MM 27-10-5.SDR ABXA9700362Seat Track · corrodedDURING C CHECK, THE SEAT TRACK AT STA 190 RBL 22 WAS FOUND CORRODED. THE TRACK WAS REPAIRED IAW DC-9 SRM 53-05, FIG. 4A.SDR ABXA9700367Depressor · crackedDURING C-CHECK, THE MAIN LANDING GEAR OUTBOARD DOOR SEAL DEPRESSOR WAS FOUND CRACKED. THE DEPRESSOR WAS REPLACED IAW DC-9 SRM 51-30-2.SDR ABXA9600587Bearing · wornDURING COMPLIANCE OF AD 91-22-07, ASB 32-244, FOUND RIGHT MAIN LANDING GEAR DOOR ROD ASSEMBLY BEARING WORN. REPLACED BEARING IAW DC-9 OVERHAUL MANUAL 32-10-6.SDR ABXA9600536Bearing · wornDURING COMPLIANCE OF AD 91-22-07, ASB 32-244, FOUND THE LEFT MAIN LANDING GEAR DOOR ROD ASSEMBLY BEARING WORN AT WELL ON OUTBOARD MAIN LANDING GEAR DOOR. REPLACED BEARING IAW DC-9 OVERHAUL MANUAL 32-10-6.SDR ABXA9500888Air Distr · odorORD - AFTER TAKEOFF, CREW REPORTED A STRONG RUBBER ODOR. INSPECTED TIRES, NOSE BRAKES AND ENGINE INLETS, FOUND NO DEFECTS.SDR ABXA950684Sliding Window · out of adjustDURING POST FLIGHT INSPECTION, FOUND FIRST OFFICER'S SLIDING WINDOW WOULD NOT OPEN. CLEANED TRACK, REPOSITIONED OPERATING ASSEMBLY AT TOP OF WINDOW AND LUBRICATED. OPS CHECKED GOOD IAW DC-9 MM.SDR ABXA9500671Eel Power Supply · defectiveDURING SERVICE CHECK, EMERGENCY LIGHTS STAYED ON WHEN SWITCH PLACED IN OFF POSITION. REPLACED EMERGENCY EXIT LIGHT SUPPLY IAW DC-9 SUPP MM 33-54-0. OPS CHECKED GOOD.SDR ABXA9500669Le Skin · dentedDURING C - CHECK INSPECTION, FOUND DENT IN THE LEADING EDGE OF THE NR 3 SLAT ON THE LEFT WING. REPAIRED IAW DC-9 SRM 57-03, FIG. 14A.SDR ABXA9500664Angle · crackedDURING C - CHECK INSPECTION, FOUND LEFT FLAP ATTACH ANGLE FOR OUTBOARD HINGE CRACKED INSIDE THE FLAP. REPLACED ANGLE IAW DC-9 SRM 51-30-2 AND 51-30-5.SDR ABXA9500663Angle · crackedDURING C - CHECK INSPECTION, FOUND LEFT FLAP ATTACH ANGLE FOR OUTBOARD HINGE CRACKED INSIDE THE FLAP. REPLACED ANGLE IAW DC-9 SRM 51-30-2 AND 51-30-5.SDR ABXA9500668Le Skin · dentedDURING C - CHECK INSPECTION, FOUND DENT IN LEADING EDGE OF THE NR 1 SLAT ON THE LEFT WING. REPAIRED IAW DC-9 SRM 57-03, FIG. 14A.SDR ABXA9500667Fitting · crackedDURING C - CHECK INSPECTION, FOUND RIGHT WING SLAT ACTUATING MECHANISM INBOARD ATTACH FITTING CRACKED. REPLACED FITTING IAW DC-9 SRM 51-30-1 AND 51-30-5.SDR ABXA9500666Bolt · wornDURING C - CHECK INSPECTION AND COMPLIANCE OF A.D. 91-22-07; A.S.B. 32-244, FOUND LEFT OUTBOARD MAIN LANDING GEAR DOOR ARM ASSEMBLY HAD EXCESSIVE PLAY. REPLACED BOLT IAW DC-9 OVERHAUL MANUAL 32-10-6.SDR ABXA9500665Fitting · wornDURING C - CHECK INSPECTION AND COMPLIANCE OF A.D. 91-22-07; A.S.B. 32-244, FOUND LEFT OUTBOARD MAIN LANDING GEAR DOOR LINK ASSEMBLY HAD EXCESSIVE PLAY. REPLACED FITTING IAW DC-9 OVERHAUL MANUAL 32-10-6.SDR ABXA9500383Eel Battery · dischargedEMERGENCY LIGHTS VERY DIM. REPLACED THE EMERGENCY LIGHT BATTERIES IAW DC-9 MM CHAPTER 33. OPS CHECKED GOOD.SDR ABXA9500315Angle · crackedDURING COMPLIANCE OF CORROSION TASK 80-54300, FOUND THE NR 2 ENGINE LOWER PYLON TO FUSELAGE ATTACH ANGLE CRACKED. REPAIRED IAW ABX REA D954-11280-MR.SDR ABXA9500314Angle · crackedDURING COMPLIANCE OF CORROSION TASK 80-54300, FOUND THE NR 2 ENGINE UPPER PYLON TO FUSELAGE ATTACH ANGLE CRACKED. REPAIRED IAW ABX REA D954-112080-MR.SDR ABXA9500313Angle · crackedDURING COMPLIANCE OF CORROSION TASK 80-54300, FOUND THE NR 1 ENGINE LOWER PYLON TO FUSELAGE ATTACH ANGLE CRACKED. REPAIRED IAW ABX REA D954-11280-MR.SDR ABXA9500312Angle · crackedDURING COMPLIANCE OF CORROSION TASK 80-54300, FOUND NR 1 ENGINE UPPER PYLON TO FUSELAGE ATTACH ANGLE TO BE CRACKED. REPAIRED IAW ABX REA D954-11280-MR.
Back to N975AX, cancelled May 22, 2017