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.
N397AZCargo Aircraft Management Inc · Wilmington, OHN397DADelta Air Lines Inc · Atlanta, GAN397UPUnited Parcel Service Co · Louisville, KYN398DADelta Air Lines Inc · Atlanta, GAN399DADelta Air Lines Inc · Atlanta, GAN3ERegistered aircraftN402ASAlaska Airlines Inc · Seatac, WAN403ASAlaska Airlines Inc · Seattle, WAN407ASAlaska Airlines Inc · Seatac, WAN408ASAlaska Airlines Inc · Seattle, WAN409ASAlaska Airlines Inc · Seattle, WAN41135United Airlines Inc · Chicago, ILN41140United Airlines Inc · Chicago, ILN413ASAlaska Airlines Inc · Seattle, WAN413CMCargo Aircraft Management Inc · Wilmington, OHN418LACernicalo Leasing LLC · Wilmington, DEN419ASAlaska Airlines Inc · Seattle, WAN419AZCargo Aircraft Management Inc · Wilmington, OHN420LACaiquen Leasing LLC · Wilmington, DEN423ASAlaska Airlines Inc · Seattle, WAN423AXOmni Planes LLC · Tulsa, OKN428ASAlaska Airlines Inc · Seattle, WAN431ASAlaska Airlines Inc · Seattle, WAN431AZCargo Aircraft Management Inc · Wilmington, OHN432AXCargo Aircraft Management Inc · Wilmington, OHN433ASAlaska Airlines Inc · Seattle, WAN433AZCargo Aircraft Management Inc · Wilmington, OHN434ASAlaska Airlines Inc · Seattle, WAN435ASAlaska Airlines Inc · Seattle, WAN440ASAlaska Airlines Inc · Seattle, WAN442ASAlaska Airlines Inc · Seattle, WAN443AZCargo Aircraft Management Inc · Wilmington, OHN448ASAlaska Airlines Inc · Seattle, WAN453ASAlaska Airlines Inc · Seatac, WAN45440United Airlines Inc · Chicago, ILN455CMCargo Aircraft Management Inc · Wilmington, OHN457ASAlaska Airlines Inc · Seatac, WAN457AZCargo Aircraft Management Inc · Wilmington, OHN459ASAlaska Airlines Inc · Seatac, WAN461ASAlaska Airlines Inc · Seattle, WAN462ASAlaska Airlines Inc · Seattle, WAN462CMN462cm Inc · Wilmington, DENon-citizen corporation, flight hours not reportedN464ASAlaska Airlines Inc · Seatac, WAN467ASAlaska Airlines Inc · Seatac, WAN468ASAlaska Airlines Inc · Seattle, WAN469AMUmb Bank Na Trustee · Salt Lake City, UTN469ASAlaska Airlines Inc · Seattle, WAN471ASAlaska Airlines Inc · Seattle, WAN471DSBoeing Co · Renton, WAN471TNUmb Bank Na Trustee · Salt Lake City, UT
Back to AD 2018-20-13