N666A, cancelled Jun 13, 2017
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 = 'N666A' AND deregistration_id = 'N666A-2017-06-13' 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 = 'N666A' AND deregistration_id = 'N666A-2017-06-13' 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 AALA20040935Battery Pack · inoperativeDFW - FORWARD CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK AND CHARGER MOD M10798 FOR FORWARD CABIN EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20020802Battery Pack · dischargedBOS - FOUND ROW 15-24 SEAT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK OVER ROW 19 IAW MM. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20002132Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, FORWARD EMERGENCY LIGHT AT OVERWING EXIT INOPERATIVE. REPLACED FORWARD OVERWING EMERGENCY EXIT LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20000307Wire · brokenDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT ESCAPE FLOOR PATH LIGHT STRIP AT COFFEE BAR INOPERATIVE. REPLACED 2 BAD JUMPER WIRES. SYSTEM GROUND CHECK NORMAL OPERATION. (M)
Back to N666A, cancelled Jun 13, 2017