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.

N1731WCollins Air LLC · Kennett, MOBuilt 1972 · S/N E-369N1732MCarey International Aviation Services LLC · Long Beach, NYBuilt 1970 · S/N 33701332N1733GAlpine Aviation Inc · Mclean, VABuilt 1962 · S/N D-6949N1733RNorthstar Holdings LLC · Anchorage, AKBuilt 1973 · S/N U20602068N1734GJ-Bird Air Service LLC · Cheyenne, WYBuilt 1962 · S/N TC-275N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735N1734XRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1975 · S/N 21060755N1735ERsc Ventures LLC · Phoenix, AZBuilt 1978 · S/N 310R1555N1735GFeldhaus Joseph H · Shelbyville, TNBuilt 1962 · S/N CD-489N1735MG & M Aircraft Inc · Wheat Ridge, COBuilt 1975 · S/N 18264421N1736CThompson Frank L · Weiser, IDBuilt 1953 · S/N 30436N1736WAmbitious Aviation LLC · Newport News, VABuilt 1972 · S/N D-9403N1737BDiaz Juan B III · Portland, ORBuilt 1972 · S/N D-9405N1737CBristol Brian P · Webster, MNBuilt 1953 · S/N 30437N1737EKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1556N1737GBraly John E · Surprise, AZBuilt 1962 · S/N D-6948N1737MClinton Aviation Corp · Clinton, ARBuilt 1975 · S/N 18264423N1738GSchneider Joel A · Cerrillos, NMBuilt 1962 · S/N D-6950N17396Eckel Kenneth P Jr · Santa Fe, TXBuilt 1951 · S/N 22135N1739COpp Daniel · Anchorage, AKBuilt 1953 · S/N 30439N173CBAircraft Associates LLC · Valparaiso, INBuilt 2006 · S/N 1877N173CKKali Equipment 2 LLC · Burlingame, CABuilt 2018 · S/N 1727N173DSanford Mark J · Ithaca, NYBuilt 1964 · S/N TC-825N173KHD & B Management LLC · Clayton, GABuilt 2004 · S/N 1191N173KTCrawford Chris M · North Dinwiddie, VAS/N 40035N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960N173QLively Scott Jacob Charles · Greenbrier, ARBuilt 1964 · S/N D-7350N173SRRomeo Pappa LLC · Midlothian, TXBuilt 2006 · S/N 1925N173TAughenbaugh Timothy A · Iroquois, SDS/N D-8259N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781N173WMBoard Of Trustees Of Western Michigan University · Battle Creek, MIS/N 1739N1740GOelrich Matthew Alan · Concord, CABuilt 1962 · S/N CD-490N1740WCarlsbad Raceway Corp · Hemet, CABuilt 1972 · S/N CD-1302N1741CWitt William A · Ennis, MTBuilt 1953 · S/N 30441N1741MWolfehagen Paul B · Phoenix, AZS/N 33701341N1742ECole-Tac LLC · Rapid City, SDBuilt 1978 · S/N 310R1558N1742GLoftus Kevin · Pasadena, CABuilt 1962 · S/N CD-467N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763N1743GYoung Harrison · Phoenix, AZBuilt 1962 · S/N TC-278N1743RChronicle Aerospace Inc · Wilmington, DEBuilt 1974 · S/N 18502463N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404N1744GWelsh Ayden · Dayton, OHBuilt 1962 · S/N D-6953N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765N1745RFiske James K · North Andover, MAFirst renewal noticeBuilt 1974 · S/N 18502465N1745WThoroughscape Inc · Wellington, FLBuilt 1972 · S/N CE-409N1746CGreen Gary Dale · Mccarthy, AKBuilt 1953 · S/N 30446N1746GFrasier Samuel · Gainesville, FLBuilt 1962 · S/N D-6952N1746ZThompson Nathan G · San Antonio, TXS/N 336-0046N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666N1747CConatser Patrick M · Homeland, CABuilt 1953 · S/N 30447
Back to AD 2000-23-21