N929AN
Service difficulty reports · 254
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 = 'N929AN' 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 = 'N929AN' 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 AALA20060659Light · inoperativeMIA - EMERGENCY LIGHTS AT SEAT ROW 14DEF INOPERATIVE. RELAMPED INOPERATIVE EMERGENCY LIGHTS AT SEAT ROW 14DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060091Battery Pack · failedTUL- EMERGENCY LIGHT BATTERY PACKS IN CABIN FAILED TEST. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040730Battery Pack · inoperativeEMERGENCY LIGHTS ABOVE SEATS 8A AND 7D ON OVERHEAD BIN INOPERATIVE. REPLACED BATTERY PACK M01676 FOR EMERGENCY LIGHTS ABOVE SEATS 8A AND 7D ON OVERHEAD BIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20002155Valve · defectiveBOS - FLT 527 - EN ROUTE YUL-MIA, NOSE LANDING GEAR WOULD NOT RETRACT. DIVERTED BOS AND LANDED WITHOUT FURTHER INCIDENT. REPLACED NOSE LANDING GEAR SHRADER VALVE. SYSTEM GROUND CHECKED NORMAL OPS. (M)
Back to N929AN