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.
N487CMCargo Aircraft Management Inc · Wilmington, OHN491ASAlaska Airlines Inc · Seattle, WAN491AZCargo Aircraft Management Inc · Wilmington, OHN492ASAlaska Airlines Inc · Seatac, WAN493ASAlaska Airlines Inc · Seattle, WAN494ASAlaska Airlines Inc · Seattle, WAN495ASAlaska Airlines Inc · Seattle, WAN495MMAmazon.Com Services LLC · Seattle, WAN499AMUmb Bank Na Trustee · Salt Lake City, UTN499AZCargo Aircraft Management Inc · Wilmington, OHN503AZAmazon.Com Services LLC · Seattle, WAN503KWAlta Airlines Holdings LLC · Salt Lake City, UTN503UAUnited Airlines Inc · Chicago, ILN506ASUmb Bank Na Trustee · Salt Lake City, UTN507YVBank Of Utah Trustee · Salt Lake City, UTN508ASAlaska Airlines Inc · Seattle, WAN508UAUnited Airlines Inc · Chicago, ILN509KWAlta Airlines Holdings LLC · Salt Lake City, UTN512ASWilmington Trust Co Trustee · Wilmington, DEN513ASUmb Bank Na Trustee · Salt Lake City, UTN514ASAlaska Airlines Inc · Seattle, WAN516ASWilmington Trust Co Trustee · Wilmington, DEN517ASAlaska Airlines Inc · Seatac, WAN518ASAlaska Airlines Inc · Seattle, WAN518UAUnited Airlines Inc · Chicago, ILN519ASAlaska Airlines Inc · Seatac, WAN520ASAlaska Airlines Inc · Seattle, WAN523ASWilmington Trust Co Trustee · Wilmington, DEN524ASAlaska Airlines Inc · Seatac, WAN525ASAlaska Airlines Inc · Seatac, WAN526ASAlaska Airlines Inc · Seatac, WAN527ASAlaska Airlines Inc · Seatac, WAN528ASAlaska Airlines Inc · Seattle, WAN529ASAlaska Airlines Inc · Seatac, WAN530ASAlaska Airlines Inc · Seattle, WAN531ASAlaska Airlines Inc · Seattle, WAN532ASAlaska Airlines Inc · Seatac, WAN533ASAlaska Airlines Inc · Seatac, WAN53441United Airlines Inc · Chicago, ILN53442United Airlines Inc · Chicago, ILN534ASAlaska Airlines Inc · Seatac, WAN534LAChirihue Leasing Trust · Wilmington, DEN535ASAlaska Airlines Inc · Seattle, WAN536ASAlaska Airlines Inc · Seattle, WAN536LAChirihue Leasing Trust · Wilmington, DEN537ASAlaska Airlines Inc · Seatac, WAN538ASAlaska Airlines Inc · Seattle, WAN538LAQuetro Aircraft Leasing Trust · Wilmington, DEN539USDelta Air Lines Inc · Atlanta, GAN540LACaiquen Leasing LLC · Wilmington, DE
Back to AD 2018-20-13