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.
N128DNDelta Air Lines Inc · Atlanta, GAN128UWAmerican Airlines Inc · Fort Worth, TXN129DNDelta Air Lines Inc · Atlanta, GAN150UWAmerican Airlines Inc · Fort Worth, TXN151UWAmerican Airlines Inc · Fort Worth, TXN152UWAmerican Airlines Inc · Fort Worth, TXN153UWAmerican Airlines Inc · Fort Worth, TXN154UWAmerican Airlines Inc · Fort Worth, TXN155UWAmerican Airlines Inc · Fort Worth, TXN156UWAmerican Airlines Inc · Fort Worth, TXN157UWAmerican Airlines Inc · Fort Worth, TXN158ASAersale Inc · Coral Gables, FLN161UWAmerican Airlines Inc · Fort Worth, TXN162UWAmerican Airlines Inc · Fort Worth, TXN1630ABank Of Utah Trustee · Salt Lake City, UTN163USAmerican Airlines Inc · Fort Worth, TXN165USAmerican Airlines Inc · Fort Worth, TXN167USBank Of Utah Trustee · Salt Lake City, UTN169UWBank Of Utah Trustee · Salt Lake City, UTN170USAmerican Airlines Inc · Fort Worth, TXN171USBank Of Utah Trustee · Salt Lake City, UTN172USBank Of Utah Trustee · Salt Lake City, UTN173USBank Of Utah Trustee · Salt Lake City, UTN174USBank Of Utah Trustee · Salt Lake City, UTN176UWAmerican Airlines Inc · Fort Worth, TXN177USAmerican Airlines Inc · Fort Worth, TXN177XFWilmington Trust Co Trustee · Wilmington, DEN178USAmerican Airlines Inc · Fort Worth, TXN179UWWilmington Trust Co Trustee · Wilmington, DEN1805ABank Of Utah Trustee · Salt Lake City, UTN180USWilmington Trust Co Trustee · Wilmington, DEN181UWAmerican Airlines Inc · Fort Worth, TXN182UWWilmington Trust Co Trustee · Wilmington, DEN183UWWilmington Trust Co Trustee · Wilmington, DEN184USAmerican Airlines Inc · Fort Worth, TXN185UWAmerican Airlines Inc · Fort Worth, TXN186USAmerican Airlines Inc · Fort Worth, TXN187USAmerican Airlines Inc · Fort Worth, TXN188NVAllegiant Air LLC · Las Vegas, NVN188USAmerican Airlines Inc · Fort Worth, TXN189NVSunrise Asset Management LLC · Las Vegas, NVN189UWAmerican Airlines Inc · Fort Worth, TXN190NVAllegiant Air LLC · Las Vegas, NVN190UWAmerican Airlines Inc · Fort Worth, TXN191NVAllegiant Air LLC · Las Vegas, NVN191UWBank Of Utah Trustee · Salt Lake City, UTN192NVAllegiant Air LLC · Las Vegas, NVN192UWBank Of Utah Trustee · Salt Lake City, UTN193NVAllegiant Air LLC · Las Vegas, NVN193UWAmerican Airlines Inc · Fort Worth, TX
Back to AD 2016-07-12