OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N411AKWohnoutka Daniel P · Bolivar, MOS/N 71945N411APN411ap LLC · Independence, KSBuilt 2002 · S/N 0215N411BJclm Aviation LLC · Atlanta, GABuilt 2006 · S/N 1865N411BNFranklin Kenneth A · Aliso Viejo, CABuilt 2009 · S/N 411119N411BPAbove All Aviation Inc · Santa Barbara, CABuilt 1977 · S/N 18266177N411CGDenovo Aviation LLC · Lafayette, INBuilt 2017 · S/N 33-0002N411DTSliwa Kevin Joseph · Fishers, INBuilt 2010 · S/N 3678N411EHeli Thrills LLC · Wills Point, TXBuilt 1968 · S/N E-24N411EEVaini Marc · West Plains, MOBuilt 2005 · S/N 41100N411EGCompton William C · Anchorage, AKBuilt 1966 · S/N D-8184N411EPRsbrm Aviation LLC · Lakewood, NJBuilt 2025 · S/N 10607N411GCadwell Bradley L · Orlando, FLBuilt 1964 · S/N 310I0125N411GJGuardian Jet LLC · Guilford, CTBuilt 1990 · S/N E-2586N411GTTeam 646 LLC · Jupiter, FLBuilt 2005 · S/N 1714N411HZCedar Dix LLC · Lancaster, KYBuilt 2005 · S/N 1568N411JGKern County Aviation Leasing LLC · Bakersfield, CABuilt 1986 · S/N EA-461N411JLCrowell Robert J · Rockwall, TXS/N 31-0096N411KMRowe Kieth C · Big Bear Lake, CABuilt 1963 · S/N 18255034N411LNathan David L DBA · Fullerton, NEBuilt 1974 · S/N TE-976N411LGLover Girl Aviation LLC · Peachtree Corners, GABuilt 2021 · S/N 2426N411MARouse William J · Palm Springs, CAS/N 3496N411MLRosner Louis M · Port Orange, FLBuilt 1972 · S/N E-308N411PBStarfire Consulting LLC · Nisswa, MNBuilt 1983 · S/N 18268309N411PKC C Owen Tile Co Inc · Jonesboro, GABuilt 2008 · S/N 3368N411RBOptic Air LLC · St Maurice, IAS/N 18267053N411RCLola Aviation LLC · Truckee, CABuilt 2022 · S/N 8943N411STwin Adventures LLC · Cincinnati, OHBuilt 1972 · S/N 340-0099N411SAMasdon Aviation LLC · Guntersville, ALBuilt 2006 · S/N 1967N411SESwm III Investment 1 LLC · Lubbock, TXBuilt 2014 · S/N 0897N411SHHartl Stephen J · Live Oak, FLBuilt 1964 · S/N 18051350N411SKRiverside Aviation LLC · Fernandina Beach, FLBuilt 2017 · S/N 4582N411SMKonkel Bernard · Kalispell, MTBuilt 1978 · S/N 310R1404N411SRC1n Cirrus G3 LLC · Rockford, ILBuilt 2007 · S/N 2518N411TABenz Christopher · Seattle, WABuilt 1968 · S/N R172-0196N411THCrash Landers LLC · Webster, NYBuilt 2010 · S/N 0061N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861N411TXGilbert Ivory M · Bonita Springs, FLBuilt 2005 · S/N 29-0410N411UMEasy Wind LLC · Nashville, TNBuilt 2022 · S/N 8802N411VTvc Aviation Inc · Lebanon, OHBuilt 1973 · S/N 340-0250N411VGMontala Investments LLC · Montgomery, ALBuilt 1981 · S/N 414A0675N411VTFletcher Holdings Of Nc LLC · Winston Salem, NCBuilt 2002 · S/N 0393N411WBRiser Aviation LLC · Covina, CABuilt 2025 · S/N 10643N411WTSeaguard Technologies Inc · Houston, TXS/N E-3958N411YPPops Adventures LLC · Highland, UTBuilt 2025 · S/N 10581N4120QJade Air LLC · Middle River, MDS/N 310N-0020N4121XSignature Remodeling LLC · Boonville, MOBuilt 1975 · S/N E-651N4122KWargo Michael S · Colorado Springs, COBuilt 1998 · S/N 3246106N4122PCloud Eight LLC · Los Altos, CABuilt 2023 · S/N 9394N4122QV V S Implements LLC · Wilmington, DEBuilt 1967 · S/N 310N-0022N4123CAja Leasing LLC · Union, MOBuilt 1998 · S/N 3449042
Back to AD 2000-23-21