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.

N252BSAlta Aviation LLC · Broomfield, COBuilt 1987 · S/N 25-1107N252BZJml Ventures LLC · Luverne, ALS/N 25-1168N252CAHuckabay John A · Coeur D Alene, IDS/N 25-1064N252CBVenture Aviation LLC · Spokane, WABuilt 2016 · S/N 1472N252CCLetsgobrandon.Com LLC · Pine Bush, NYS/N 25-1132N252CFBowman Douglas G Trustee · Santa Rosa, CAS/N 25-1129N252CGPlane Fun Inc Tr Trustee · Snellville, GAS/N 25-1033N252CNMcmanus Thomas M · Ridgefield, CTS/N 25-1146N252D252 Delta Inc · Atlanta, GABuilt 1986 · S/N 25-1014N252DBValiair Lc Trustee · Casper, WYBuilt 1989 · S/N 25-1199N252DCEhrick Richard T · Steamboat Springs, COBuilt 1983 · S/N 25-0785N252DKKristoferson David J · Georgetown, TXBuilt 1988 · S/N 251167N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242N252DPDream Flite LLC · Sarasota, FLBuilt 1973 · S/N TE-932N252DRGoudeau Lyle A · Scottsdale, AZS/N 25-1038N252DSSturgill Duell L · Staffordsville, KYS/N 25-1065N252EXiaowei Shi · Las Vegas, NVBuilt 1986 · S/N 25-1015N252EMMaidens Donald S · Novi, MIBuilt 1986 · S/N 25-1027N252FBKramer Vernon F · Eagle River, WIS/N 25-1131N252FDCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 10061N252FMHawk Unlimited LLC · Kalispell, MTBuilt 1986 · S/N 25-1028N252GBRedrockbluewater LLC · Moab, UTBuilt 1981 · S/N 25-0518N252GSWyoming Seaplanes LLC · Alpine, WYBuilt 1976 · S/N 18265179N252HMLeeds Stained Glass Co Inc · Leeds, ALS/N 25-1030N252HPFino Al Cielo LLC · Jacksonville, FLBuilt 1983 · S/N 18268320N252HWBeverly Robert E · Lewis Center, OHBuilt 1987 · S/N 25-1142N252JCRc Skywagon LLC · Miami, FLBuilt 1986 · S/N 25-1008N252JEEdlund Richard J · Lenexa, KSBuilt 1989 · S/N 25-1202N252JHStratton William A · Denton, TXS/N 25-1035N252JPInternational Air Services Inc Trustee · Carson City, NVBuilt 1987 · S/N 25-1127N252KCPatton Steven W · Fayetteville, ARS/N 30964N252KMRegistered aircraftS/N 25-1032N252LRigoulot James Paul · Fort Mill, SCBuilt 1986 · S/N 25-1019N252LMForest Restoration Inc · Philomath, ORBuilt 2013 · S/N 0543N252MDouglass Alloys LLC · Zanesville, OHS/N 25-1151N252MASbkb Aviation LLC · Henderson, NVBuilt 2006 · S/N 29-0425N252MBN252mb LLC · Lexington, KYBuilt 1986 · S/N 25-1022N252MCSwan And Associates Inc · Brockton, MABuilt 1986 · S/N 25-1023N252MEBadger Jerry D · Terre Haute, INBuilt 1986 · S/N 25-1025N252MKMurphy Thomas P · Camp Hill, PABuilt 1988 · S/N 25-1193N252MLTaykota Planes LLC · Mandan, NDS/N 25-1039N252MRRudolf Jonathan B · Farmington, NMBuilt 1986 · S/N 25-1034N252MSWilson James A · Manitowoc, WIBuilt 1986 · S/N 25-1044N252MXMcginney Franklin S · Junction, TXS/N 25-1049N252MZGrant Sean · Placentia, CAS/N 25-1051N252PDeck Air LLC · Kalamazoo, MIBuilt 2004 · S/N 1002N252PBNicholson Bob · Atascadero, CAS/N 25-1045N252PLOchoa Preston J · Lemoore, CABuilt 1986 · S/N 25-1077N252PRFlying Falcon Pllc · Hailey, IDBuilt 1986 · S/N 25-1053N252QJimmy Takes Flight LLC · Lake Havasu City, AZS/N 25-1178
Back to AD 2000-23-21