AD 2016-07-12
Registered aircraft · 640
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:2016-07-12')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-12')
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:2016-07-12') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-12') 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.
N295NVBank Of Utah Trustee · Salt Lake City, UTN296NVBank Of Utah Trustee · Salt Lake City, UTN297NVBank Of Utah Trustee · Salt Lake City, UTN298NVBank Of Utah Trustee · Salt Lake City, UTN299NVAllegiant Air LLC · Las Vegas, NVN3014RAmerican Airlines Inc · Fort Worth, TXN301DVDelta Air Lines Inc · Atlanta, GAN301NBDelta Air Lines Inc · Atlanta, GAN301NVSunrise Asset Management LLC · Las Vegas, NVN302DNDelta Air Lines Inc · Atlanta, GAN302NBDelta Air Lines Inc · Atlanta, GAN302NVSunrise Asset Management LLC · Las Vegas, NVN303DNDelta Air Lines Inc · Atlanta, GAN304DNDelta Air Lines Inc · Atlanta, GAN305DNDelta Air Lines Inc · Atlanta, GAN305NVSunrise Asset Management LLC · Las Vegas, NVN306DNDelta Air Lines Inc · Atlanta, GAN306NVSunrise Asset Management LLC · Las Vegas, NVN307DXDelta Air Lines Inc · Atlanta, GAN307NVSunrise Asset Management LLC · Las Vegas, NVN308DNUmb Bank Na Trustee · Salt Lake City, UTN308NVSunrise Asset Management LLC · Las Vegas, NVN309DNBank Of Utah Trustee · Salt Lake City, UTN309NVSunrise Asset Management LLC · Las Vegas, NVN310DNUmb Bank Na Trustee · Salt Lake City, UTN311DNUmb Bank Na Trustee · Salt Lake City, UTN311NVSunrise Asset Management LLC · Las Vegas, NVN312DNBank Of Utah Trustee · Salt Lake City, UTN312NVSunrise Asset Management LLC · Las Vegas, NVN313DNBank Of Utah Trustee · Salt Lake City, UTN313NVSunrise Asset Management LLC · Las Vegas, NVN314DNBank Of Utah Trustee · Salt Lake City, UTN314NBDelta Air Lines Inc · Atlanta, GAN315DNBank Of Utah Trustee · Salt Lake City, UTN315NBDelta Air Lines Inc · Atlanta, GAN315NVSunrise Asset Management LLC · Las Vegas, NVN316DNUmb Bank Na Trustee · Salt Lake City, UTN316NBDelta Air Lines Inc · Atlanta, GAN316NVUmb Bank Na Trustee · Salt Lake City, UTN317DNUmb Bank Na Trustee · Salt Lake City, UTN317NBDelta Air Lines Inc · Atlanta, GAN318DXDelta Air Lines Inc · Atlanta, GAN318NBDelta Air Lines Inc · Atlanta, GAN318NVUmb Bank Na Trustee · Salt Lake City, UTN319DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeN319NBDelta Air Lines Inc · Atlanta, GAN319NVUmb Bank Na Trustee · Salt Lake City, UTN319USDelta Air Lines Inc · Atlanta, GAN320DNUmb Bank Na Trustee · Salt Lake City, UTN320NBDelta Air Lines Inc · Atlanta, GA
Back to AD 2016-07-12