AD 2002-16-18
Registered aircraft · 1,252
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:2002-16-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-16-18')
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:2002-16-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-16-18') 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.
N290NVSunrise Asset Management LLC · Las Vegas, NVN290WNSouthwest Airlines Co · Dallas, TXN291GXGlobal Crossing Airlines Inc · Miami, FLN291WNSouthwest Airlines Co · Dallas, TXN292WNSouthwest Airlines Co · Dallas, TXN293WNSouthwest Airlines Co · Dallas, TXN294WNSouthwest Airlines Co · Dallas, TXN295WNSouthwest Airlines Co · Dallas, TXN296NVBank Of Utah Trustee · Salt Lake City, UTN296WNSouthwest Airlines Co · Dallas, TXN29717United Airlines Inc · Chicago, ILN297NVBank Of Utah Trustee · Salt Lake City, UTN297WNSouthwest Airlines Co · Dallas, TXN298NVBank Of Utah Trustee · Salt Lake City, UTN300EKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN300SWFrontiers Of Flight Museum Inc · Dallas, TXN3014RAmerican 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, GAN30401United Airlines Inc · Chicago, ILN304DNDelta Air Lines Inc · Atlanta, GAN305DNDelta Air Lines Inc · Atlanta, GAN3069ABank Of Utah Trustee · Salt Lake City, UTN306NVSunrise Asset Management LLC · Las Vegas, NVN307DXDelta Air Lines Inc · Atlanta, GAN307NVSunrise Asset Management LLC · Las Vegas, NVN308BRUmb Bank Na Trustee · Salt Lake City, UTN308DNUmb Bank Na Trustee · Salt Lake City, UTN309DNBank Of Utah Trustee · Salt Lake City, UTN309NVSunrise Asset Management LLC · Las Vegas, NVN30ASAersale Inc · Doral, FLN310AGRegistration Pending · Salt Lake City, UTRegistration pendingN310DNUmb Bank Na Trustee · Salt Lake City, UTN311DNUmb Bank Na Trustee · Salt Lake City, UTN311MSUS Marshals Service Justice Prisoner & · Oklahoma City, OKN311NVSunrise 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, NVN31412United Airlines Inc · Chicago, ILN314NBDelta Air Lines Inc · Atlanta, GAN3159GUmb Bank Na Trustee · Salt Lake City, UTN315DNBank Of Utah Trustee · Salt Lake City, UTN315NBDelta Air Lines Inc · Atlanta, GA
Back to AD 2002-16-18