N193AN
Service difficulty reports · 104
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 = 'N193AN' 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 = 'N193AN' 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 AALA20070113Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 11D HAS BROKEN SHROUD. REPLACED THE SHROUD FOR EMERGENCY LIGHT AT SEAT 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070112Shroud · brokenDFW - EMERGENCY LIGHT AT SEAT 6E HAS BROKEN SHROUD. REPLACED THE SHROUD FOR THE EMERGENCY LIGHT AT SEAT 6E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040617Module · inoperativeMIA - EMERGENCY LIGHTS FOR ROWS 9 THROUGH 15 INOPERATIVE. REMOVED AND REPLACED MODULE AND BATTERY FOR EMERGENCY LIGHTS FOR ROWS 9 THROUGH 15. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030179Wire · damagedLAX - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT SEAT MOUNTED LIGHT AT SEAT 9D INOPERATIVE. REPAIRED EMERGENCY EXIT SEAT LIGHT WIRE AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N193AN