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.

N2048GIozia Luz E · Ruidoso, NMS/N 51348N2048V5l Aviation LLC · Decatur, TXBuilt 1978 · S/N E-1404N2048WTripi Mark DBA · Parkersburg, WVBuilt 1965 · S/N D-7987N2048ZJulis Wings LLC · Jacksonville, FLBuilt 1978 · S/N CE-828N2049ASouth Delta Aviation Inc · West Helena, ARBuilt 1978 · S/N E-1405N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190N2049WHufford P Thomas Trustee · San Diego, CABuilt 1965 · S/N D-7985N2049XTaylor Stephen A · Benton, KSBuilt 1965 · S/N 18256149N2049ZObie Edgar L · Chinook, MTBuilt 1978 · S/N E-1398N204BRRand Joseph · Osprey, FLBuilt 2002 · S/N 0248N204CDChmielewski David · Sevierville, TNBuilt 2026 · S/N 11182N204DLVictor Tango Holdings LLC · Darlington, MDBuilt 2008 · S/N 1942N204GXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 29-0373N204JWN204jw LLC · Fort Worth, TXBuilt 1976 · S/N 18265167N204LPSteffenhagen Julian L Jr Trustee · Tustin, CABuilt 1988 · S/N CE-1262N204NGTrident Aircraft Leasing LLC · Easton, MDBuilt 2014 · S/N 2271N204PT A Infinities LLC · Dover, DEBuilt 1991 · S/N E-2601N204RESchwartz Group LLC · Bozeman, MTBuilt 2004 · S/N 1429N204RMBar Air LLC · Beverly Hills, CABuilt 2015 · S/N 2295N204TSAs The Crow Flies Aerial Services LLC · Irving, TXBuilt 1977 · S/N U20604052N204VTVictor Tango LLC · Kailua Kona, HIBuilt 2006 · S/N 1605N2050DSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2002 · S/N 1191N2050GSaunders Timothy Scott · Utopia, TXBuilt 1958 · S/N 51350N2050NPerks Andrew · Weatherford, TXBuilt 1978 · S/N E-1429N2050RMills James A · Fayetteville, GABuilt 1964 · S/N 18255250N2050SDavis Bryan C · Winfield, KSBuilt 1975 · S/N 21061017N2050XWhite Levi E · Joliet, MTBuilt 1965 · S/N 18256150N2050YSomerville Elizabeth M · West Dennis, MABuilt 1978 · S/N CE-826N2050ZPong William Robert · San Mateo, CABuilt 1978 · S/N D-10193N20514Bales Gregory W · Enterprise, ORBuilt 1981 · S/N 18053190N2051BPlanepower LLC · Meridian, MSBuilt 1978 · S/N TC-2196N2051GRumiano Gary J · Vina, CABuilt 1958 · S/N 51351N2051KSocio Aviation Services LLC · Benton, KYBuilt 1978 · S/N D-10198N2051LParker Joyce A · Topeka, KSBuilt 1976 · S/N MC-436N2051R2051 Aviation LLC · Spokane, WAS/N 18255251N2051WLeiwant Alan J · Montville, NJBuilt 1978 · S/N E-1410N2051XArana Carlos · The Woodlands, TXBuilt 1978 · S/N E-1411N2053WOem Products Inc · Oklahoma City, OKBuilt 1965 · S/N D-7990N2053XGolden Richard J · Stafford, VABuilt 1965 · S/N 18256153N2054G54g Group · Seattle, WABuilt 1958 · S/N 51354N2054NHampton Todd J · Plainfield, INBuilt 1978 · S/N D-10196N2054RRiptide Investments LLC · Baker, FLBuilt 1964 · S/N 18255254N2054WVerran Clinton T · Rochester Hills, MIBuilt 1965 · S/N D-7991N2054XVoz Garth O · Gonzales, TXBuilt 1965 · S/N 18256154N20550Traskos Larry L Trustee · Port Orange, FLBuilt 1981 · S/N 18053194N2055PPechacek Justin D · Snyder, TXBuilt 1979 · S/N TC-2235N2055QJones Jeff A · Lewiston, IDBuilt 1975 · S/N U20602965N2055UR & D Aircraft LLC · Port Orange, FLBuilt 1978 · S/N D-10204N2055XMartin Robert L Jr · Havana, ILBuilt 1965 · S/N 18256155N2056LHodges Fred Lloyd Jr · Ellabell, GABuilt 1976 · S/N MC-435
Back to AD 2000-23-21