N929AX, cancelled Jul 20, 2017
Service difficulty reports · 71
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 = 'N929AX' AND deregistration_id = 'N929AX-2017-07-20' 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 = 'N929AX' AND deregistration_id = 'N929AX-2017-07-20' 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 ABXA9700335Support · crackedDURING C-CHECK, A FLOOR SUPPORT WAS FOUND CRACKED RBL 14 STA 205. REPAIRED IAW DC9 SRM.SDR ABXA9700334Angle · crackedDURING C-CHECK, THE RT UPPER PYLON SPAR CAP TO FRAME ATTACH ANGLE WAS FOUND CRACKED, AT STA 1038. REPAIRED IAW DC9 SRM.SDR ABXA9700333Clip · crackedDURING C-CHECK, THE RIGHT PYLON UPPER SPAR TO WEB ATTACH CLIP WAS CRACKED AT STA 1038. REPAIRED IAW DC9 SRM.SDR ABXA9700332Skin · crackedDURING C-CHECK, THE FUSELAGE SKIN WAS FOUND CRACKED AT STA 1132 LONGERON 17RT. REPAIRED IAW DC9 SRM.SDR ABXA9700331Pressure Panel · crackedDURING C-CHECK, THE UPPER PRESSURE PANEL IN THE NOSE WHEEL WELL WAS FOUND CRACKED AT STA 81. REPAIRED IAW REA D953-16856.SDR ABXA9700330Frame · crackedDURING C-CHECK, THE FUSELAGE FRAME WAS FOUND CRACKED AT STA 1074 LONGERON 13RT. REPAIRED IAW DC9 SRM.SDR ABXA9700329Clip · crackedDURING C-CHECK, THE FUSELAGE FRAME TO LONGERON ATTACH CLIP WAS CRACKED AT STA 718 LONGERON 15RT. REPLACED IAW DC9 SRM.SDR ABXA9700328Longeron · crackedDURING C-CHECK, LONGERON 17 LT AT FUS STA 937, WAS FOUND CRACKED. REPAIRED IAW DC9 SRM.SDR ABXA9700327Seat Track · crackedDURING C-CHECK, THE SEAT TRACK AT LBL 22.0 STA 163 TO 167 WAS FOUND CRACKED. REPLACED IAW DC9 SRM.SDR ABXA9700326Fitting · crackedDURING C-CHECK, THE LEFT INBOARD BONDED PANEL TO FUSELAGE ATTACH FITTING, WAS FOUND CRACKED. REPLACED IAW DC9 SRM.SDR ABXA9700325Bulkhead Ftg · crackedDURING C-CHECK, THE AFT PRESSURE BULKHEAD AFT RADICAL 16 WAS FOUND CRACKED ON THE INBOARD END. REPLACED IAW DC9 SRM.SDR ABXA9700324Door Jamb · crackedDURING C-CHECK, THE RIGHT FORWARD OVERWING EXIT DOOR JAMB PAN WAS FOUND CRACKED AT THE UPPER STOP. REPAIRED IAW DC9 SRM.SDR ABXA9700079Hinge Pin · corrodedWHILE COMPLYING WITH N-CARD 3219 AND AD 91-22-07, FOUND HINGE PINS ON LEFT MAIN LANDING GEAR OUTBOARD DOORS ARTICULATING SECTION RUSTED. REPLACED 3 ARTICULATING DOOR HINGE PINS IAW DC-9 OHM 32-10-6.SDR ABXA9500378Seat · malfunctionedCAPTAIN'S SEAT SLIDES BACK ON TAKEOFF AND CLIMBOUT. DIFFICULT TO LOCK IN PLACE. REPLACED CAPTAIN'S SEAT IAW DC-9 MM 25-10-0. OPS CHECKED GOOD. SEAT WAS ROUTED TO SHOP WHERE FUNCTIONALLY CHECKED GOOD. SUBSEQUENT FLIGHTS HAVE HAD NO DISCREPANCIES.SDR ABXA9500354Rod · out of adjustDURING GEAR EXTENTION, GEAR DOOR OPEN LIGHT DID NOT EXTINGUISH. RECYCLED GEAR, GEAR DOOR OPEN LIGHT WENT OUT AFTER THIRTY SECONDS. ADJUSTED RIGHT MAIN LANDING GEAR DOOR PUSHROD IAW DC-9 MM 32-31-0. PERFORMED GEAR SWING CYCLE, OPS CHECKED GOOD.SDR ABXA9500318Door · delaminatedDURING C-CHECK INSPECTION WHILE COMPLYING WITH A.D. 91-22-07; A.S.B. 32-244, FOUND LEFT MAIN LANDING GEAR OUTBOARD ARTICULATING DOOR DELAMINATED, APPROXIMATELY 30 SQUARE INCHES. REPLACED LEFT OUTBOARD FLYING DOOR IAW DC-9 M.M. 32-12-1.SDR ABXA9500319Intercostal · crackedDURING C-CHECK INSPECTION FOUND THE UPPER FLANGE OF AN INTERCOSTAL CRACKED. REPAIRED INTERCOSTAL IAW ABX REA D953-11304-MR.SDR ABXA9500317Frame · crackedDURING C-CHECK INSPECTION WHILE COMPLYING WITH A.D. 78-07-05; S.B. 53-131, FOUND RIGHT MAIN FRAME AT STA 737 CRACKED IN FORWARD INBOARD WEB. REPLACED MAIN FRAME AT STA 737R IAW DC-9 SRM 51-30-5 AND 51-30-2.SDR ABXA9500316Skin · oil canningDURING C-CHECK INSPECTION FOUND FUSELAGE SKIN TO BE OIL CANNING, 1 INCH DIAMETER AT FUSELAGE STATION 362, LONGERONS 21 AND 22R. REPAIRED SKIN IAW ABX REA D953-11287-MR.SDR ABXA9500321Frame · crackedDURING C-CHECK INSPECTION WHILE COMPLYING WITH A.D. 94-03-01, FOUND FUSELAGE FRAME AT STA 658 CRACKED AT LONGERON 19R. REPAIRED IAW DC-9 SRM 53-03, FIGURE 16.SDR ABXA9500320Frame · crackedDURING C-CHECK INSPECTION WHILE COMPLYING WITH A.D. 94-03-01, FOUND FUSELAGE FRAME AT STA 639 CRACKED AT LONGERON 19R. REPAIRED IAW DC-9 SRM 53-03, FIGURE 16.
Back to N929AX, cancelled Jul 20, 2017