AD 2016-20-06
Registered aircraft · 453
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-20-06')
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-20-06')
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-20-06') 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-20-06') 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.
N226MPExecutive Jet Group LLC · Opa Locka, FLN226RS226rs LLC · Cypress, TXN227LAK&A Advisors LLC · Wilmington, DEN228RECape Clear LLC · Westborough, MAN232FN232k LLC · Midland, TXN234LRDanish Jet Inc Trustee · Cheyenne, WYN236CACypress Cove Air LLC · Phoenix, AZN247LMLive Mas Enterprises LLC · Greenwood Village, CON24YSRegistered aircraftN250KCFlight 444 LLC · Atlanta, GAN250RGAviation Co Inc · Cheyenne, WYN254CAMmap LLC · Houston, TXN25RARadz Airways LLC · Solana Beach, CAN261JDMaizenblue Express LLC · Jupiter, FLN268VTAvire LLC · West Hollywood, CAN26DJGulfstream IV-Sp Msn 1206 N26dj LLC · Wilmington, DEN270SCTrans-Exec Air Service Inc · Van Nuys, CAN271TVJaydak LLC · Tampa, FLN273SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN275DJBank Of Utah Trustee · Salt Lake City, UTN290PSNappyboy Skyhaus LLC · Roswell, GAN291VKV-Jet Aircraft Holding Co Trustee · Dover, DEN298RBSmb G-IV IV LLC · Longwood, FLN299MBOne World Aviation 299 LLC · Atlanta, GAN2RDAmerican Gift LLC · Atlanta, GAN300SFModern Industrial Services Inc · Beaumont, TXN303MPAir Cargo Services LLC · Miami, FLN30501Dutchess Community College · Poughkeepsie, NYN305DGAerobeauty LLC · Santa Fe Springs, CAN305GHN305dg LLC · Miami, FLN305LMHga LLC · Dallas, TXN305LRAircraft Holding Solutions LLC Trustee · Newark, DEN305TCAlliance Aviation Group LLC · Wilmington, DEN306TTIgnite Enterprises LLC · Cerritos, CAN307EWFast Bird LLC · Wilmington, DEN308JWSupera Aviation I LLC · Sarasota, FLN30DJBizav Support LLC · Fort Lauderdale, FLN30GDCarol City Air LLC · Hialeah, FLN30HEClassic Aircraft Aviation Museum Inc · Hillsboro, ORN30JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN30LHHillier Giv LLC · Va Beach, VAN30LXN492a LLC · Goodyear, AZN30WRInfotech Management Inc · San Diego, CANon-citizen corporation, flight hours not reportedN313ARDora 13 LLC · North Bergen, NJN313MSEpic Rise LLC · Tulsa, OKN316VBLiving Word Christian Center · Forest Park, ILN31GVAircraft Fidelity Corp Trustee · Dover, DEN320MKAerovision-Logos Aircraft Holdings Vii Corp · Dover, DEN324FPWilmington Trust Co Trustee · Wilmington, DEN324JWVip Jet Transportation Inc · Bishop, CA
Back to AD 2016-20-06