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.

N169GRBlue Skies Above LLC · Spring, TXBuilt 1995 · S/N EA-580N169HWood Wendell · Holland, TXBuilt 2001 · S/N 29-0264N169HTAerie Leisure Inc · Phoenix, AZBuilt 2005 · S/N 41054N169JABixby & Sons LLC · Vale, ORBuilt 1964 · S/N 18256004N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169N169KD182 Flight Corp · Bronx, NYBuilt 1979 · S/N 18267456N169KSSvetfur Aviation LLC · Camden, SCBuilt 1978 · S/N 414A0015N169LALee Arnold Management Services Inc · Clearwater, FLBuilt 2017 · S/N TH-2494N169MRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2016 · S/N 1331N169NMaxfield Douglas · Chico, CABuilt 1962 · S/N 18051138N169PGHarty Joshua · Strasburg, COS/N T210-0423N169PJBernard Douglas A · New Iberia, LABuilt 2005 · S/N 41065N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999N169SPVahedi Vafa S · San Diego, CAS/N TC-353N169SRHallgren Aviation LLC · Lubbock, TXBuilt 2007 · S/N 1767N169SWFluxtronic · Nashville, TNBuilt 2009 · S/N 411136N169TFStewart Scott A · Anchorage, AKS/N 185-0383N169TXPhillips Air Ventures LLC · Tulsa, OKBuilt 2017 · S/N T24002136N169WWPro Aire Inc · Chisago City, MNBuilt 1967 · S/N 1057CN16AWFreas Joseph R · Simi Valley, CABuilt 1973 · S/N 74-30634N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101N16BBEuroair Consultants LLC · Vero Beach, FLFirst renewal noticeBuilt 1974 · S/N TC-1749N16BKWc Aviation LLC · Forest, VABuilt 2012 · S/N TH-2335N16BQBeard Bradley A · Hanford, CABuilt 2004 · S/N LIV492N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501N16DXWerner Eric J · Arlington, WABuilt 2007 · S/N L2K-285N16EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11380N16EWElliott Frank F · Mojave, CABuilt 1979 · S/N 26N16EZAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1978 · S/N 310R1277N16FSGarrett John J IV · Warner Robins, GABuilt 1961 · S/N D-6800N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075N16GMTate Joe D · Eufaula, OKBuilt 1967 · S/N D-8616N16GPDeckload Aviation LLC · Kodiak, AKS/N U20604467N16GYKuznetsov Gleb · Hillsborough, CABuilt 2016 · S/N T24002116N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134N16KELre Aviation LLC · Lakeview, OHBuilt 2011 · S/N 2091N16LSBonomo Thomas · Colorado Springs, COBuilt 1959 · S/N 4150N16LTClausen Frederik M · Lake Forest, ILBuilt 1988 · S/N 4608130N16MJHangarfinds LLC · Westminster, COBuilt 1959 · S/N D-6023N16MSEnergy Transfer Aviation LLC · Spring, TXBuilt 1979 · S/N 18267267N16MTAmarone LLC · Charleston, SCBuilt 2020 · S/N 2058N16MYAgi Inc · La Canada Flt, CABuilt 2025 · S/N 10476N16NHRutgers Nicholas G IV · Camas, WABuilt 1985 · S/N E-2220N16PMcmurray Justin John · Durham, NCBuilt 1999 · S/N TH-1925N16PFTurbine Financial Group LLC · Ogden, UTS/N R1722771N16PSAircraft Associates Inc · Tierra Verde, FLBuilt 2015 · S/N 31-0133N16PVAlign Aviation LLC · The Woodlands, TXBuilt 2006 · S/N TH-2144N16RBHotel Sierra Aviation LLC · Texarkana, TXBuilt 1965 · S/N TC-840N16RMBbj Aviation LLC · Shelby Township, MIBuilt 1997 · S/N 29-0112
Back to AD 2000-23-21