OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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.

N1282ZBrickhouse Aviation LLC · Franklin, TNBuilt 1961 · S/N D-6711N1283RKeyser Dakota R · Ralls, TXBuilt 1966 · S/N 4330N1284CCirrus N1284c LLC · Oakland Park, FLBuilt 2003 · S/N 1321N1284PTwostars Aviation LLC · New York, NYBuilt 2013 · S/N E-3988N1284TWhite Wayne A · Loyalton, CABuilt 1959 · S/N 52016N1285DSale Reported · Mesa, AZSale reportedS/N 41638N1285FWill Rittner E · Sevierville, TNBuilt 1975 · S/N 18502809N1285VCarrobby LLC · Wilmington, DEBuilt 2008 · S/N 411085N1285WRnt Associates Inc · Irvine, CABuilt 2019 · S/N 33-0014N1285ZRivera Luis Jr · Spring, TXBuilt 1961 · S/N TC-100N1286CCalabarb Aviation LLC · Mesa, AZBuilt 2006 · S/N 41591N1286FTaylor Aviation Inc · Mazama, WAFirst renewal noticeBuilt 1975 · S/N 18502810N1287C907th Flight Squadron Inc · Wilmington, DEBuilt 2003 · S/N 1311N1287DRcad LLC · Wilmington, DEBuilt 2009 · S/N 411144N1288MRagsdale Michael R · Eustis, FLS/N 33701288N1288NTextron Aviation Inc · Wichita, KSBuilt 2008 · S/N 411088N1288SFrench Oil Co · Midland, TXBuilt 1976 · S/N 18264855N1288VRegistration Pending · Wallace, CARegistration pendingS/N R1722159N1288ZWeber Colleen M · Waterford, WIBuilt 1961 · S/N CD-335N1289RLeblanc Rick M · Deerwood, MNBuilt 1972 · S/N 30417N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682N128AEChiave Solutions LLC · Orlando, FLBuilt 1981 · S/N E-1830N128BRNautilus Aviation LLC · Yadkinville, NCBuilt 1979 · S/N 414A0231N128BVAbel Donald B · Greenville, WIBuilt 2006 · S/N 2060N128BWRodriquez Roy L DBA · Martin, TNBuilt 1969 · S/N 18260080N128CDMetamorphosis Publishing LLC · Hamilton, MTBuilt 2000 · S/N 1024N128CWTres Ninos LLC · Dover, DEBuilt 2013 · S/N 3949N128DBSignal Peak LLC · Corona Del Mar, CABuilt 2019 · S/N 1892N128FAWe So Fly LLC · Edgemoor, SCBuilt 2004 · S/N 1470N128FTN128ft LLC · Erie, COBuilt 2008 · S/N 3116N128JFFloyd Stephen M · Spotsylvania, VABuilt 2003 · S/N 1316N128JRMorris Dylan L · Garden Plain, KSBuilt 1976 · S/N 18264785N128MCDawson Aircraft Inc · Clinton, ARBuilt 1984 · S/N 340A1808N128PFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2002 · S/N 0218N128PPCummins Joseph · Wayzata, MNBuilt 2019 · S/N 2043N128SWRegistered aircraftBuilt 1966 · S/N 18051699N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991N128WMOac Aviation LLC · Asheville, NCBuilt 1997 · S/N E3115N128WSSkyway Air Taxi LLC · Manassas, VABuilt 2001 · S/N TH-1982N1290CPepper & Acorn LLC · Henderson, NVBuilt 2003 · S/N 0512N1290KN1290k LLC · Dover, DEBuilt 1965 · S/N 18256650N1290MGardner Michael John · Ashland, ILBuilt 1975 · S/N 18264275N1290RJones William Frank · Brea, CAFirst renewal noticeBuilt 1966 · S/N 4316N1290XJr Aviation LLC · Benton, KSBuilt 1963 · S/N 163N1291MCon Air Aviation LLC · Westerville, OHBuilt 1975 · S/N 18264276N1291NWestern States Liquefied Petroleum Gas Co · Elko, NVBuilt 2009 · S/N 411128N1291PPowers Elbie L · Roseboro, NCBuilt 1965 · S/N 18256573N1291SAvidyne Corp · Melbourne, FLBuilt 1976 · S/N 18264858N1292FRustair Inc · Anchorage, AKBuilt 1975 · S/N 18502668N1292GBahig Saliba · Scottsdale, AZBuilt 1974 · S/N 310Q1141
Back to AD 2000-23-21