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.

N8241ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316079 N8244UFaherty Michael F · Greensboro, NCBuilt 1980 · S/N 28-8016371 N8245CVector Aviation LLC · Mentor, OHBuilt 1980 · S/N 28-8090372 N8246EDubois Aviation Inc · Chino, CABuilt 1982 · S/N 28-8216189 N8247CPonder Harvey E · Knoxville, ILBuilt 1982 · S/N 28-8290158 N82487Woodruff Thomas C · Pacific Grove, CABuilt 1980 · S/N 28-8116007 N8248TJefferson City Aviation Inc · Jefferson City, MOBuilt 1980 · S/N 28-8116003 N8249BEscobar Alfredo · Canyon Country, CAS/N 28-8116008 N824BBBig Bend Community College · Moses Lake, WABuilt 2023 · S/N 2881695 N824DXElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 28-7990061 N824NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881291 N824PAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 2881336 N824VRDodson International Parts Inc · Rantoul, KSBuilt 1996 · S/N 2843058 N8251SAirlife Aviation LLC · Elkridge, MDS/N 28-8316081 N8252EMiami Flight Training LLC · Miami, FLBuilt 1980 · S/N 28-8016373 N8252ZHodges Albert H Executor · Lyons, GAS/N 28-8116011 N8253AArcher N8253a LLC · Orange, CTBuilt 1980 · S/N 28-8190013 N8254JParis Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216186 N82554Garnet Aviation LLC · Fort Worth, TXBuilt 1982 · S/N 28-8290160 N82557Zehm Laura L · Monterey, CABuilt 1982 · S/N 28-8290161 N8256EWilliams Evan H · Sebastopol, CABuilt 1980 · S/N 28-8116014 N8256VZ-Tech Research LLC · Greenville, TXBuilt 1980 · S/N 28-8116018 N8256XSkyriders Inc · Pocatello, IDBuilt 1980 · S/N 28-8190016 N8257GDraco Flight School Inc · Chino, CABuilt 1982 · S/N 28-8290162 N8258LWiesner Loren A Jr · Cameron, WIBuilt 1980 · S/N 28-8116022 N8258NK&G Transit LLC · Fort Mc Coy, FLBuilt 1980 · S/N 28-8116023 N8259BDunn Patrick E · Marthasville, MOBuilt 1980 · S/N 28-8190021 N8259TNsa Ops LLC · Kahului, HIBuilt 1980 · S/N 28-8190024 N825PBPalm Beach Aircraft Services Inc · Lantana, FLS/N 28-7890442 N8260VRed Rifle Aviation LLC · Richmond, TXBuilt 1980 · S/N 28-8116029 N8260YNew Peach Aviation LLC · Brooks, GABuilt 1980 · S/N 28-8116031 N8261FDaniels Neil Alan · Balaton, MNS/N 28-7790235 N8261HOxford Flying Club Inc · Oxford, CTBuilt 1980 · S/N 28-8190025 N8261SHoffmann David M · Mauston, WIBuilt 1980 · S/N 28-8190027 N82629Dgf & Associates Inc · Irving, TXS/N 28-8216225 N8262ASnider Jay T · Grove City, OHBuilt 1980 · S/N 28-8116033 N8262ESee Robert W · Catawba, NCBuilt 1980 · S/N 28-8190033 N8262HRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1980 · S/N 28-8190034 N8262KHesston College · Hesston, KSBuilt 1982 · S/N 28-8290165 N8262SWisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1980 · S/N 28-8190035 N8262UHorton Air Ventures LLC · Eustis, FLBuilt 1980 · S/N 28-8190036 N8264VRuby Jeffrey Steven · Sharon, SCBuilt 1980 · S/N 28-8116035 N8265CDelgado Francisco Trustee · Carmel, INBuilt 1980 · S/N 28-8190037 N8265HSlinger LLC · Laramie, WYBuilt 1980 · S/N 28-8190039 N82676Accelerated Aviation Instruction LLC · Owatonna, MNBuilt 1980 · S/N 28-8116043 N8268BMarinko Christopher M · Geneva, OHBuilt 1980 · S/N 28-8190040 N8268CJk Aviation LLC · Austin, TXBuilt 1980 · S/N 28-8190041 N8268HAirtime Aviation LLC · Chippewa Falls, WIS/N 28-8190043 N8269ZMcelveen Thomas G Jr · Springfield, GABuilt 1980 · S/N 28-8116039 N826TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881705

Back to AD 2016-07-21