Skip to content

Registered aircraft · 5,462

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.

N204NDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2002 · S/N 2844070 N2052MDehnel Kris P · Cedar Park, TXS/N 28-7890222 N2054MMcdonald Patrick R · Waverly Township, PABuilt 1977 · S/N 28-7890223 N2055MHarding Lawrence · Santa Monica, CABuilt 1977 · S/N 28R-7837063 N205FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020205 N205THAaces Flight Operations LLC · Ellisville, MOBuilt 1981 · S/N 28-8190282 N205ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881606 N2069MSeton Perry · Casper, WYBuilt 1977 · S/N 28-7816247 N2070MD&L Aviations LLC · Breckenridge, TXBuilt 1977 · S/N 28-7890226 N2071MBudd Aircraft Enterprises Inc · Chesterfield, MOBuilt 1977 · S/N 28R-7837064 N2073MHanel David Matthew · Suwanee, GAS/N 28R-7837065 N20784Dbab LLC · Belleville, ILBuilt 1978 · S/N 28-7990025 N2078ARyan John T · Salina, KSBuilt 1978 · S/N 28R-7837315 N207ABCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841284 N207CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881001 N207ESPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020254 N2080VMcguire Rental Properties LLC · Prescott, ARBuilt 1979 · S/N 28-7916322 N2081CTrident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7916128 N2085VForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28-7990337 N20864Dishart Bradley E · Gibsonia, PABuilt 1978 · S/N 28-7990026 N20873Mang Aero Club · Belleville, MIBuilt 1978 · S/N 28-7990027 N2087NRls Rental Co DBA · Joplin, MOBuilt 1979 · S/N 28-7916253 N2088AGary Jet Center · Gary, INBuilt 1978 · S/N 28-7916092 N2088BGeneral Aviation Support Corp · Rosamond, CABuilt 1978 · S/N 28-7916108 N2088DNationwide Aviation LLC · Hudson Oaks, TXS/N 28-7916140 N2089NSchroeder Reinhard · Poulsbo, WABuilt 1979 · S/N 28-7916255 N208GGPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1975 · S/N 28-7690073 N2090VWater Sports Unlimited · Griffin, GABuilt 1979 · S/N 28-7990339 N2091BRegistered aircraftBuilt 1978 · S/N 28-7990117 N2091DRegistration Pending · Magnolia, TXRegistration pendingBuilt 1978 · S/N 28-7916141 N2091MGreat Planes Aviation Inc · Rochester, MNS/N 28-7816249 N2092AKimmons Anthony J · Quitman, TXBuilt 1978 · S/N 28-7916094 N2092MRegistration Pending · Augusta, KSRegistration pendingS/N 28-7816250 N2092XAirx LLC · Warwick, RIBuilt 1979 · S/N 28-7916342 N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228 N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020 N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242 N2097MDm Asset Management LLC · Plain City, OHS/N 28-7890229 N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257 N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311 N20985Aero X Flying Club Inc · Winchester, VAS/N 28-7990029 N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179 N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030 N209JRegistered aircraftBuilt 1982 · S/N 28-8216153 N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032 N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119 N20QCHenderson Stephen L · Carthage, NCBuilt 1977 · S/N 28-7890227 N20SALc Air Leasing LLC · Treasure Island, FLBuilt 1976 · S/N 28-7690337 N20TACopperstone Fc LLC · Lancaster, PABuilt 2010 · S/N 2843677 N2102CGreat Northern Aircraft Inc · Griffith, INBuilt 1978 · S/N 28-7916130

Back to AD 2016-07-21