AD 2012-14-01
Registered aircraft · 521
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:2012-14-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:2012-14-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:2012-14-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:2012-14-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.
N474DMillard S Drexler Inc · Teterboro, NJN474MJAir 47 LLC · Addison, TXN475HAHawaiian Airlines Inc · Seattle, WAN476HAHawaiian Airlines Inc · Seattle, WAN477HAHawaiian Airlines Inc · Seatac, WAN478HAHawaiian Airlines Inc · Seattle, WAN479HAHawaiian Airlines Inc · Seattle, WAN480HAHawaiian Airlines Inc · Seattle, WAN483HAHawaiian Airlines Inc · Seattle, WAN484HAHawaiian Airlines Inc · Seatac, WAN485HAHawaiian Airlines Inc · Seatac, WAN486HAHawaiian Airlines Inc · Seattle, WAN487HAHawaiian Airlines Inc · Seattle, WAN488HAHawaiian Airlines Inc · Seattle, WAN489HAHawaiian Airlines Inc · Seattle, WAN48WGAlliance Aviation Group LLC · Wilmington, DEN490HAHawaiian Airlines Inc · Seattle, WAN491HAHawaiian Airlines Inc · Seatac, WAN492HAHawaiian Airlines Inc · Seatac, WAN493HAHawaiian Airlines Inc · Seatac, WAN494HAHawaiian Airlines Inc · Seattle, WAN495HAHawaiian Airlines Inc · Seatac, WAN5000XTeratorn LLC · Seattle, WAN501GMSc Transport LLC · Torrance, CAN503GVEmmanuel Group · North Wilkesboro, NCN504VJBank Of Utah Trustee · Salt Lake City, UTN50JEIn50je LLC · New York, NYN50KUUnder The Stars LLC · Millington, TNN510SRRelated 2019 LLC · New York, NYN511DBSkybird Aviation Inc · Newport Beach, CAN514NBAlten Consulting LLC · Fort Lauderdale, FLN515KAWilmington Trust Co Trustee · Wilmington, DEN515MJFleet Two LLC · Beverly Hills, CAN516GHMadero Air LLC · South Saint Paul, MNN516WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN518GPG550 Msn 5051 Leasing LLC · Miami Beach, FLN519CPAircraft Guaranty Corp Trustee · Oklahoma City, OKN51SETps LLC · Medina, WAN51VETrousdale Aviation LLC · West Hollywood, CAN521GAGulfstream Aerospace Corp · Savannah, GAN524AGTvpx Ars Inc Trustee · North Salt Lake, UTN527JGGibbs International Inc · Spartanburg, SCN529RLRegistered aircraftN530PMEbts LLC · New York, NYN535VDelaware Aircraft Trust LLC Trustee · New Castle, DEN53GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN543HAir Troxel LLC · Honolulu, HIN549CPSlmf LLC · Blaine, MNN54DPGps 1 LLC · Tampa, FLN550Kendall Road Pegasus LLC · Chicago, IL
Back to AD 2012-14-01