AD 2018-20-13
Registered aircraft · 2,770
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:2018-20-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:2018-20-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:2018-20-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:2018-20-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.
N812AKAlaska Airlines Inc · Seattle, WAN812DNDelta Air Lines Inc · Atlanta, GAN812NNWilmington Trust Co Trustee · Wilmington, DEN812UPAmerican Airlines Inc · Fort Worth, TXN813AKAlaska Airlines Inc · Seattle, WAN813DNDelta Air Lines Inc · Atlanta, GAN813NNWilmington Trust Co Trustee · Wilmington, DEN813VLUmb Bank Na Trustee · Salt Lake City, UTN81449United Airlines Inc · Chicago, ILN814AKAlaska Airlines Inc · Seatac, WAN814DNDelta Air Lines Inc · Atlanta, GAN814NNAmerican Airlines Inc · Fort Worth, TXN815AKAlaska Airlines Inc · Seattle, WAN815DNDelta Air Lines Inc · Atlanta, GAN815NNWilmington Trust Co Trustee · Wilmington, DEN816AKAlaska Airlines Inc · Seattle, WAN816DNDelta Air Lines Inc · Atlanta, GAN816NNWilmington Trust Co Trustee · Wilmington, DEN817DNDelta Air Lines Inc · Atlanta, GAN817NNAmerican Airlines Inc · Fort Worth, TXN818DADelta Air Lines Inc · Atlanta, GAN818NHAersale Inc · Doral, FLN818NNWilmington Trust Co Trustee · Wilmington, DEN819DNDelta Air Lines Inc · Atlanta, GAN819NNAmerican Airlines Inc · Fort Worth, TXN820DNDelta Air Lines Inc · Atlanta, GAN820NNAmerican Airlines Inc · Fort Worth, TXN821AKAlaska Airlines Inc · Seatac, WAN821DNDelta Air Lines Inc · Atlanta, GAN821NNWilmington Trust Co Trustee · Wilmington, DEN822DNDelta Air Lines Inc · Atlanta, GAN822NNWilmington Trust Co Trustee · Wilmington, DEN823AKAlaska Airlines Inc · Seatac, WAN823DNDelta Airlines Inc · Atlanta, GAN823NNWilmington Trust Co Trustee · Wilmington, DEN823SYSun Country Inc · Minneapolis, MNN824DNDelta Air Lines Inc · Atlanta, GAN824NNWilmington Trust Co Trustee · Wilmington, DEN824SYSun Country Inc · Minneapolis, MNN825AMWells Fargo Trust Co Na Trustee · Columbia, MDN825DNDelta Air Lines Inc · Atlanta, GAN825MHDelta Air Lines Inc · Atlanta, GAN825NNAmerican Airlines Inc · Fort Worth, TXN826DNDelta Air Lines Inc · Atlanta, GAN826MHDelta Air Lines Inc · Atlanta, GAN826NNAmerican Airlines Inc · Fort Worth, TXN827DNDelta Air Lines Inc · Atlanta, GAN827MHDelta Air Lines Inc · Atlanta, GAN827NNAmerican Airlines Inc · Fort Worth, TXN828DNDelta Air Lines Inc · Atlanta, GA
Back to AD 2018-20-13