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.

N2237GSmith Caleb · Beggs, OKBuilt 1958 · S/N 51537N2238CGorham Wendy J · Grand Rapids, MNBuilt 1953 · S/N 30538N2238XStyron Mark A · Pasadena, TXS/N 337-0138N2238ZHaines Ranch · White Lake, SDBuilt 1979 · S/N 28-7921024N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741N2239D41 Investments Gp LLC · Sinton, TXBuilt 1978 · S/N 34-7970011N2239GPotter Cleve J · Fresno, CABuilt 1958 · S/N 51539N2239ZAsc Air LLC · Neligh, NEBuilt 1979 · S/N 28-7921025N223BBN223bb LLC · Great Falls, VABuilt 2000 · S/N E-3340N223BMCirrus 801ca LLC · Port Angeles, WABuilt 2015 · S/N 4285N223CHHrm Ventures Inc · Welcome, NCBuilt 2025 · S/N 10848N223CPThompson Charles D · Buda, TXBuilt 2006 · S/N 1738N223CSBpc Aircraft Leasing LLC · Estero, FLBuilt 2013 · S/N T24002017N223CWNorthern Cowboy Holdings LLC · Prior Lake, MNBuilt 2018 · S/N 1699N223DBurch Construction Co Inc · Ramona, CABuilt 1993 · S/N CE1755N223DFOurcirrus LLC · Highlands Ranch, COBuilt 2022 · S/N 8927N223DWSeibel Keith L · Paris, TNBuilt 1963 · S/N D-7113N223ERKern Delta Co LLC · Fresno, CABuilt 2007 · S/N 2658N223FDRegistered aircraftBuilt 2023 · S/N 9162N223FSTtr Air LLC · Mount Dora, FLBuilt 2025 · S/N 10536N223GBMain Line Aviation LLC · Haverford, PABuilt 2022 · S/N 8638N223GKGk Aviation LLC · Orlando, FLBuilt 2022 · S/N 8764N223GSN771cd LLC · Missoula, MTBuilt 2007 · S/N 42555N223HWatson James E Jr · Victor, COBuilt 1956 · S/N 35385N223HHMach Speed Properties LLC · Spiro, OKBuilt 2006 · S/N 2212N223HMRegistration Pending · Sag Harbor, NYRegistration pendingBuilt 2026 · S/N 11390N223KMWithrotor Aviation Inc · Lakeview, ORBuilt 1974 · S/N TH447N223KWMedic Choppers LLC · Springdale, ARS/N EA-382N223LE&M Aircraft LLC · Baton Rouge, LABuilt 2006 · S/N 41680N223LDGaston'S White River Resort Inc · Lakeview, ARBuilt 1965 · S/N U206-0493N223MVallington Alexander M · Enterprise, ALBuilt 1960 · S/N D-6524N223MKKaul Mahendra · Bainbridge Island, WABuilt 2004 · S/N 1003N223MRConderet LLC · New York, NYFirst renewal noticeBuilt 2006 · S/N 1760N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105N223RJCline Larry J · Beeville, TXBuilt 1979 · S/N 18266850N223RWRegistered aircraftBuilt 2010 · S/N 3442N223SBAdams Derek · Lexington, MABuilt 1981 · S/N TJ-339N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999N223SMDickey Michael Patrick · Perry, FLBuilt 2006 · S/N 41657N223TFMeadowlark Air LLC · Johnston, IABuilt 2011 · S/N 3814N223TLZanghi Michael · Katy, TXBuilt 1971 · S/N 18260719N223TNGeneral Aviation Modifications Inc · Ada, OKBuilt 2007 · S/N 2698N223TSJvgh LLC · Eastpoint, FLBuilt 2019 · S/N 4788N223TXBaron Logistics LLC · Metairie, LABuilt 2007 · S/N 2494N223VBJuliet Whiskey Aviation LLC · Davenport, IABuilt 2020 · S/N 2054N223WHPerrin James F · Bancroft, WIBuilt 1964 · S/N 18051355N223WTDouble Barrel Roll LLC · Post Falls, IDBuilt 2014 · S/N 0744N2240DOhnback Ulf · Spokane, WABuilt 1978 · S/N 34-7970032N2240XTri-Rotor Spray & Chemical · Ulysses, KSBuilt 1965 · S/N 337-0140N2241FHaag Douglas A · Collierville, TNBuilt 1967 · S/N 310L-0041
Back to AD 2000-23-21