OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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.

N14DRRandall Adam M · Doylestown, PABuilt 1980 · S/N TC-2310N14EXSorpresa LLC · Salem, ORS/N 15N14FMDurbin Gregory M · Dallas, TXS/N D-7802N14FZWurzer Frank · Tallmadge, OHBuilt 1978 · S/N 34-7870122N14JDC340-340 LLC · Pinckney, MIBuilt 1974 · S/N 340-0340N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792N14JHRegistered aircraftBuilt 1998 · S/N TH-1845N14JMMckinstry Aviation LLC · Parker, COBuilt 1974 · S/N 18052475N14JNNational Test Pilot School · Mojave, CABuilt 1975 · S/N 34-7570254N14JPDakota Aircraft Inc · Pierre, SDBuilt 1986 · S/N CJ-177N14KCAviation Engineering Technical Services Inc · Savannah, GABuilt 1979 · S/N 28R-7931082N14KEJust Got Real Cirrus LLC · Lake Havasu City, AZBuilt 2008 · S/N 3252N14LKKellner Ken J · Neenah, WIBuilt 2007 · S/N LIV-496N14LRGolly Laura · Deridder, LABuilt 1974 · S/N E-524N14LVSmetana Louis V III · Blair, NEBuilt 1970 · S/N 21059259N14MBJackson Craig D · Idaho Falls, IDBuilt 1977 · S/N E-1062N14MCBlue Skies Blue Water LLC · Henderson, NVBuilt 1964 · S/N 320C0008N14MDDaniel Development LLC · Durango, COBuilt 1962 · S/N 18254114N14MKBurdzy Christopher · Alton, NHBuilt 2006 · S/N 1801N14MRMarlin Aviation Flying Service LLC · West Palm Beach, FLBuilt 1972 · S/N 33701459N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14PGI3 Cirrus Holding LLC · Houston, TXBuilt 2019 · S/N 1852N14PHHuman Lee · Mercer Island, WABuilt 1981 · S/N 18504323N14PLByers Steven · San Diego, CABuilt 1966 · S/N 18051711N14PNNefas Paul J · Sunland, CABuilt 1977 · S/N R1722602N14RFBerry Darrel · Camden, TNBuilt 1973 · S/N E-486N14VCG5 LLC · Gallup, NMS/N 18264127N14VHValiair Ltd Co Trustee · Casper, WYBuilt 2001 · S/N 1115N14WHWaypoints LLC · Mesa, AZS/N 3109N14WKTiger Ventures LLC · Helena, MTBuilt 2006 · S/N 1758N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758N14YYNorthwoods Air LLC · Orono, MEBuilt 1972 · S/N 18261390N1500BElectrical Field Services Inc · Huffman, TXBuilt 1994 · S/N CE-1768N1500FGerhold Jeremy · Rosharon, TXS/N D-8552N1500G5 Lg LLC · Rome, GABuilt 1975 · S/N 414-0814N1500LLandolt Gregg E · Moreno Valley, CABuilt 1968 · S/N TC-1120N1500SCianchette R Scott · Hermon, MEBuilt 1961 · S/N D-6897N1500VTessem Rolfe S · Great Barrington, MABuilt 1970 · S/N D-9160N1501CUnderwriting Wave LLC · Woodland Hills, UTBuilt 2003 · S/N 0528N1501MMeszler Christopher P · Spring Branch, TXBuilt 1975 · S/N 18264354N1501STaylor Counsel LLC · Hoschton, GABuilt 1962 · S/N D-6898N1501VChinook Flying Club LLC · Chinook, MTBuilt 1976 · S/N R1722197N1501ZDaytona Aircraft Services Inc · Daytona Beach, FLBuilt 1961 · S/N D-6824N1502SMakiva Sasha · Sonoma, CAS/N D-6899N1502ZSmith Chad M · Danville, CABuilt 1961 · S/N D-6823N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228N1503ZMain Attraction LLC · Sioux Falls, SDBuilt 1961 · S/N D-6825N1505SBluboco LLC · Northville, MIBuilt 1962 · S/N D-7037N1505ZKc Air LLC · Wellford, SCBuilt 1962 · S/N CD-542
Back to AD 2000-23-21