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.

N616ACN616ac LLC · Westfield, MABuilt 2021 · S/N 28020038 N616ADArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843736 N616AWAtd Pilot Training Lllc · Kansas City, MOBuilt 1976 · S/N 28-7790171 N616PCPork Chop Aviation II LLC · Hilliard, OHBuilt 2023 · S/N 28020117 N616VTNamendorf Michael · New Hyde Park, NYBuilt 1979 · S/N 28-7916500 N617JAYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 28020265 N6185HSargent Patrick S · Bicknell, INBuilt 1977 · S/N 28-7890215 N6188JRaveesh Cn · Gladstone, MIBuilt 1976 · S/N 28-7690367 N618FTFlorida Institute Of Technology · Melbourne, FLBuilt 1985 · S/N 28-8516048 N618NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881137 N6194JJettstar LLC · Marshall, MNBuilt 1976 · S/N 28-7690368 N6195JStandeford Thomas L · Lancaster, OHBuilt 1976 · S/N 28-7690369 N6196JArcher Aviation LLC · Jesup, IABuilt 1976 · S/N 28-7690370 N6199BD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 287916095 N619AGUnited States Air Force · Colorado Springs, COBuilt 1999 · S/N 2843252 N619AJBowen John P · Harrison Township, MIS/N 2890201 N619AMAirmart Inc · Lexington, KYS/N 2881093 N619FTParsley Thomas B · Downingtown, PABuilt 1985 · S/N 28-8616029 N619NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881138 N619SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881432 N619TMHeaton Andrew · Houston, TXBuilt 1979 · S/N 28-8090030 N61TACti Aircraft Leasing LLC · Memphis, TNBuilt 2020 · S/N 2881294 N6205JWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1976 · S/N 28-7690371 N6206JMerino Cesar · Washington, DCBuilt 1976 · S/N 28-7690372 N620AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843800 N620ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2014 · S/N 2843755 N620JExecutive Flyers Inc · Sacramento, CABuilt 1981 · S/N 28-8190227 N620UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020167 N62116Zoeller Billy · Vulcan, MIBuilt 1976 · S/N 28-7690081 N62147Stevens James A Jr · Morganton, NCBuilt 1979 · S/N 287990289 N6217HWalker Robert J · Manvel, TXBuilt 1977 · S/N 28-7816237 N6217JNathaniel Greene Dev Corp · Stanardsville, VAFirst renewal noticeBuilt 1976 · S/N 28-7690373 N6218JNelson Jeffery M · Eagle River, AKBuilt 1976 · S/N 28-7690374 N621ACFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2014 · S/N 2843759 N621FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020026 N621FTFlorida Institute Of Technology · Melbourne, FLBuilt 1984 · S/N 28-8416124 N621NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881159 N621TKSheeptick LLC · Conrad, MTBuilt 2022 · S/N 2881519 N6222HMortenson Lyle · Kennebec, SDBuilt 1977 · S/N 28R-7837058 N6226JXigent Aviation Inc · Wilmington, DEBuilt 1976 · S/N 28-7690375 N622CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881514 N622NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881160 N6231HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816238 N6232HParis Air Inc · Vero Beach, FLS/N 28-7816240 N6234CSchilling Aviation Services LLC · Salina, KSBuilt 1978 · S/N 28-7890349 N6235HAirworthyone LLC · Caledonia, MIBuilt 1977 · S/N 28-7890219 N6236CAviation Equipment Company LLC · Leesburg, VABuilt 1978 · S/N 28R-7837151 N6236JArcher N6236j LLC · Denver, COBuilt 1976 · S/N 28-7690377 N6237JHulett Michael · Saginaw, MOBuilt 1976 · S/N 28-7690378 N6239Arsenault Keith · West Brookfield, MABuilt 1984 · S/N 28-8590003

Back to AD 2016-07-21