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.

N814TWGeorge Walker Field Inc · Bedminster, NJBuilt 1985 · S/N 28-8590029 N81509Dr Craig D Bartruff Md Pc · Mccook, NEBuilt 1980 · S/N 28-8090233 N8150ABnb Enterprises Inc · Erie, PABuilt 1980 · S/N 28-8090228 N8150JVandelay Aviation LLC · San Diego, CABuilt 1980 · S/N 28-8090229 N8150UCarpenter Sheldon · Liberty Two, OHBuilt 1980 · S/N 28-8090231 N8150XThere And Back Again LLC · Yorktown, VABuilt 1980 · S/N 28-8090232 N81525Wilcox Robert D Jr · Mccook, NEBuilt 1980 · S/N 28-8016257 N8155GSaraceno Robert Jr · Lynnfield, MABuilt 1980 · S/N 28-8090237 N8155HPeckerhead Motorcycle Racing LLC · Gainesville, GABuilt 1982 · S/N 28-8290101 N8156RGhazarian Christopher L · North Hollywood, CABuilt 1979 · S/N 28-8016156 N8156TAzcona Rogelio G · Okeechobee, FLBuilt 1979 · S/N 28-8016219 N81586Elbarki Maged A · Boca Raton, FLBuilt 1980 · S/N 28-8090245 N8158HLopez-Haley LLC · Mc Afee, NJS/N 28-8016268 N8158ZLee Randy A · Gulf Shores, ALBuilt 1980 · S/N 28-8016269 N815DFOglesby Richard A Jr · Atlanta, GABuilt 1999 · S/N 2843295 N815DXGlobe Aero LLC · Lakeland, FLBuilt 2025 · S/N 2881839 N815TFAir Fleet Holdings LLC · Missoula, MTS/N 2881703 N81612Av8rlounge LLC · Columbia, SCBuilt 1980 · S/N 28-8016270 N8161DDicey Aviation LLC · Somerset, KYBuilt 1980 · S/N 28-8016220 N8162ADedominici Kenneth · East Bridgewater, MABuilt 1980 · S/N 28-8016272 N8162QMcconnell Thomas R · St Simons Island, GABuilt 1980 · S/N 28-8090251 N8162RNoyes Daniel Ernest · Burton, MIBuilt 1980 · S/N 28-8090252 N8163SDilouis Andre J · West Deptford, NJBuilt 1980 · S/N 28-8016277 N8163THeuschele Michael C · Foristell, MOBuilt 1980 · S/N 28-8090253 N8163YBachman David R · Chisago City, MNBuilt 1980 · S/N 28-8090254 N8165GSkychaser LLC · Green Brook, NJS/N 28-8216127 N81669Esteves Anthony · Hillsborough, NJBuilt 1980 · S/N 28-8016215 N8166BBouchard Dustin · Springfield, MOS/N 28-8216129 N81673Kcn Aero Club · Overland Park, KSBuilt 1980 · S/N 28-8090258 N8167FEximious Flying Club Inc · Ferndale, MIBuilt 1983 · S/N 28-8390073 N816PKSix Papa Kilo Aviation LLC · Savannah, GAS/N 28-8090334 N81713Brown Matthew · Spokane, WABuilt 1980 · S/N 28-8016290 N81715Registration Pending · Hanford, CARegistration pendingS/N 28-8016291 N8171YFaith Works Aviation LLC · Glenmoore, PABuilt 1980 · S/N 28-8016284 N8172NBeasley Michael Jeffrey · Dothan, ALS/N 28-8090261 N8172QFrost Aviation Services Inc · Las Cruces, NMBuilt 1980 · S/N 28-8090263 N8172ZAverka Steven D · Sutton, MABuilt 1980 · S/N 28-8090264 N81741Corsican Aviation LLC · Westfield, INBuilt 1980 · S/N 28-8090134 N81749Friend Aircare Inc · Washington, PABuilt 1982 · S/N 28-8290107 N8175HHowe Richard B · San Luis Obispo, CABuilt 1980 · S/N 28-8016292 N81771Skyfusion II LLC · Atlanta, GABuilt 1980 · S/N 28-8090269 N8177HBrady Jeffrey L · Portland, ORS/N 28-8016364 N8179GBald Air Inc · Huntington Station, NYBuilt 1980 · S/N 28-8016297 N8179HSam Air LLC · Daphne, ALBuilt 1982 · S/N 28-8216138 N8179XSkybound Aviation LLC · Kernersville, NCBuilt 1982 · S/N 28-8290109 N817ACCannon Air Force Base - Aero Club · Clovis, NMBuilt 2003 · S/N 2842190 N817GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881465 N817NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881047 N817TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881594 N81809Corporation Of The Catholic Archbishop Of Anchorag · Anchorage, AKBuilt 1980 · S/N 28-8016221

Back to AD 2016-07-21