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.

N458TCyclone Services LLC · Fife, WABuilt 1961 · S/N CD-353N458TTTurner George T · Alpharetta, GABuilt 2004 · S/N 0801N458TWFirst Aviation Co · Prospect Heights, ILBuilt 2003 · S/N 0697N458WTAmrit Shrad K · Perry, GABuilt 2014 · S/N T24002038N4590SConner Chad E · Paris, TNBuilt 1975 · S/N TH-676N4591KDesmon David L · Everett, WABuilt 1948 · S/N NAV-4-1591N4592SMays Robert · Centerville, TNBuilt 1976 · S/N TJ-87N4593BSale Reported · Anchorage, AKSale reportedBuilt 1955 · S/N 31492N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569N4594ELingo Joshua B · Lake Village, ARBuilt 1979 · S/N 18503805N4595BBartusek Donald L Trustee · Columbia, MDBuilt 1955 · S/N 31494N4595SHurst Sheldon G IV · Smyrna, GABuilt 1975 · S/N D-9812N4596BLow & Slow LLC · Columbus, OHBuilt 1955 · S/N 31495N4596FJaysix LLC · Greeley, COBuilt 1966 · S/N 185-1150N4596SWaters Mark N · Clovis, NMS/N CE-685N4596URustair Inc · Anchorage, AKBuilt 1979 · S/N U20604990N4597BPost William S · Custer, WABuilt 1955 · S/N 31496N4597FWarden Richard L · Canby, ORBuilt 1966 · S/N 185-1151N4597STopflight Air LLC · Dunkirk, INBuilt 1975 · S/N E-757N4598MRegistered aircraftS/N D-10121N4599BAgua Viva Ministries · Mebane, NCBuilt 1954 · S/N 614N4599FCcs Flight Services LLC · Benton Harbor, MIS/N 340A0652N459BTAir Conrad LLC · Duncansville, PABuilt 2002 · S/N 1225N459CCLemon James M · Billings, MTBuilt 1971 · S/N 18501916N459CDUrsine Teleportation LLC · Redmond, WABuilt 2005 · S/N 1535N459CPCal Poly Corp · San Luis Obispo, CABuilt 2022 · S/N 8759N459JAThundercock Industries Worldwide LLC · Las Vegas, NVBuilt 2024 · S/N 10357N459JBBeaty Eric · Aledo, TXBuilt 2015 · S/N T24002079N459JDWilson John K · Rosamond, CABuilt 1970 · S/N E-210N459RWUmatilla Aviation G36 LLC · Umatilla, FLS/N E-4019N459TJohnson Mckenna D · Floydada, TXBuilt 1961 · S/N CD-422N459TCN459tc LLC · Wray, COBuilt 1972 · S/N D-9328N459THHlavaty Troy Edward · Columbus, NEBuilt 1980 · S/N 18267544N45ADLen Timothy Allen · Deland, FLBuilt 1977 · S/N R1722550N45AMThornburg Rocky R · White Hall, ARBuilt 1964 · S/N 21058475N45BKTwo Six Ventures LLC · Fort Lauderdale, FLBuilt 2025 · S/N 10410N45BVGrinberg Dmitry · Austin, TXBuilt 2004 · S/N 1007N45CSSadowski Curtis D · Taylorville, ILBuilt 1958 · S/N 51391N45CWRobertson Scott · Chappell Hill, TXBuilt 1970 · S/N TC-1319N45CXRobin Aviation LLC · Plymouth, MIBuilt 2021 · S/N 5145N45DHMedic Choppers LLC · Springdale, ARBuilt 1969 · S/N TE-718N45DMRaolji Mahendra · Florida City, FLBuilt 2018 · S/N 4634N45DSDcd Agriculture LLC · Franktown, COS/N 18503111N45DTKaher Kevin · Groveland, CAS/N G-785N45DWLaquerre David E · Old Orchard Beach, MEBuilt 1975 · S/N D-9840N45EEVazarani Sarah · Concord, MABuilt 1971 · S/N TH-185N45FDFox Trot Delta LLC · Indianapolis, INBuilt 2017 · S/N 1641N45FMBurgner Vanessa C · Belleville, MIBuilt 1976 · S/N TH-739N45GLOptimal Aircraft Management Nc LLC · Sanford, MIBuilt 2006 · S/N 1870N45GSLinde Aviation LLC · Payson, AZBuilt 1953 · S/N 34-76
Back to AD 2000-23-21