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.

N8032CAirwego LLC · Wilmington, DEBuilt 1975 · S/N 28-7690097 N80368Registration Pending · Augusta, KSRegistration pendingBuilt 1981 · S/N 28-8216085 N80441Archer Aircraft LLC · Wilmington, DEBuilt 2019 · S/N 2881235 N8044TArcher Aircraft LLC · Wilmington, DEBuilt 2019 · S/N 2881234 N8051VAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2021 · S/N 2881106 N8052TAtd Pilot Training LLC · Kansas City, MOBuilt 1981 · S/N 28-8216091 N8054SMccrea Stephen M · Eatonton, GABuilt 1981 · S/N 28-8290077 N8055CSea 2 Sea LLC · Cantonment, FLS/N 28-7690099 N8055VSandler Sergey · Golden Beach, FLBuilt 1981 · S/N 288290078 N8059RTravel Express Aviation LLC · West Chicago, ILBuilt 1981 · S/N 28-8290081 N805AMOrtega Aviation Services LLC · Wichita, KSBuilt 2021 · S/N 28020036 N805MAKpanda Aviation LLC · Peoria, ILBuilt 2022 · S/N 2881585 N8060USluka Christopher J · San Diego, CABuilt 1981 · S/N 28-8290083 N8063CHigh Planes Aviation LLC · Goodland, KSBuilt 1975 · S/N 28-7690100 N8064XDodson International Parts Inc · Rantoul, KSBuilt 2022 · S/N 2881516 N8068CThunderbird Aircraft Company · Bloomington, MNBuilt 1981 · S/N 28-8216099 N8068JGo Vertical Aviation LLC · Russellville, ALBuilt 1981 · S/N 28-8290084 N8068ZBasco John J · Pottstown, PABuilt 1981 · S/N 28-8290086 N806NDMob Aviation USA LLC · Auburndale, FLBuilt 1988 · S/N 2837009 N8071SNolan Cynthia M · Rimrock, AZBuilt 1981 · S/N 28-8216102 N8071XFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28-8216103 N8071YFrost Aviation Services Inc · Las Cruces, NMBuilt 1981 · S/N 28-8216104 N8071ZScanlon Daniel T Jr · East Greenwich, RIBuilt 1981 · S/N 28-8290087 N80731Herman Robert W · Vineyard Haven, MABuilt 1981 · S/N 28-8290089 N8074TWilliams Evan H · Sebastopol, CABuilt 1979 · S/N 28-8090062 N80756Badeaux William C Jr · La Porte, TXBuilt 1979 · S/N 28-8016047 N8075CGuest Stephen J · El Cajon, CABuilt 1979 · S/N 28-8090064 N8075EBlue Sky Flying Club LLC · Granger, IABuilt 1979 · S/N 28-8090065 N8075XBruce Jerry W II · Starkville, MSBuilt 1979 · S/N 28-8016044 N80765Taylor Kyle T · Texas City, TXS/N 28-8016045 N80769Tucker Robert O · Savannah, GABuilt 1979 · S/N 28-8090066 N8077H8077h LLC · Southington, CTBuilt 1979 · S/N 28-8090067 N8077QWakefield Robert · Toccoa, GABuilt 1979 · S/N 28-8090069 N8077RIscovich Mario S · Thousand Oaks, CABuilt 1979 · S/N 28-8090070 N8077WN8077w Inc · Bloomfield Hills, MIBuilt 1979 · S/N 28-8090072 N80785Campbell Air LLC · Angola, INBuilt 1979 · S/N 28-8090077 N8078RKhozam George · Murrieta, CABuilt 1979 · S/N 28-8090073 N8078ZL & A Bennett Second Family Lp · Renton, WAS/N 28-8090076 N8079YKaszuba Peter M · Bradenton, FLBuilt 1979 · S/N 28-8016049 N807DAMays Gloriaj · College Station, TXBuilt 1977 · S/N 28-7816227 N807MSGilbert Allyn E · Grass Valley, CABuilt 1988 · S/N 2837010 N807TFAir Fleet Holdings LLC · Addison, TXBuilt 2024 · S/N 2881700 N8080AChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016051 N8080UMaas Justin J · Columbus, INBuilt 1977 · S/N 28R7737056 N8081GGonzalez Biorky · Atoka, TNBuilt 1979 · S/N 28-8016053 N8081PCraner Andrew · Richfield, IDBuilt 1979 · S/N 28-8016056 N8082HWalters Glenn L · Triadelphia, WVBuilt 1979 · S/N 28-8016059 N8082KWood Roger E · Waxhaw, NCBuilt 1979 · S/N 28-8016060 N8083LLoofbourrow Eric A · Livermore, CAS/N 28-8090080 N8084NBlack Tie Limousine LLC · Springville, ALBuilt 1981 · S/N 28-8290090

Back to AD 2016-07-21