N967AN
Service difficulty reports · 253
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 = 'N967AN' 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 = 'N967AN' 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 AALA20040823Light · inoperativeEMERGENCY EXIT IDENTIFIER FORWARD OF RIGHT HAND FORWARD SERVICE DOOR IS DAMAGED. FORWARD SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT 13D IS INOPERATIVE. REPLACED EMERGENCY EXIT IDENTIFIER ASSEMBLY AT RIGHT HAND FORWARD SERVICE DOOR. REPLACED FSDR AALA20040535Battery Pack · inoperativeBDL EMERGENCY LIGHT IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040522Battery Pack · inoperativeBDL EMERGENCY LIGHTS AT ROWS 7 THROUGH 11 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROWS 7 THROUGH 11. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)
Back to N967AN