N916AN
Service difficulty reports · 215
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 = 'N916AN' AND registry_match = 'registration' 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 = 'N916AN' AND registry_match = 'registration' 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 AALA20100226TUL10Angle · corrodedCREASE ANGLE CORRODED STATION 927 TO 947 RIGHT SIDE. INSTALLED DOUBLER PER SRM 51-70-11-2R.SDR AALA200800924Connector · inoperativeMIA - EMERGENCY LIGHT AT SEAT 22D INOPERATIVE. RECONNECTED LOOSE PLUG IN GRILL WALL FOR EMERGENCY LIGHT AT SEAT 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800719Lens · missingMIA - EMERGENCY LIGHT AT SEAT 16D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071829Cover · detachedMEX - CABIN SEAT TRIM COVER THAT HOLDS EMERGENCY LIGHTS DETACHED. REINSTALLED CABIN SEAT TRIM COVER WITH EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071581Lens · missingDFW - EMERGENCY LIGHT AT SEAT ROW 13F MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 13F. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071580Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 13F INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 13F. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071579Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 19D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071578Light · inoperativeDFW - EMERGENCY LIGHT AT AFT SEAT ROW 14D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT AFT SEAT ROW 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071577Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT ROW 14D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070665Lens · brokenTUL - EMERGENCY LIGHT AT SEAT 5E HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 5E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070664Bulb · burned outTUL - EMERGENCY LIGHT AT FLIGHT DECK INOPERATIVE. RELAMPED EMERGENCY LIGHT AT FLIGHT DECK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050736Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN MID CABIN INOPERATIVE. REPLACED BATTERY PACK IN MID COACH SECTION AT STATION FOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040725Slide · failedFORWARD SERVICE ENTRANCE SLIDE DID NOT INFLATE WHEN DROPPED. MANUALLY PULLED FOR INFLATION. REPLACED SLIDE FOR FORWARD SERVICE ENTRANCE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040376Pump · failedDFW - INFLIGHT T2154/21 NUMBER 2 ENGINE HYDRAULIC LOW PRESSURE LIGHT CAME ON DURING CRUISE. SHORTLY AFTER LOST ALL OF SYSTEM B-HYDRAULIC PRESSURE. DECLARED EMERGENCY AND LANDED AT DFW WITHOUT INCIDENT. REPLACED RIGHT HAND ENGINE HYDRAULIC PUMP AND FILTER. SDR AALA20020065Connector · damagedTUL - DURING OVERNIGHT MAINTENANCE, FOUND EMERGENCY ESCAPE PATH LGIHT ON SEAT 9D INOPERATIVE. RESEATED PIN ON LIGHT SOCKET CONNECTOR TO SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N916AN