N774AN
Service difficulty reports · 252
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 = 'N774AN' 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 = 'N774AN' 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 AALA991237Audio Visual · defectiveNRT - FLT T153 - EN ROUTE ORD, NRT ELECTRICAL SMELL NOTED FROM ENTERTAINMENT UNIT. SYSTEM SHUT DOWN AND SMELL DISSIPATED. REPLACED AUDIO VISUAL UNIT AT SEAT ROW 9D/E/G. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR AALA991172Wire · defectiveNRT - FLT T0061 - VIDEO CONTROL BOX FAILURE CAUSED SMOKE TO ISSUE FROM SEAT 14E PERSONAL CONTROL UNIT (PCU). REPLACED WIRING HARNESS FOR DEPLOYMENT UNIT, VIDEO CHECKED GOOD. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)
Back to N774AN