Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N2235BConner W Larry · Los Lunas, NMBuilt 1978 · S/N 28-7916120 N2235CAnderson Nick A · Cynthiana, KYBuilt 1978 · S/N 28-7911024 N2235ZWilson James F Jr · Williamstown, KYS/N 28-7921021 N22363Barnes Welding Inc · Waterville, WABuilt 1978 · S/N 32R-7887258 N2236CAlexander James E Jr · Fort Worth, TXBuilt 1978 · S/N 28-7911025 N2236GParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916215 N2236MC6 Aviation LLC · Hoboken, NJBuilt 1977 · S/N 32R-7880054 N2236WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916337 N2236ZRoukema James E · Pueblo, COBuilt 1979 · S/N 28-7921022 N22370Top Flight Sales Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887259 N2237AKimber 123 Holdings LLC · Morgantown, WVBuilt 1978 · S/N 32R-7987016 N2237KCarolina Air LLC · New London, NCBuilt 1978 · S/N 28-7916232 N2237QJenkins John E Jr · Long Valley, NJBuilt 1979 · S/N 28-7911107 N2237TSchmelzle Michael O · Shrewsbury, MOBuilt 1979 · S/N 28-7916302 N2238GRupp Aviation LLC · O Fallon, MOBuilt 1979 · S/N 28-7990418 N2238ZHaines Ranch · White Lake, SDBuilt 1979 · S/N 28-7921024 N2239TErwin Chris L · Carson City, NVS/N 28-7125629 N2239ZAsc Air LLC · Neligh, NEBuilt 1979 · S/N 28-7921025 N223GHMeridian Aircraft LLC · Wilmington, DES/N 2881542 N223JDFlynt Kevin D · Decorah, IAS/N 28R-7803042 N223MDPremier Engineering Inc · San Antonio, FLBuilt 1974 · S/N 32-7440154 N223WDGilliam Preston T · Philadelphia, PABuilt 1964 · S/N 28-20366 N223WWSan Diego Flight Training Inc · San Diego, CABuilt 1978 · S/N 28R-7837251 N223YZMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881536 N223ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881608 N2240BK & D Dakota LLC · Avon, OHBuilt 1978 · S/N 28-7911015 N2240GThunderbird Aircraft Company · Bloomington, MNBuilt 1978 · S/N 28-7916217 N2240KBurnet David A · Quinton, ALBuilt 1978 · S/N 28-7916233 N2240TJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1971 · S/N 28-7125625 N22419Gehres Shawn E · Enterprise, ALBuilt 1978 · S/N 32R-7885270 N2241BHanneman Michael W · Abilene, TXBuilt 1978 · S/N 32R-7985018 N2241GOwens Wilbur · Rch Palos Vrd, CABuilt 1978 · S/N 28-7990229 N2241KFlickinger Charles · Hermitage, PABuilt 1978 · S/N 28-7916236 N2241NBell Michael C · Sammamish, WABuilt 1979 · S/N 28R-7918043 N2241WRonlin Inc · Kissimmee, FLBuilt 1979 · S/N 28-7916338 N2241YHenault Benjamin · Archdale, NCBuilt 1979 · S/N 28-7990386 N2242FKoester Thomas C · West Chester, PABuilt 1978 · S/N 28-7911059 N2242NSt Louis Flying Club Inc · Ellisville, MOBuilt 1979 · S/N 28R-7918044 N2242ZN2242z LLC · Newtown, CTBuilt 1979 · S/N 32-7940114 N2243FDavenport Mark B · Placentia, CABuilt 1978 · S/N 32R-7987071 N2243NBarclay Alexander C · Seattle, WABuilt 1979 · S/N 28R-7931052 N2243PEasterling Richard V DBA · Berkeley, CABuilt 1979 · S/N 28-7990295 N2243ZWashington Israel · Cincinnati, OHBuilt 1979 · S/N 28R-7931189 N22446Ag Care Inc · Apopka, FLS/N 32R-7887260 N2244MParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7816261 N2244QField George Jr · Overton, NVBuilt 1979 · S/N 32R-7987107 N2244VSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1979 · S/N 28-7916329 N2244ZGood Timothy · Waxhaw, NCBuilt 1979 · S/N 32-7940110 N22450Red Mountain Express Care LLC · Queen Creek, AZBuilt 1978 · S/N 32R-7887261 N2245ANo Limits Aviation Group LLC · Louisville, KYBuilt 1978 · S/N 32R-7887285

Back to AD 87-08-08 R3