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.

N4471RMurray Carol A · Hilo, HIBuilt 1976 · S/N 18502964N4474MN4474m Inc · Camarillo, CABuilt 2001 · S/N EA-674N4474STailwind Aviation LLC · New Rochelle, NYBuilt 1975 · S/N E-698N4474WR And S Aviation LLC · Corning, ARBuilt 1974 · S/N TH-431N4475ARyan Justin M Jr · Rch Palos Vrd, CABuilt 1970 · S/N TE-807N4476WBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N TC-1809N4477HEisele Fly LLC · Fort Myers, FLBuilt 2020 · S/N 2238N4477RDyer George C · Victor, MTBuilt 1976 · S/N 18502967N4477SMaynard J Smith Mobile Homes & Rvs Ltd · Okoboji, IABuilt 1975 · S/N E-699N4478SLichter Robert L · Waban, MABuilt 1975 · S/N E-690N4479FDurosinmi Lateef · North Las Vegas, NVS/N 34-7670338N4479SN4479s LLC · Nashville, TNBuilt 1975 · S/N D-9790N447ARRv 9a Flyers LLC · Lubbock, TXBuilt 2011 · S/N 71521N447BRCordogan Clark & Associates Inc · Aurora, ILBuilt 1995 · S/N E-2991N447CDCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11426N447ESummers Mark A · Alpine, WYBuilt 2013 · S/N L2K-327N447JLKjolsing Jerome M · Camino, CABuilt 1966 · S/N TE-121N447JSSchwertner Farms Inc · Schwertner, TXBuilt 2026 · S/N 11518N447MAState Of Montana · Helena, MTBuilt 1975 · S/N E-697N447NASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N CJ-130N447WLM5-210c LLC · Castle Pines, COBuilt 1967 · S/N 18258588N4481SAc Aviation LLC · Searcy, ARBuilt 1975 · S/N TC-1881N4482WWheels In The Well LLC · Jonesboro, ARBuilt 2000 · S/N TH-1964N4483RRuf Timothy · Anchorage, AKBuilt 1976 · S/N 18502969N44844Morland Robert L · Bowman, NDBuilt 1977 · S/N 28R-7703330N44845N44845 LLC · Ozark, MOBuilt 1977 · S/N 28R-7703331N4484WRegistered aircraftBuilt 1974 · S/N D-9581N44859Tarcelo Francis Antonio G · Sun City, CABuilt 1977 · S/N 28R-7703333N4485SDickerson Stephen Sr · Frisco, TXBuilt 1975 · S/N D-9785N44862Red Arrow III LLC · Carson City, NVBuilt 1977 · S/N 28R-7703335N4486AAerro LLC · Argyle, TXBuilt 1970 · S/N TE-808N4486SPopadich Nicholas · Monroe, MIBuilt 1975 · S/N D-9788N4486WReynolds Eric Eugene · Weatherford, TXBuilt 1969 · S/N D-9070N4487SHanson Raymond H · Thousand Oaks, CABuilt 1975 · S/N E-708N44889Gray Bradley D · Killeen, TXBuilt 1977 · S/N 28R-7703336N4488SMartens Paul A · Fairview, OKBuilt 1967 · S/N 18051869N4489Golden Age Air Museum · Bethel, PABuilt 2023 · S/N 4489N44891Rci Asset Management Inc · San Diego, CABuilt 1977 · S/N 28R-7703339N4489PTj 2 LLC · Jackson, MIBuilt 1961 · S/N D-6769N4489SBeaufort Capital Partners LLC · Winston Salem, NCBuilt 1975 · S/N E-706N4489WHogan Johnny R · Overbrook, OKS/N E-545N448AKN448ak LLC · Helena, MTBuilt 1974 · S/N U20602295N448ALWheeler Alexa L · Tavernier, FLBuilt 1973 · S/N 18262250N448AMHetpath Aero LLC · Bismarck, NDBuilt 2015 · S/N 4205N448BBHawkflight LLC · Sugar Land, TXBuilt 1979 · S/N 21063563N448CDKrebs Stephen P · Houston, TXS/N 1243N448DDillingham John E · Enid, OKBuilt 1997 · S/N E-3116N448JDavenport James A · San Antonio, TXBuilt 1966 · S/N D-8127N448KMDecou Gordon C · Myakka City, FLBuilt 2015 · S/N 31-0134N448LAircraft Management Corp · Wilmington, DEBuilt 1978 · S/N E-1298
Back to AD 2000-23-21