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.

N1333FMadrigales Jorge · Laredo, TXBuilt 2005 · S/N 1715N1333SMclaughlin Sam J · Lubbock, TXBuilt 1973 · S/N 73-30601N1333TWoodford Michael F · Fabius, NYBuilt 1969 · S/N T210-59108N1334HPreskar Michael H · Ione, CABuilt 1977 · S/N 34-7770121N1334XGiannetti Nicholas · Charlotte, NCBuilt 2007 · S/N 42510N1335WCastanon Salvador L · Rancho Cucamonga, CABuilt 1963 · S/N 223N1336CMakson Leasing Co Inc · Salisbury, NCBuilt 2003 · S/N 0483N1336SJ And D Petroleum Co · Tallahassee, FLBuilt 1976 · S/N 18264899N1337LAviation Specialty Services LLC · Beaufort, NCBuilt 1977 · S/N 33701829N1338GWings Air Charter LLC · Wisconsin Rapids, WIBuilt 1974 · S/N 310R0022N1338V38 Victor LLC · Port Clinton, OHBuilt 1976 · S/N R1722172N1339GLyon Aviation Inc · Pittsfield, MABuilt 1974 · S/N 310R0023N1339ZSmith Derek D · Brooks, GABuilt 1961 · S/N TC-139N133AGRaritan Valley Flying School · Princeton, NJS/N CE-1470N133AWFlight Time 2 LLC · Shallotte, NCBuilt 2013 · S/N L2K-195N133BSMusser Merton · Billings, MTBuilt 1988 · S/N CE-1234N133CDQualitair LLC Trustee · MichelstadtBuilt 2000 · S/N 1025N133CGRoq Farm LLC · Diboll, TXBuilt 1989 · S/N CE1416N133CWDeniro Corp · Hampton, NHBuilt 1978 · S/N 310R1260N133DSHagopian Donald D · Van Nuys, CABuilt 1965 · S/N 18256837N133ECMf33a Enterprises LLC · Amarillo, TXBuilt 1992 · S/N CE-1679N133EMWheels Up LLC · Lincoln, NES/N E-517N133GSa133g LLC · Camden, DEBuilt 2011 · S/N 0135N133GMBem Holdings LLC · Nashville, TNBuilt 1987 · S/N CE-1170N133LBlair Byron · Ajo, AZBuilt 1952 · S/N D-3300N133MCMohawk Flying Club Inc · Ada, MIBuilt 2010 · S/N 2054N133MDWells Rich · Aspen, COBuilt 1987 · S/N CE-1163N133MRPrecision Aero LLC · Wilmington, DEBuilt 1978 · S/N TC-2173N133MWSky Mile Limit · Murrayville, GABuilt 1967 · S/N CE-188N133NDHitch-Nel Partners LLC · Issaquah, WABuilt 1975 · S/N 33701669N133PCGilco Distributors · Santa Rosa, CABuilt 1976 · S/N 340A0093N133QFreeland Christopher G · Brownwood, TXBuilt 1957 · S/N D-5319N133SBColeman Terry Michael · Meridianville, ALS/N CE-891N133SMSpivack Peter · Philadelphia, PABuilt 1979 · S/N 25-0001N133TDLanyi Clifford · Attleboro, MABuilt 1990 · S/N CE-1548N133TSHunter Stephen Eugene · Grace, MSBuilt 1966 · S/N 18257883N133VMCathey Gary C · El Dorado Hills, CAS/N CE786N133VWAlpine Katmai LLC · Alpine, WYBuilt 1975 · S/N 18263927N134Mccann Thomas J Jr · Jackson, WYBuilt 1953 · S/N 53-4135N1340MValiair Lc Trustee · Casper, WYBuilt 2006 · S/N 41666N1342GSpector Steven D · Glenview, ILBuilt 1974 · S/N 310R0026N1342SFreeworld Aviation LLC · Dixon, ILBuilt 1976 · S/N 18264905N1343SComalander Christopher R · Beaumont, TXBuilt 1976 · S/N 18264906N1343ZBriscoe Travis L · Archie, MOS/N D-6770N1344UGrit Services LLC · Manila, ARBuilt 1962 · S/N 18254544N1345NHolco Solutions LLC · Wilmington, DEBuilt 2007 · S/N 41784N1345SGrant Larry · Sebring, FLBuilt 1976 · S/N 18264908N1346GClear Blue Aviation LLC · Melbourne, FLBuilt 1974 · S/N 310R0029N1346LAtwell Air LLC · Grundy, VABuilt 1977 · S/N 33701838N1347CBlue Ridge Aero Inc · Berryville, VABuilt 2003 · S/N 0536
Back to AD 2000-23-21