AD 2011-12-01
Registered aircraft · 4,702
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:2011-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:2011-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:2011-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:2011-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.
N12221United Airlines Inc · Chicago, ILN12225United Airlines Inc · Chicago, ILN12238United Airlines Inc · Chicago, ILN1229AAndromeda Leasing I LLC · Purchase, NYN122DNDelta Air Lines Inc · Atlanta, GAN122NNUmb Bank Na Trustee · Salt Lake City, UTN122UAUnited Airlines Inc · Chicago, ILN122UPUnited Parcel Service Co · Louisville, KYN122USBank Of Utah Trustee · Salt Lake City, UTN123DWDelta Air Lines Inc · Atlanta, GAN123NNUmb Bank Na Trustee · Salt Lake City, UTN123UWBank Of Utah Trustee · Salt Lake City, UTN124AABank Of Utah Trustee · Salt Lake City, UTN124DXDelta Air Lines Inc · Atlanta, GAN124UPUnited Parcel Service Co · Louisville, KYN124USBank Of Utah Trustee · Salt Lake City, UTN125AABank Of Utah Trustee · Salt Lake City, UTN125DNDelta Air Lines Inc · Atlanta, GAN125UPUnited Parcel Service Co · Louisville, KYN125UWAmerican Airlines Inc · Forth Worth, TXN126ANBank Of Utah Trustee · Salt Lake City, UTN126DNDelta Air Lines Inc · Atlanta, GAN126UPC C & E I LLC · Louisville, KYN126UWAmerican Airlines Inc · Forth Worth, TXN127AABank Of Utah Trustee · Salt Lake City, UTN127DNDelta Air Lines Inc · Atlanta, GAN127NKPerris Valley Airport Inc · Perris, CAN127UPUnited Parcel Service Co · Louisville, KYN127UWAmerican Airlines Inc · Fort Worth, TXN127VFWoelbing Aviation LLC · Franksville, WIN1284Nelson Aero Service LLC · Aurora, CON128ANBank Of Utah Trustee · Salt Lake City, UTN128DNDelta Air Lines Inc · Atlanta, GAN128TSUmb Bank Na Trustee · Salt Lake City, UTN128UPUnited Parcel Service Co · Louisville, KYN128UWAmerican Airlines Inc · Fort Worth, TXN129AABank Of Utah Trustee · Salt Lake City, UTN129DNDelta Air Lines Inc · Atlanta, GAN129TWLogistic Air Inc · Reno, NVN129UPUnited Parcel Service Co · Louisville, KYN12VTwelve Volt Holdings LLC · Wappingers Falls, NYN130ANBank Of Utah Trustee · Salt Lake City, UTN130DQuigg Gary F · Crawfordsville, INN130QHbf Inc · Greenville, MEN130UPUnited Parcel Service Co · Louisville, KYN13110United Airlines Inc · Chicago, ILN13113United Airlines Inc · Chicago, ILN13138United Airlines Inc · Chicago, ILN131NNBank Of Utah Trustee · Salt Lake City, UTN131UPUnited Parcel Service Co · Louisville, KY
Back to AD 2011-12-01