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.

N4018DUnderhill Clinton T · Yuma, AZS/N 34718N4019YWitt William A · Ennis, MTBuilt 1961 · S/N 185-0219N401AESmith Jay D · Shreveport, LABuilt 1976 · S/N E865N401ATBlum John J · Montgomery, TXBuilt 1966 · S/N 401-0010N401AZTre Aviation Corp · Wilmington, DEBuilt 1969 · S/N 401B-0018N401BMorrison Richard L Trustee · Anchorage, AKBuilt 1978 · S/N TC-2164N401BHHarvey William G · Pipersville, PABuilt 2006 · S/N 41593N401BRBethel View Holdings LLC · Danbury, CTBuilt 2025 · S/N 10683N401BTKlena Bradley D · Maryville, TNS/N 401A0002N401CAGlenn Roger H · Pacifica, CABuilt 1969 · S/N 401A-0025N401CFStuewe Charles D · Chino Hills, CABuilt 1967 · S/N 401-0115N401CMRmc Holdings Inc · Denver, COBuilt 2004 · S/N 41016N401CRSpringrock LLC · Redlands, CABuilt 2006 · S/N 41712N401CSMyron E Stine Trustee · Dallas Center, IABuilt 2016 · S/N T24002104N401DSalsola Logistics LLC · Douglas, WYBuilt 1977 · S/N 18503517N401DRApex Aeronautical Group LLC · Jenks, OKBuilt 1980 · S/N TH-1138N401MHKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2015 · S/N 4265N401MPFriend Ships · Lake Charles, LABuilt 1979 · S/N P21000280N401MROk Av8r LLC · Iowa Park, TXBuilt 1967 · S/N 401-0159N401NKLoya Christopher Nmi · Houston, TXS/N R172-0229N401PFBumpy Aviation LLC · Kalispell, MTBuilt 2006 · S/N 41647N401PSLesmeister Dean · Kindred, NDBuilt 2005 · S/N 29-0401N401RGRomeo Golf Holdings LLC · Carlisle, IABuilt 2025 · S/N 10465N401SBGoertzen Joshua K · Wasilla, AKBuilt 1975 · S/N TH-641N401SDThree Hands Farms LLC · Aldie, VABuilt 2024 · S/N 10171N401SSN401ss LLC · Arvada, COBuilt 1976 · S/N 18265067N401STMercer Skylink LLC · Bluefield, WVFirst renewal noticeBuilt 2006 · S/N 41624N401SUWright Air Service Inc · Fairbanks, AKBuilt 1975 · S/N U20602932N401SXHyannis Air Service Inc · Hyannis, MAS/N 402C0447N401TJHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0109N401TMBlue Skies Over The Creek LLC · Port Orange, FLBuilt 2026 · S/N 11389N401TTSolomon Colors Inc · Springfield, ILBuilt 2008 · S/N 2920N401WCNakochna River Resort LLC · Willow, AKS/N 18502235N401WMMrd Aero LLC · Manheim, PABuilt 1972 · S/N 401B0219N401WWAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1968 · S/N 401-0275N401ZPSchrader Adam · Spicer, MNBuilt 2014 · S/N 0938N4021D21d LLC · West Henrietta, NYBuilt 1957 · S/N 34721N4022YKelley Kitty K · Albion, IDBuilt 1961 · S/N 185-0222N4023BSachs Robert W · Green Cove Springs, FLBuilt 1974 · S/N 75-30763N4024YJr Aviation LLC · Temple, TXS/N 1850224N4025BPalmer James F · Walla Walla, WABuilt 1975 · S/N 75-30743N4026YOlsen Scott M · Forest Lake, MNBuilt 1961 · S/N 185-0226N4028DDriebergen John A · Meridian, IDS/N 34728N4028EAmerican Airpower Museum · Farmingdale, NYBuilt 1956 · S/N BG-292N4028GUnited States Navy (Owner) · Millington, TNBuilt 1955 · S/N BG-9N402AJ2lyons Enterprises LLC · Wellington, FLBuilt 1975 · S/N 402B0884N402BCDssr22 LLC · Troy, MTBuilt 2023 · S/N 9125N402BFSnell Marion Lea · Ackerly, TXBuilt 1975 · S/N 402B1010N402BKN402bk LLC · Nantucket, MABuilt 1978 · S/N 402C0689N402CENorth American Aerial Surveys LLC · Tucson, AZBuilt 1973 · S/N 402B0364
Back to AD 2000-23-21