AD 2007-13-13
Registered aircraft · 688
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-13-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-13-13')
ORDER BY n_number"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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-13-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-13-13') ORDER BY n_number
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.
N85340United Airlines Inc · Chicago, ILN85351United Airlines Inc · Chicago, ILN85352United Airlines Inc · Chicago, ILN85354United Airlines Inc · Chicago, ILN85355United Airlines Inc · Chicago, ILN85356United Airlines Inc · Chicago, ILN85358United Airlines Inc · Chicago, ILN855RWRepublic Airways Inc · Carmel, INN857RWRepublic Airways Inc · Carmel, INN860RWUmb Bank Na Trustee · Salt Lake City, UTN861RWRepublic Airways Inc · Carmel, INN862RWRepublic Airways Inc · Carmel, INN86309United Airlines Inc · Chicago, ILN86334United Airlines Inc · Chicago, ILN86344United Airlines Inc · Chicago, ILN86347United Airlines Inc · Chicago, ILN863RWRepublic Airways Inc · Carmel, INN864RWRepublic Airways Inc · Carmel, INN865RWRepublic Airways Inc · Carmel, INN87318United Airlines Inc · Chicago, ILN87339United Airlines Inc · Chicago, ILN87345United Airlines Inc · Chicago, ILN87353United Airlines Inc · Chicago, ILN87360United Airlines Inc · Chicago, ILN875RWDelta Air Lines Inc · Atlanta, GAN878RWDelta Air Lines Inc · Atlanta, GAN879RWDelta Air Lines Inc · Atlanta, GAN880RWDelta Air Lines Inc · Atlanta, GAN882RWDelta Air Lines Inc · Atlanta, GAN88326United Airlines Inc · Chicago, ILN88335United Airlines Inc · Chicago, ILN88341United Airlines Inc · Chicago, ILN88346United Airlines Inc · Chicago, ILN88359United Airlines Inc · Chicago, ILN89315United Airlines Inc · Chicago, ILN89342United Airlines Inc · Chicago, ILN89357United Airlines Inc · Chicago, ILN979RPRepublic Airways Inc · Carmel, IN
Back to AD 2007-13-13