Skip to content

Registered aircraft · 22,413

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N6190WGrubenmann Ernst · Los Angeles, CABuilt 1964 · S/N 28-20217 N6191WHarris Nathaniel T · Oronogo, MOBuilt 1964 · S/N 28-20219 N6192JFirst Flight Corp · San Diego, CABuilt 1976 · S/N 28-7625229 N6194HJones Frederick W · Burgaw, NCBuilt 1977 · S/N 28R-7803096 N6194JJettstar LLC · Marshall, MNBuilt 1976 · S/N 28-7690368 N6195JStandeford Thomas L · Lancaster, OHBuilt 1976 · S/N 28-7690369 N6195WWillis Lee A · Roanoke, VABuilt 1964 · S/N 28-20225 N6196JArcher Aviation LLC · Jesup, IABuilt 1976 · S/N 28-7690370 N6196WDechaine Anthony L · Wyoming, MNBuilt 1964 · S/N 28-20226 N6197JN6197j LLC · Dallas, TXBuilt 1976 · S/N 28R-7635319 N6198JBess Michael S · Niceville, FLBuilt 1976 · S/N 32-7640098 N6198WCherry Creek School District No 5 · Greenwood Village, COBuilt 1964 · S/N 28-20229 N6199BD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 287916095 N6199HBig Sky Flyers LLC · Stevens, PAS/N 32R-7880048 N6199JReece Donald E · Odessa, FLS/N 32R-7680330 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 N61AFAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1998 · S/N 3257033 N61BLLong Darrin · Rincon, GABuilt 1979 · S/N 28R-7918182 N61CASmith Tobias N · Laporte, INBuilt 1974 · S/N 28-7415677 N61DEBergabo Bjorn E · Norwalk, CTBuilt 1979 · S/N 32-7940030 N61JWBig Bear Resorts Inc · Big Bear Lake, CABuilt 1979 · S/N 32R-8029023 N61TACti Aircraft Leasing LLC · Memphis, TNBuilt 2020 · S/N 2881294 N61WMJ Q Aviation LLC · Lynchburg, VABuilt 1979 · S/N 32R-7985091 N6200WGraves Jeffrey D · Smithville, TXBuilt 1964 · S/N 28-20232 N6201JL7 Aviation LLC · Geary, OKBuilt 1976 · S/N 32R-7680331 N6201WWilliam James S · Central City, NES/N 28-20211 N6203JJackman William Lee · Newman Lake, WAS/N 28-7625230 N6203WCoastal Valley Aviation Inc · Santa Maria, CABuilt 1964 · S/N 28-20234 N6204JFotos Kenneth J · Spring Grove, ILBuilt 1976 · S/N 28-7615331 N6204WTownley Bryan W · North Bend, WABuilt 1964 · S/N 28-20218 N6205JWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1976 · S/N 28-7690371 N6205WDave'S Aircraft Inc · Edgewater, FLBuilt 1964 · S/N 28-20237 N6206JMerino Cesar · Washington, DCBuilt 1976 · S/N 28-7690372 N6207WTashpulatov Mukhiddin · Hagerstown, MDBuilt 1964 · S/N 28-20240 N6208JCranbrook Aviation LLC · Vienna, VABuilt 1976 · S/N 28R-7635321 N620AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843800 N620ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2014 · S/N 2843755 N620BCBlair Bob Jr · Essex, MOBuilt 1974 · S/N 32-7400037 N620HLCherokee Aire LLC · Port Orange, FLBuilt 1964 · S/N 28-10513 N620JExecutive Flyers Inc · Sacramento, CABuilt 1981 · S/N 28-8190227 N620JSCurtin Richard A · Anniston, ALBuilt 1973 · S/N 28-7405048 N620UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020167 N6210JFhh Air LLC · New Albany, OHS/N 32R-7680333 N62116Zoeller Billy · Vulcan, MIBuilt 1976 · S/N 28-7690081

Back to AD 87-08-08 R3