AD 2011-16-03
Registered aircraft · 1,606
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-16-03')
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-16-03')
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-16-03') 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-16-03') 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.
N119DNDelta Air Lines Inc · Atlanta, GAN119NNUmb Bank Na Trustee · Salt Lake City, UTN119USBank Of Utah Trustee · Salt Lake City, UTN12028American Airlines Inc · Fort Worth, TXN120DNDelta Air Lines Inc · Atlanta, GAN120EEUmb Bank Na Trustee · Salt Lake City, UTN120UPUnited Parcel Service Co · Louisville, KYN121ANBank Of Utah Trustee · Salt Lake City, UTN121DZDelta Air Lines Inc · Atlanta, GAN121UPUnited Parcel Service Co · Louisville, KYN121UWBank Of Utah Trustee · Salt Lake City, UTN122DNDelta Air Lines Inc · Atlanta, GAN122NNUmb Bank Na Trustee · Salt Lake City, UTN122UPUnited 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, GAN127UPUnited Parcel Service Co · Louisville, KYN127UWAmerican Airlines Inc · Fort Worth, TXN128ANBank Of Utah Trustee · Salt Lake City, UTN128DNDelta Air Lines Inc · Atlanta, GAN128UPUnited Parcel Service Co · Louisville, KYN128UWAmerican Airlines Inc · Fort Worth, TXN129AABank Of Utah Trustee · Salt Lake City, UTN129DNDelta Air Lines Inc · Atlanta, GAN129UPUnited Parcel Service Co · Louisville, KYN130ANBank Of Utah Trustee · Salt Lake City, UTN130UPUnited Parcel Service Co · Louisville, KYN131NNBank Of Utah Trustee · Salt Lake City, UTN131UPUnited Parcel Service Co · Louisville, KYN132ANBank Of Utah Trustee · Salt Lake City, UTN133ANBank Of Utah Trustee · Salt Lake City, UTN133UPUnited Parcel Service Co · Louisville, KYN134ANBank Of Utah Trustee · Salt Lake City, UTN134UPUnited Parcel Service Co · Louisville, KY
Back to AD 2011-16-03