Skip to content

Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N4293UKelly Reginald David · Morehead City, NCBuilt 1964 · S/N 15060293 N42941Nistler Steve W · Helena, MTS/N 18259259 N42947N42947 LLC · Panama City, FLBuilt 1968 · S/N 18259262 N42949Niemeyer Donald C DBA · Hobart, INBuilt 1968 · S/N 18259263 N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194 N4294VDekryger John · Fremont, MIBuilt 1948 · S/N 18652 N42951Tiedt Randy · Parkville, MOBuilt 1968 · S/N 18259264 N42955Brown Donald E Jr · Jonesboro, ARS/N 18259265 N42958Havasa Enterprises LLC · Sisters, ORBuilt 1973 · S/N 18052389 N4295LBravo Aviation LLC · Rexburg, IDBuilt 1966 · S/N 17254364 N42967Brook Daniel L · Marshall, INBuilt 1968 · S/N 18259269 N42968Jelinek Spencer T · Erie, COBuilt 1973 · S/N 18052390 N4296FMargraf Todd R · Miamisburg, OHBuilt 1958 · S/N 46196 N4296LBreidenbach Todd J · Sabin, MNBuilt 1966 · S/N 17254365 N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196 N42972Anderson Mike D · Mc Alpin, FLBuilt 1968 · S/N 18259271 N42974Tracy Lanning Construction LLC · Westminster, SCBuilt 1968 · S/N 18259272 N4297547q LLC · Eau Claire, WIBuilt 1968 · S/N 18259273 N4297QCritchfield David P · Paradise, CAS/N 17260197 N4297UMondrik Michael R · Blessing, TXS/N 15060297 N42980Friday Dale C · Santa Cruz, CABuilt 1968 · S/N 18259274 N4298FGunn Sean · Colorado Springs, COBuilt 1958 · S/N 46198 N4298QDarrach Todd I · Rhome, TXS/N 17260198 N4299FRomano Louis A · Middletown, NJBuilt 1958 · S/N 46199 N4299UJohnson Daniel P · Williamsburg, IAS/N 15060299 N429BASchmidt John M · Palm Coast, FLS/N 17702654 N429DLLandset David J · West Palm Beach, FLBuilt 1975 · S/N 21060649 N429PCShanks Charles Scott · Edmonds, WAS/N 18051629 N42APMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1977 · S/N 17269941 N42AVIsland Aero LLC · East Northport, NYBuilt 1982 · S/N 18268267 N42BHDondelinger Consulting LLC · Brainerd, MNS/N 18268199 N42CMMazor Chris · Belleville, MIS/N 17266374 N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228 N42EMNbc Sales LLC · Somerville, TNBuilt 1967 · S/N 18258542 N42EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 1965 · S/N 15061252 N42GBShackelford Fran · Plano, TXS/N P3370304 N42GVBlahnik Vance Thomas Trustee · Eden Prairie, MNBuilt 1978 · S/N R18200219 N42JAJersey Aero Club Inc · Lakewood, NJBuilt 1976 · S/N 17267383 N42KCChatham Kenneth W · Montross, VABuilt 1968 · S/N 18259044 N42RHGet-U-There Air LLC · Poplar Grove, ILBuilt 1979 · S/N 18266776 N42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172RG0703 N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667 N42WDRegistration Pending · Seattle, WARegistration pendingBuilt 1972 · S/N 18261403 N42WGEl Paso Industries Inc · Santa Teresa, NMBuilt 1969 · S/N 18259414 N4300QFarwell Christopher J Trustee · Olympia, WABuilt 1973 · S/N 18502232 N4300RCab Air Inc · Columbia, NJBuilt 1974 · S/N 17263054 N4301BCff LLC · Kalispell, MTBuilt 1955 · S/N 26645 N4301QSchneider Frederick I · Sault Sainte Marie, MIBuilt 1971 · S/N 17260201 N4301RMeggers Roger D · Baker, MTBuilt 1974 · S/N 17263055 N4302LSenn Steve E · Burwell, NEBuilt 1966 · S/N 17254371

Back to AD 87-20-03 R2