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.

N16SGWard James · Arroyo Grande, CABuilt 1957 · S/N 35591N16SWWilliams Robert S · Redmond, ORBuilt 1998 · S/N 066N16TKKane Thomas E · Mc Alpin, FLBuilt 2008 · S/N 82055N16VABs LLC · North Vernon, INBuilt 2003 · S/N 42008N16VVLaughlin R C Jr · Boerne, TXBuilt 1967 · S/N R1720058N16WDFront Run Investors LLC · Commerce, GABuilt 2017 · S/N 4552N16YBBolea Air Inc · Morgan Hill, CABuilt 1974 · S/N TC-1688N16YZBerit Merkab LLC · Monroe, NCBuilt 2020 · S/N 2075N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807N1700BJohnson David E · Blair, NEBuilt 1960 · S/N D-6358N1700CKrause Kade G · Jackson, MTBuilt 1953 · S/N 30400N1700MDeltahawk Engines Inc · Racine, WIBuilt 1970 · S/N 33701300N1701RM R Planes LLC · Redmond, WABuilt 1974 · S/N 18502423N1701WJagz Aviation LLC · Akron, OHS/N D-9394N1702CCork Dennis R · Soldotna, AKBuilt 1953 · S/N 30402N1702TDans Shop Inc · Montevideo, MNBuilt 1963 · S/N TC-527N1703MNesloney Thomas Jeffery · Hilltop Lakes, TXBuilt 1975 · S/N 18264417N1703WNeimeier Henry P · Bowling Green, KYBuilt 1971 · S/N D-9303N17040Prather Carl L · Gilroy, CABuilt 1976 · S/N 240N1704LCulver Marc D · Anchorage, AKS/N 10/6155N1704UKuspuk School District · Aniak, AKBuilt 1975 · S/N 20700304N1704WNiskanen Michael · Framingham, MABuilt 1972 · S/N TC-1486N1705GDavis Roger N · Cheshire, ORBuilt 1962 · S/N CD-479N1706GBarcenas Shawn · Weirsdale, FLBuilt 1962 · S/N TC-274N1706WHinton Bay Management LLC · Jackson, WYBuilt 1972 · S/N E-366N1707WRussell Marc R · Simi Valley, CABuilt 1972 · S/N E-367N1708CHaggard Roy A · Murrieta, CABuilt 1953 · S/N 30408N1708RHall Alan D Trustee · Big Bear Lake, CABuilt 1974 · S/N 18502430N1708WCassaday Jonathan A · Visalia, CABuilt 1964 · S/N D-7340N1708ZVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0008N1709CDmj Holdings LLC · Kalispell, MTBuilt 1953 · S/N 30409N170CDStrategic Leasing Investments And Consulting LLC · Madison, WIBuilt 2000 · S/N 1076N170DWarr Victor L · Star, IDBuilt 1951 · S/N 20194N170DLRlw 767 LLC · Lighthouse Point, FLBuilt 2006 · S/N 2017N170EJZirkel Acquisition Corp LLC · Colchester, VTBuilt 2010 · S/N 3604N170GKipp Robert C · Woodinville, WABuilt 1952 · S/N 20456N170HPKoven Mark Lee · Logan, UTBuilt 1975 · S/N CE-615N170HSAero Leasing LLC · Brandon, MSBuilt 1982 · S/N 34-8233164N170MWilliams John R Jr · Marfa, TXFirst renewal noticeBuilt 1966 · S/N D-8317N170PGCmt Aviation LLC · Corsicana, TXBuilt 2008 · S/N 1961N170PYYates James H · Edmond, OKBuilt 1951 · S/N 19949N170RCCbp Air Logistics LLC · Statham, GABuilt 2008 · S/N E-3829N170SGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2014 · S/N 4122N170SRSj Airways LLC · Wilmington, DEBuilt 2007 · S/N 2456N1710ABald Mtn LLC · Modesto, CABuilt 2016 · S/N TH-2462N1710CSmith Peter R · Lewistown, MTBuilt 1953 · S/N 30410N1710HQuon Nicholas · Fayetteville, GABuilt 1959 · S/N 35810N17113J&L Aviation LLC · Lakewood Ranch, FLBuilt 2012 · S/N 3851N1711CNorthern Flyway LLC · Anchorage, AKBuilt 1953 · S/N 30411N1711VAggravation Aviation Inc · Wilmington, DEBuilt 1964 · S/N TC-591
Back to AD 2000-23-21