AD 2000-12-01
Registered aircraft · 1,270
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:2000-12-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-12-01')
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:2000-12-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-12-01') 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.
N265WNSouthwest Airlines Co · Dallas, TXN266WNSouthwest Airlines Co · Dallas, TXN267WNSouthwest Airlines Co · Dallas, TXN268WNSouthwest Airlines Co · Dallas, TXN269WNSouthwest Airlines Co · Dallas, TXN271NVAllegiant Air LLC · Las Vegas, NVN27205United Airlines Inc · Chicago, ILN27213United Airlines Inc · Chicago, ILN27239United Airlines Inc · Chicago, ILN27246United Airlines Inc · Chicago, ILN272NVSunrise Asset Management LLC · Las Vegas, NVN272WNSouthwest Airlines Co · Dallas, TXN273NVSunrise Asset Management LLC · Las Vegas, NVN273RHDepartment Of The Air Force (Usaf) · Hill Afb, UTN273WNSouthwest Airlines Co · Dallas, TXN27421United Airlines Inc · Chicago, ILN274NVSunrise Asset Management LLC · Las Vegas, NVN274WNSouthwest Airlines Co · Dallas, TXN275WNSouthwest Airlines Co · Dallas, TXN276GXFalcon Msn 2695 Trust · Wilmington, DEN276WNSouthwest Airlines Co · Dallas, TXN27722United Airlines Inc · Chicago, ILN27724United Airlines Inc · Chicago, ILN27733United Airlines Inc · Chicago, ILN27734United Airlines Inc · Chicago, ILN277EAUmb Bank Na Trustee · Salt Lake City, UTN277NVSunrise Asset Management LLC · Las Vegas, NVN277WNSouthwest Airlines Co · Dallas, TXN278GXUmb Bank Na Trustee · Salt Lake City, UTN278NVSunrise Asset Management LLC · Las Vegas, NVN278WNSouthwest Airlines Co · Dallas, TXN279WNSouthwest Airlines Co · Dallas, TXN280WNSouthwest Airlines Co · Dallas, TXN281AVAircol 14 Trust · Wilmington, DEN281GXUmb Bank Na Trustee · Salt Lake City, UTN281WNSouthwest Airlines Co · Dallas, TXN28252U S Marshall Serv Justice & Alien Trans Sys(Jpats) · Oklahoma City, OKN282AAAerownership North American Services Inc Trustee · Dover, DEN282ADAar Aircraft & Engine Sales & Leasing Inc · Wood Dale, ILN282GXUmb Bank Na Trustee · Salt Lake City, UTN282WNSouthwest Airlines Co · Dallas, TXN283WNSouthwest Airlines Co · Dallas, TXN284AVAircol 16 · Wilmington, DEN284WNSouthwest Airlines Co · Dallas, TXN285GXUmb Bank Na Trustee · Salt Lake City, UTN285WNSouthwest Airlines Co · Dallas, TXN285XAVent Airlines Inc · Dover, DEN286WNSouthwest Airlines Co · Dallas, TXN287WNSouthwest Airlines Co · Dallas, TXN288WNSouthwest Airlines Co · Dallas, TX
Back to AD 2000-12-01