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.

N8397LWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 28-8190252 N83993Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8216007 N839ALHorizon Dreams LLC · Homer, GABuilt 2000 · S/N 2843412 N839DXPiper Aircraft Inc · Vero Beach, FLBuilt 2024 · S/N 2881825 N84001Darcy Aviation LLC · Danbury, CTBuilt 1985 · S/N 28-8516080 N84007Smith Michael W · Sharon, CTBuilt 1981 · S/N 28-8190259 N8400SParks Perry A · Goodell, IAS/N 28-8116251 N84014C-140 Company LLC · Milton, FLBuilt 1981 · S/N 28-8190263 N84015Tarakji Mohamad Hani A · Van Nuys, CABuilt 1981 · S/N 28-8190264 N8401FSchriner Keith D · Lanark, ILBuilt 1976 · S/N 28-7790238 N8401TWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 28-8290033 N84054Far Horizons LLC · Ravenel, SCBuilt 1981 · S/N 28-8116257 N8405BMiloud Chadd K · Fort Worth, TXBuilt 1981 · S/N 28-8116252 N8405MWilson Howard C · Georgetown, TXBuilt 1981 · S/N 28-8116254 N8405SAlston Tony · Midland, TXBuilt 1981 · S/N 28-8116255 N8406AColorado High Flyers LLC · Colorado Springs, COBuilt 1981 · S/N 28-8290017 N8406HP A Flying LLC · Pueblo, COFirst renewal noticeBuilt 1981 · S/N 28-8190269 N8408BCharlton Gary R II · Loudonville, NYBuilt 1981 · S/N 28-8116258 N8408ECandace A Larned Enterprises Inc · Long Beach, CABuilt 1981 · S/N 28-8116259 N8408LMacair Aviation LLC · Xenia, OHBuilt 1981 · S/N 28-8116261 N840CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2844182 N840DXPiper Aircraft Inc · Vero Beach, FLBuilt 2024 · S/N 2881826 N840TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842416 N840UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020194 N84109Bielak Donald · Louisburg, KSBuilt 1981 · S/N 28-8290034 N8410SNorth Shelby Aviation LLC · Wilmington, DEBuilt 1981 · S/N 28-8116263 N8411BGrohs Dihl J · Wessington Springs, SDBuilt 1981 · S/N 28-8190275 N8411CRtb Aviation LLC · Jurupa Valley, CABuilt 1976 · S/N 28-7690136 N8412CEiler Marc · Seattle, WAS/N 28-7690137 N8414M8414m LLC · Nunica, MIBuilt 1981 · S/N 28-8190276 N8414NAirlake Aero Inc · Lakeville, MNBuilt 1981 · S/N 28-8190278 N8414YLone Oak Aviation LLC · Greenville, NCBuilt 1981 · S/N 28-8190279 N84175Paris Air Inc · Vero Beach, FLS/N 288116274 N84176Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8116275 N8419HHoke William Jr · Charlestown, INBuilt 1981 · S/N 28-8190291 N841NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881308 N8420CRegistered aircraftBuilt 1976 · S/N 28-7690138 N84227Jernigan Alex E · Warrensburg, MOBuilt 1981 · S/N 28-8190298 N8422HDeevers Howard A · Tucson, AZBuilt 1981 · S/N 28-8116292 N8422NCenter Flying Inc · Lancaster, CABuilt 1981 · S/N 28-8190296 N8423AWinningham Artis R · Crossville, TNS/N 28-8190299 N8427GWarrior II Ltd · Des Plaines, ILBuilt 1981 · S/N 28-8116297 N8427KInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8116299 N8427TPierce Rex G · Shorewood, ILBuilt 1981 · S/N 28-8190302 N8427WKsiezyk Donald G · Wadsworth, OHBuilt 1981 · S/N 28-8290030 N8428BHiggins James · Oxford, NCBuilt 1981 · S/N 28-8190304 N8428HWilson Jessica D · Gallipolis Ferry, WVBuilt 1981 · S/N 28-8190305 N8428SLand O Lakes Flying Club Inc · Bloomfield Hills, MIBuilt 1981 · S/N 28-8190307 N842BJMaster Trade LLC · Detroit, MIBuilt 1977 · S/N 28-7716252 N84326Yang Edward E · Killeen, TXBuilt 1981 · S/N 28-8116313

Back to AD 2016-07-21