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.

N1234WCuellar Mauricio Dominguez · Tampa, FLBuilt 1970 · S/N 414-0043N1234YDe Jong Thomas · Buckeye, AZBuilt 1980 · S/N 18503944N1234ZPage Donald Lee Co Trustee · Mission, TXBuilt 1961 · S/N D-6695N1235CWerner Christopher Wayne · Fayetteville, GABuilt 1988 · S/N CE-1235N1235LN1235l LLC · Tallahassee, FLBuilt 2007 · S/N 41741N1236FPitcher Michael C · Mancelona, MIS/N 18502796N1236MRutherford Dustin · Simi Valley, CABuilt 1975 · S/N 18264252N1236ZStackhouse Don E · Saratoga, WYBuilt 1961 · S/N D-6697N1237Fraser Mark L · Fairfield, CABuilt 1980 · S/N 18504021N1237MJ&C Walker Aviation LLC · Henderson, TXBuilt 1977 · S/N 21061927N1237VHarmon Robert T · Killeen, TXBuilt 2001 · S/N AR-2N1237ZFelkins Kent · Tulsa, OKBuilt 1961 · S/N CD-320N1238RLtx Consulting LLC · Austin, TXBuilt 1977 · S/N 340A-0272N1239FValpey R Wesley Jr · Medford, MEBuilt 1975 · S/N 18502799N1239MMonarch M Miller · Ocala, FLBuilt 1975 · S/N 18264254N1239ZDerrickson Bryan C · Lewes, DEBuilt 2009 · S/N 411124N123AKOptima Aviation LLC DBA · Lewisville, TXBuilt 1973 · S/N TC-1543N123AMC W Myers Holdings LLC · Anthony, NMBuilt 1973 · S/N 340-0245N123ANSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 1379N123APJc Air Academy Inc · Stockton, CABuilt 1977 · S/N 34-7770015N123ASCarlson Jonathan J · Hernando, MSBuilt 1981 · S/N 1N123AVGc 43 LLC · Annandale, VAS/N E-319N123AZN123az LLC · Las Vegas, NVS/N EA-498N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41N123BMMb700pv LLC · Greenwich, CTBuilt 2009 · S/N 3513N123CEBas Part Sales LLC · Greeley, COS/N 21061054N123CGLmadif LLC · Kaukauna, WIBuilt 2003 · S/N 1317N123CTPastor Jordan D · Riverside, CABuilt 1967 · S/N D-8590N123DGoodfrey Ronnie · Longview, TXBuilt 1961 · S/N D-6637N123DBN123db LLC · Madison, NJFirst renewal noticeBuilt 1973 · S/N 18262088N123DDCenturion 123 LLC · Glenwood Springs, COBuilt 1974 · S/N 21060627N123DEGearhart John D · Arlington, WAS/N 35926N123DHStrategic Initiative LLC · Onawa, IABuilt 2020 · S/N 2064N123DLNiche Advertising Solutions Inc · Statesboro, GABuilt 1969 · S/N 18259340N123DMJacquin Philip Fink · New York, NYS/N 21062663N123DVInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 1313N123ECJohnson Howard A · Lake Forest Park, WABuilt 1972 · S/N D-9412N123EPFalkenberg Randy J · Edmonson, TXBuilt 1976 · S/N 185-03216N123FUGm321go Aviation Group LLC · Prescott, AZBuilt 2012 · S/N 0385N123GBRegistered aircraftBuilt 1979 · S/N TE-1165N123GLAir Care Leasing LLC · Lamar, COBuilt 1973 · S/N 18261902N123GSLou Ann Inc · Los Altos, CABuilt 1979 · S/N E-1464N123HBValiair Limited Co Trustee · Casper, WYBuilt 2003 · S/N 0510N123JJRotorwings Aviation LLC · Hebron, NEBuilt 1972 · S/N TC-1421N123JTGraham Richard A · Wichita Falls, TXBuilt 1965 · S/N T210-0019N123KEDesautels Jean · Laud By Sea, FLBuilt 2023 · S/N 9613N123KLWings Over The Rockies LLC · Wittmann, AZBuilt 1977 · S/N 18265746N123KTHolliday Paul B · Kiln, MSBuilt 1963 · S/N 21058218N123LJRegistered aircraftBuilt 1965 · S/N 18051526N123MBSpinner Family Lp · White City, ORS/N R1722836
Back to AD 2000-23-21