OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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
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:2000-23-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:2000-23-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.

N3659YPeterson Laurel R · Hart, MIBuilt 1963 · S/N 21058159N365ACEvalidate LLC · Birmingham, MIBuilt 1988 · S/N EA-479N365AFFna Aviation LLC · Wakefield, MABuilt 2022 · S/N 8910N365BMiles Barrington K · Austin, TXBuilt 1957 · S/N D-4995N365CVAmg Leasing LLC · San Jose, CABuilt 2020 · S/N 2148N365FCRegistration Pending · Kalispell, MTRegistration pendingBuilt 1973 · S/N 18502233N365HStavair LLC · Gulf Breeze, FLBuilt 1965 · S/N TC-843N365HGPenrose Management LLC · Morristown, TNBuilt 2019 · S/N 1885N365JPFlycirrus LLC · Clermont, FLBuilt 2008 · S/N 3010N365KAWorker Bees LLC · Kaukauna, WIS/N 3381N365KSKilo Sierra LLC · Denver, COBuilt 2021 · S/N 2465N365MBAmg Aviation LLC · Marlton, NJBuilt 2016 · S/N 4349N365PMValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 3081N365RVTwin Oaks Aviation Inc · Pipersville, PAS/N E-1840N365SCalex Ventures LLC · Missoula, MTBuilt 2023 · S/N 9390N365SBClear Skys LLC · O Fallon, ILBuilt 2013 · S/N E-4010N365STHalcyon Capital Holdings LLC · Morgantown, GABuilt 2025 · S/N 10922N365TCTde Aviation LLC · Raleigh, NCBuilt 2022 · S/N 8900N365TGSuperior Transportation LLC · Belcamp, MDBuilt 2022 · S/N 8618N365WDIsaiah4031 LLC · Santa Rosa Beach, FLBuilt 2014 · S/N 4042N365XArmstrong Stefanie M · Anchorage, AKBuilt 1976 · S/N 6173CN3661CAas LLC · Ovid, MIBuilt 1954 · S/N 31160N3661HHamer Robert E · Beaumont, TXBuilt 1980 · S/N 25-0440N3661TOmega 1 Corp · Middletown, DEBuilt 1958 · S/N 51001N3661UGlenney Christopher · Milan, NHBuilt 1963 · S/N 18255061N3662UBenter Wayne D · Crosby, NDBuilt 1963 · S/N 18255062N3663HGould Ryan · Girdwood, AKBuilt 1980 · S/N 25-0441N3663KEvans And Evans Properties Inc · Santa Cruz, CABuilt 1980 · S/N EA-84N3663QOmalley Edward · Boulder, COBuilt 1980 · S/N E-1691N3663UWilliams James R · Austin, TXBuilt 1963 · S/N 18255063N3663YBrown Robert Scott · Troutman, NCBuilt 1963 · S/N 21058163N3664GMarshmont Aviation LLC · Greenville, SCS/N TJ-280N3664MEchtle Keith A · Castroville, TXBuilt 1978 · S/N 28R-7803184N3664TJdm Aviation LLC · Marceline, MOBuilt 1980 · S/N E-1692N3664UAir Skylane LLC · Boulder, COBuilt 1963 · S/N 18255064N3664YWindswept Aviation LLC · North Canton, OHBuilt 1980 · S/N E-1693N3665UBlue Skies Aviation Of Wi Inc · Pulaski, WIS/N 18255065N3665YJ & B Airlift LLC · Rupert, IDBuilt 1963 · S/N 21058165N36664Strauss Steven Trustee · Tempe, AZBuilt 1980 · S/N EA-89N36665Flynn Michael · Weybridge SurreyBuilt 1980 · S/N E-1696N3666ASandow Dean · Scappoose, ORBuilt 1969 · S/N E-190N36673Gta Air Inc · Addison, TXBuilt 1980 · S/N TH-1143N36674Brown Kile Executor · Dallas, TXBuilt 1965 · S/N 18256440N3667DBpm Rentals Inc · Lincoln, CABuilt 1956 · S/N 35367N3667YAir Wake Aviation LLC · Hazelwood, MOBuilt 1963 · S/N 21058167N3668CN3668c L L C · Depauw, INBuilt 1954 · S/N 31167N3668DLkj Holdings LLC · Amarillo, TXS/N EA-92N3668URedmond John L · Santa Clarita, CABuilt 1980 · S/N E-1701N3669Grasso Vaughn L · Oak Hill, FLBuilt 1970 · S/N JPH-2N36696Ovajet Group Inc · Miami, FLBuilt 1978 · S/N 34-7870353
Back to AD 2000-23-21