Skip to content

Registered aircraft · 5,443

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

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-21') 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-21') ORDER BY n_number

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-21')
    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-21')
  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-21')
  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-21')
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.

N4090QWieczorek Alan · Lees Summit, MOS/N 28-7716171 N4098QLongleaf Auction LLC · Williamston, NCS/N 28-7790471 N409CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881120 N409CCPappy Air LLC · Pickerington, OHBuilt 2023 · S/N 28020113 N409DParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020224 N409TPParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020073 N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036 N40SFSterling Flight Training LLC · Jacksonville, FLBuilt 2020 · S/N 2881377 N4100QTailwinds Flying Club · Hudson, WIS/N 28-7790472 N4106QDairy Air Inc · Wyoming, PAS/N 28R-7737061 N410ETAndervick · Dalton, GABuilt 1976 · S/N 28-7690391 N410TCNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881088 N4110PSkyway LLC · Bronx, NYBuilt 1998 · S/N 2843143 N4117FMade U Look Promotions LLC · Glastonbury, CTBuilt 1976 · S/N 28-7790004 N411BCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2843339 N411BSMa Aviation Group LLC · Farmingdale, NYBuilt 2004 · S/N 2843598 N411NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010005 N4120FBcs Air Inc · Oakhurst, CABuilt 1976 · S/N 28-7790005 N4120KJansar Aviation LLC · Farmington Hills, MIBuilt 1999 · S/N 2843225 N4121RTaylor John W · Slatington, PABuilt 1998 · S/N 2843134 N4121TChandler Air Service Inc · Chandler, AZBuilt 1996 · S/N 2842017 N4122DCloud Chaser Aviation LLC · Chesnee, SCBuilt 1998 · S/N 2843130 N4124MN4124m LLC · Richfield, OHBuilt 1999 · S/N 2843214 N4124N2c Air LLC · Edmond, OKBuilt 1998 · S/N 2843146 N4124VFlyry Aviation LLC · Mahwah, NJBuilt 1998 · S/N 2843155 N4124ZAustin Kyle · Havre, MTBuilt 1998 · S/N 2843187 N41259Pan Am Flight Services - St Joseph LLC · Saint Joseph, MOBuilt 1998 · S/N 2843138 N4125VMyhrstad Thor · Aptos, CABuilt 1998 · S/N 2843165 N4126UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843175 N41270Pacific Flight Aviation LLC · Costa Mesa, CAS/N 2843251 N4127ALiquid Metal LLC · Wilmington, DEBuilt 1998 · S/N 2843148 N4128TLitteken Mark A Trustee · Valatie, NYBuilt 1998 · S/N 2843156 N4129DBoyd Edward Lee · Apison, TNBuilt 1998 · S/N 2843174 N4129RD&J Aviation LLC · Apopka, FLBuilt 1998 · S/N 2843159 N412AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843740 N412DKChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843933 N4130HRichard Plastics Co · Laurel, MSBuilt 1998 · S/N 2843182 N4130NCentral Irrigation Supply Co · Watsonville, CABuilt 1998 · S/N 2843171 N4131CCoco Aircraft Inc · Merritt Island, FLBuilt 1996 · S/N 2844010 N4131TSkywest Leasing Inc · St George, UTS/N 2843216 N4131UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843199 N4132DDominguez Luis · Brownsville, TXBuilt 1999 · S/N 2843234 N4133DBird Acquisition LLC · Phoenix, AZS/N 2843117 N4134TDavis Stephen · Madera, CABuilt 1999 · S/N 2843206 N4135DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 2843219 N4135WTexins Flying Club · Mckinney, TXBuilt 1999 · S/N 2843244 N4137LLuv 2 Fly Ada LLC · Ada, OKBuilt 1999 · S/N 2843249 N413KTAce Tomato Company LLC · Mcgregor, TXBuilt 2005 · S/N 2843608 N413NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010006 N413THPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020252

Back to AD 2016-07-21