OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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.

N3033BPalms Edward M · Greenwood Village, COBuilt 1998 · S/N TH-1869N3033CMetzger James R · Payette, IDBuilt 1958 · S/N D-5688N3033MPhil-Flyers Club Inc · Amarillo, TXBuilt 1977 · S/N 28R-7803160N3033QFisher David E DBA · Bristow, OKBuilt 1967 · S/N 18258033N30346Cooke Bradley J · Belmont, NCBuilt 1968 · S/N 17701203N3034CTyler Bonnie Flying LLC · Tyler, TXBuilt 1986 · S/N E-2341N3034LTown Thomas L · Chino Valley, AZBuilt 1965 · S/N 310J0034N3034TVelez Investments LLC · Orlando, FLS/N 320C0034N3035KClippert Royal C · Clarkston, MIBuilt 1978 · S/N 28R-7931030N3035WWorldwide Air & Sea Inc · Wilton, NHBuilt 1999 · S/N EA-635N3035YWardlaw Consulting LLC · Truckee, CABuilt 1962 · S/N 18254035N3036CSimpkins Larry D · Williamson, WVBuilt 1958 · S/N D-5691N3036Q3 Rivers Airshare Llp · Sheridan, MTBuilt 1967 · S/N 18258036N3036YPeterson Zachary E · Fargo, NDBuilt 1962 · S/N 18254036N30374Canihan William R · Novato, CABuilt 1973 · S/N 21059918N3037KHeartland Airplanes LLC · Olathe, KSBuilt 1978 · S/N 28R-7931031N3037QState Of Arizona · Holbrook, AZBuilt 1967 · S/N 18258037N3038FTaylor Spencer H · Lake City, FLBuilt 1966 · S/N 18257138N3039CDammel Stanley J · Odessa, WABuilt 1958 · S/N D-5698N3039KKola-Air LLC · Lewes, DEBuilt 1978 · S/N 28R-7931034N3039TDdc Investments LLC · Hot Springs, ARBuilt 1964 · S/N 320C0039N303ABMarc Inc · Bolton, MSBuilt 1981 · S/N T30300028N303AWCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11629N303BBPerry Clifton B · Lacon, ILBuilt 1964 · S/N TC-787N303BPMohan Anand · Vienna, VABuilt 2005 · S/N 1698N303CCSpectrum Aviation Inc · Wilmington, DEBuilt 1982 · S/N T30300069N303CGSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N T30300022N303CKRegistered aircraftBuilt 2002 · S/N 3449257N303CMAdvantage Aviation Inc · Charlotte, NCBuilt 1984 · S/N T30300296N303CTFloyd Brian · Eatonton, GABuilt 1978 · S/N 21062591N303DBBas Part Sales LLC · Greeley, COBuilt 1981 · S/N T30300043N303DCRegistered aircraftBuilt 1973 · S/N 402B-0303N303DKTrading Planes Inc · Wilmington, DEBuilt 1982 · S/N T303-00068N303DWOredigger Air LLC · Highlands Ranch, COBuilt 2024 · S/N 10231N303FWWoodruff Peter M · Kalamazoo, MIS/N 25-0549N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038N303HVRegistered aircraftBuilt 1994 · S/N E-2864N303JPJep Inc · Clarksville, TNBuilt 1982 · S/N T30300067N303KCCurry Kenneth R · Cookeville, TNS/N CE-1138N303KDTablerock Aviation LLC · Mccall, IDBuilt 2022 · S/N 8522N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301N303KSSmoky Hill Ag LLC · Healy, KSBuilt 1982 · S/N T30300223N303LMRegistered aircraftBuilt 2002 · S/N 40041N303MBBas Part Sales LLC · Greeley, COBuilt 1982 · S/N T30300157N303MESagebrush Ventures LLC · Canadian, TXBuilt 2017 · S/N T24002142N303MMBrown Properties Of Ga Inc · Silver Creek, GABuilt 1977 · S/N 34-7870027N303NMiles James · Memphis, TNBuilt 1981 · S/N E-1880N303PBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N T30300290N303RJTr Zato Heir Land & Cattle LLC · Spur, TXBuilt 1970 · S/N 18501728N303RMGiesbrecht Shane · Grandview, IDBuilt 1969 · S/N TC-1219
Back to AD 2000-23-21