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.

N4072YCompton Douglas C · Heron, MTBuilt 1961 · S/N 185-0272N4073DKarsell Kris J · Duluth, MNBuilt 1958 · S/N 34773N4074DDimitriadis Joseph T · Las Vegas, NVBuilt 1958 · S/N 34774N4074SOverbeck John T · Excelsior, MNFirst renewal noticeBuilt 1975 · S/N CE-554N4074YMcaleer John D · Aurora, ORBuilt 1961 · S/N 1850274N4076QSandoval Juan · Valley Stream, NYBuilt 1968 · S/N 401-0176N4076YPhillips Halvor A · Winnemucca, NVBuilt 1961 · S/N 185-0276N4077AFarmer Gary E · Saint Augustine, FLBuilt 1970 · S/N D-9109N4077D234kq LLC · Eagle, IDBuilt 1957 · S/N 34777N4077SRiedesel Lynn R · Brookings, SDBuilt 1975 · S/N E-638N4078DFinney James R · Howe, TXBuilt 1957 · S/N 34778N4078QGerker Carl J · Palmdale, CAS/N 320C0046N4079ABrockhoff Jonathan Allen · Sanford, NCBuilt 1999 · S/N E-3279N4079CCalled To Care Residential Facility LLC · Avondale, AZBuilt 1978 · S/N 310R1364N4079DErnst Gregory R · Eagle Creek, ORBuilt 1957 · S/N 34779N4079QAero Fliers LLC · Kalispell, MTS/N 34-7770237N407CBLanham Kelty R · Fresno, CABuilt 1974 · S/N E-511N407CDKelly George Sumner · Columbus, GABuilt 2004 · S/N 1005N407DMPhillips Consulting Group Inc · Wilmington, DEBuilt 1990 · S/N EA-507N407JCPlane Partners LLC · Newton, MABuilt 1982 · S/N E-2033N407KMGough Tecnologies Inc · Winston Salem, NCBuilt 2004 · S/N 41012N407KPDelta Consulting & Real Estate LLC · Manila, ARBuilt 2018 · S/N 4687N407PCOversquare LLC · Norman, OKBuilt 1996 · S/N E-3032N407RKMoore John C · San Miguel, CABuilt 1968 · S/N 401-0181N407RSSiddens Tab D · Albany, MOBuilt 1975 · S/N TH-593N407ST5x Sr22 LLC · Sandy Springs, GABuilt 2022 · S/N 8917N407TVolunteer Aerials LLC · Stanley, NCBuilt 1966 · S/N TE-231N4080DCrane Gary W · Gig Harbor, WABuilt 1957 · S/N 34780N4080SCosse John J Jr Trustee · Lenexa, KSBuilt 1975 · S/N D-9728N4080YPanama City Cycles Inc · Panama City, FLBuilt 1961 · S/N 1850280N4081Pearl Equipment LLC · Bassfield, MSBuilt 2016 · S/N E-4081N4081DEarl Tim G · Plymouth, CAS/N 34781N4082BJdj Inc · Mountain Home, ARBuilt 1977 · S/N 77-30850N4082DSharp Nicholas · Valdez, AKBuilt 1957 · S/N 34782N4083A4083a LLC · Wilmington, DES/N D-9110N4083DAerohawk Aviation Inc · Idaho Falls, IDBuilt 1957 · S/N 34783N4084Dailey Garrett C · Alamo, CABuilt 1960 · S/N BG-391N4084SDavenport Michael · Naperville, ILBuilt 1975 · S/N D-9729N40855Covey Stephen B · Manvel, TXBuilt 2000 · S/N E-3298N4085BMarroquin Jesse B DBA · Schertz, TXFirst renewal noticeBuilt 1976 · S/N 76-30821N4086APippert James R · Dysart, IABuilt 1970 · S/N D-9112N4086DThompson George M · Fairbanks, AKBuilt 1957 · S/N 34786N4086S80'S Associates Inc · Pittstown, NJBuilt 1975 · S/N D-9731N4087HHarmonic Air LLC · Portland, ORBuilt 1980 · S/N 25-0463N4088DIron Horse Aviation LLC · Omak, WABuilt 1957 · S/N 34788N4089DGaffney Justin L · Arcata, CABuilt 1958 · S/N 34789N4089SRaii3 LLC · Lewes, DEBuilt 1975 · S/N D-9732N408ABRite A Way Services Inc · Riverside, CAS/N 411090N408CDKc Jet Sales LLC · Scottsdale, AZBuilt 2005 · S/N 1464N408CSTextron Aviation Inc · Wichita, KSBuilt 2013 · S/N T24002001
Back to AD 2000-23-21