N981AX, cancelled Jul 20, 2017
Service difficulty reports · 65
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 = 'N981AX' AND deregistration_id = 'N981AX-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 = 'N981AX' AND deregistration_id = 'N981AX-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 ABXA9701953Longeron · crackedDURING C-CHECK, FOUND LONGERON 30 CRACKED BETWEEN STA 408 AND 427. REPLACED LONGERON FROM STA 380 TO 415 IAW DC9 SRM 53-02.SDR ABXA9701952Skin · corrodedDURING C-CHECK, FOUND THE FUSELAGE SKIN UNDER THE RADIO ALTIMETER ANTENNA STA 427 AND LONG 30 HEAVILY CORRODED. REPAIRED SKIN IAW ABX REA D953-22014-MR.SDR ABXA9701951Intercostal · crackedDURING C-CHECK, FOUND INTERCOSTAL AT BL O.O AND STA 505 CRACKED THROUGH THE LOWER MOUNT FLANGE. REPLACED INTERCOSTAL IAW DACO DWG 9957914.SDR ABXA9701950Frame · crackedDURING C-CHECK, FOUND FUSELAGE FRAME AT STA 522 AND LONGERON 23R FORWARD LOWER FLANGE CRACKED. REPAIRED FRAME IAW ABX REA D953-22002-MR.SDR ABXA9701949Seat Track · corrodedDURING C-CHECK, FOUND THE CAPTAINS OUTBD AFT SEAT TRACK SEVERELY CORRODED. REPLACED CAPTAINS SEAT TRACK IAW ABX REA D953-22026-MR.SDR ABXA9701707Air Distribution · odorON APPROACH HAD A BURNING SMELL IN COCKPIT. SMELLED LIKE VINYL OR PLASTIC HOT SMELL. POSSIBLY ASSOCIATED WITH USE OF AIRFOIL ANTI-ICE. COULD NOT DUPLICATE DISCREPANCY. PRESSURIZED AIRCRAFT USING BOTH AIR CONDITIONING PACKS, RAN APU AND BOTH ENGINES. INSPESDR ABXA9701686Air Distribution · odorSTINGING, BURNING ODOR ON SHORT-FINAL AND TAXI -IN. SMELLED LIKE BURNING INSULATION. CHECKED COCKPIT LIGHTING FOR BURNT WIRING AND OPERATION. RAN APU AND BOTH AIR CONDITIONING PACKS. NO BURNING SMELL NOTED.SDR ABXA9701141Battery Pack · corrodedEMERGENCY LIGHTS IN AFT OVERHEAD WEAK. CLEANED CORROSION FROM BATTERY PACK CONTACTS, OPS CHECKED GOOD.SDR ABXA9600488Drain Line · pluggedCABIN PRESSURE ANNUNCIATOR LIGHT AND MASTER WARNING LIGHT ON AT FL 310, OUTFLOW VALVE FULLY CLOSED, BOTH AIR CONDITIONING PACKS NORMAL PRESSURE, CABIN CONTINUED TO CLIMB DURING DESCENT TO 12,000 FEET. REPLACED LEFT AND RIGHT COALESCER BAGS, REPLACED LEFT WATESDR ABXA9600479Skin Splice · corrodedDURING C-CHECK INSPECTION, FOUND THE T-CAP FOR WATER LINE SKIN SPLICE CORRODED AT STA 967, LONGERON 18L. REPAIRED IAW ABX REA D953-14995-MR.SDR ABXA9600481Skin · crackedDURING C-CHECK INSPECTION, FOUND THE FUSELAGE SKIN CRACKED AT STA 950, BETWEEN L14L AND L15L. REPAIRED IAW ABX REA D953-14980-MR.SDR ABXA9600480Angle · corrodedDURING C-CHECK INSPECTION, FOUND THE FLOOR BEAM ANGLE AT STA 965 CORRODED AT LBL 45. REPAIRED IAW ABX REA D953-14971-MR.SDR ABXA9600482Skin · crackedDURING C-CHECK INSPECTION, FOUND FUSELAGE SKIN CRACKED AT STA 990, BETWEEN L16L AND L15L. REPAIRED IAW ABX REA D953-14986-MR.SDR ABXA9600475Vane · delaminatedDURING C-CHECK INSPECTION, FOUND THE RIGHT FLAP INBOARD FIXED VANE DELAMINATED. REPLACED THE VANE IAW DC-9 MM 27-51-3.SDR ABXA9500564Bulb · defectiveON APPROACH, THE GEAR DOOR OPEN LIGHT DID NOT ILLUMINATE. REPLACED BULB, RECYCLED GEAR, SYSTEM OPS CHECKED GOOD. CHECKED LAMP FOR CORRECT LAMP P/N, CYCLED MAIN GEAR DOOR SEVERAL TIMES, SYSTEM OPS CHECKED GOOD IAW DC 9 MM.
Back to N981AX, cancelled Jul 20, 2017