OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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.

N320DGSrs 320 LLC · Houston, TXBuilt 2023 · S/N 9402N320DRMontgomery Machine LLC · Guilford, CTBuilt 2005 · S/N 42064N320EBKenmore Crew Leasing Inc · Bellingham, WABuilt 2025 · S/N 10744N320ETVdv Properties LLC · Bend, ORBuilt 2014 · S/N 0792N320FWMurrell James F · Douglas, AZBuilt 1967 · S/N 320F-0018N320HHartwell John E · Pleasanton, CABuilt 1964 · S/N 320B0060N320JBIce II Cody W · Houston, MOBuilt 1964 · S/N 320C0019N320JKTru-Point Tactical LLC · Columbia, MSBuilt 1966 · S/N 320E0048N320JZBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 320-0051N320KChisum Robert W · Lorenzo, TXS/N 320-0018N320MSConsulat Inc · Cheyenne, WYBuilt 1966 · S/N 320E-0065N320PCAom Aircraft LLC · Wilmington, DES/N 402B0621N320PGJuliet Delta Mike Aviation LLC · Erie, COBuilt 2007 · S/N 1878N320PPIpock Brian P · Tulsa, OKS/N 320B0018N320RDBurwell Michael · W Bloomfield, MIBuilt 1963 · S/N 320B0035N320RLLast Flight Out LLC · Brentwood, TNBuilt 2006 · S/N 1854N320RMRd Harrison Inc · Lexington, NCS/N 340A0939N320RRHighway Aero LLC · Bristow, VABuilt 2002 · S/N 0358N320SKDevries James E · Bejou, MNBuilt 1967 · S/N 320E-0077N320SWEast West Investment Advisors LLC · Sandy Point, VABuilt 1980 · S/N 414A0451N320TJBlaylock Arthur S III · Pace, FLBuilt 1963 · S/N 320B0017N320WDAt Liberty LLC · Apple Valley, MNBuilt 1974 · S/N TH-426N3210PKilcullen Brian DBA · Fort Lauderdale, FLBuilt 1978 · S/N P21000027N3210SGore Range Aviators LLC · Kremmling, COBuilt 1964 · S/N 18255710N3210UHaas Todd · Pecatonica, ILBuilt 1963 · S/N 18254610N3210YBergren William · Des Moines, IABuilt 1962 · S/N 18254210N3211DNielson Donald L · Independence, ORBuilt 1955 · S/N 32009N3211LPrevost Bryan · Lambert, MTBuilt 1976 · S/N D-9914N3211SNoble Tom R · Winnsboro, TXBuilt 1964 · S/N 18255711N3211YFour M Properties LLC · Prague, OKBuilt 1962 · S/N 18254211N3212DHalo Aviation Corp · Wilmington, DES/N EA-651N3212GGibby Aviation Inc · Wilmington, DEBuilt 1994 · S/N EA-569N3212MKietzer Farms LLC · Wilmington, DEBuilt 1991 · S/N CE-1552N3213DMountaingales LLC · Phoenix, AZBuilt 1998 · S/N E3213N3213SRosengrants Matthew R · Walsh, COBuilt 1964 · S/N 18255713N3213YFletcher Jerry D · Yukon, OKBuilt 1962 · S/N 18254213N3214RLima Delta Co Trustee · New Castle, DEBuilt 1994 · S/N CE-1790N3214UBibus Michael A · Austin, MNBuilt 1963 · S/N 18254614N3214ZYounger Aviation LLC · Poteau, OKBuilt 1994 · S/N E-2911N3215DSchlund James F · Chico, CABuilt 1994 · S/N E-2912N3215UAileron T LLC · Orlando, FLBuilt 1994 · S/N E-2915N3216MN3216m Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0826N3216QSoma 1953 LLC · Arcadia, FLBuilt 1977 · S/N 28R-7703097N3216ZMy Fly LLC · Wilmington, DES/N E-2922N3217EDavis Darren · Flint, TXBuilt 1995 · S/N E-2926N3217MN3217m LLC · Polson, MTBuilt 2000 · S/N E-3317N3217SGrotbeck Christopher L · Albuquerque, NMBuilt 1964 · S/N 18255717N3217UWelkin Aero Inc · Garden Plain, KSBuilt 1975 · S/N 18502738N3217YBrowne Robin P · Dallas, TXBuilt 1962 · S/N 18254217N3218DWright James Cope · Round Rock, TXBuilt 1955 · S/N 32016
Back to AD 2000-23-21