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.

N44XFWetzel Jack T · New Port Richey, FLBuilt 1964 · S/N TC-731N44XJRegistered aircraftBuilt 1984 · S/N TJ-478N44XPFurnace Joel Ray · Golden, COBuilt 1977 · S/N R1722584N44YHansen Kenneth · Irvine, CAS/N G-760N44ZMSchnurbusch Larry · Saint Louis, MOBuilt 1978 · S/N E-1279N4500BStartin Brandon Lee · Spokane, WABuilt 1955 · S/N 31399N4500KEaston Gregory D · Montrose, COBuilt 1978 · S/N P21000201N4500VBales Philip J · Chandler, AZBuilt 1964 · S/N 320B0053N4501SDecuir Mark A · Cottonport, LABuilt 1975 · S/N TC-1888N4502BAshcraft Dustin William · Anchorage, AKBuilt 1955 · S/N 31401N4503SBarber Christian · Mansfield, MABuilt 1975 · S/N CE-594N4504SRegistered aircraftBuilt 1975 · S/N E-720N4505SGo Flyers LLC · Sudbury, MABuilt 1975 · S/N CE-596N4506CIliamna Copper River Fly Fishing Lodge LLC · Livingston, MTBuilt 1974 · S/N 18502576N4506SBaghs LLC · Fort Lauderdale, FLS/N D-9795N4507FRodriguez Kenneth C · East Wenatchee, WABuilt 1966 · S/N 185-0989N4508FStotz Jon · Rockford, MIBuilt 1966 · S/N 185-0990N4509BTrompeter Mark S · Intl Falls, MNBuilt 1955 · S/N 31408N4509JHill Curtis E · Bancroft, IDBuilt 1981 · S/N T18803741TN450CDAlcyone Trust Corp Trustee · Wichita, KSBuilt 2005 · S/N 1478N450CFZieger C Philip · Clearwater Beach, FLBuilt 1978 · S/N TC-2128N450CSCbcb Aircraft LLC · Colfax, WABuilt 1979 · S/N P21000214N450DHHewitt Rod · Federal Way, WAS/N 21057998N450JRNowell Borders Lp · Edinburg, TXBuilt 1975 · S/N TH-670N450JTN450jt LLC · Colleyville, TXBuilt 1981 · S/N 18268032N450KSkylife Enterprises LLC · Long Beach, CABuilt 2008 · S/N 411052N450LHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N TC-2215N450SUMore Right Rudder LLC · Edmond, OKBuilt 2012 · S/N 3901N450TFAirmart Inc · Lexington, KYBuilt 2008 · S/N 411025N450THHk Air LLC · Byron, GABuilt 1981 · S/N TH-1298N450TXM And M Aviation Leasing LLC · Wilmington, DEBuilt 2004 · S/N 1063N450WSMatter Donald Chad Trustee · Friendswood, TXBuilt 1979 · S/N E-1552N450YRSmith John W Jr · Stamps, ARBuilt 1981 · S/N CE-978N4511SConner Gary Dean · Cypress, TXBuilt 1979 · S/N 28R-7931287N4513BBishop Robert W · Celina, TXBuilt 1955 · S/N 31412N4513MLeopold Aero LLC · Wilmington, DEBuilt 1978 · S/N TE-1127N4514HIndigo Of South Fl Inc · Sunrise, FLBuilt 1980 · S/N 25-0470N4514MSpencer Joseph C · Evans, GABuilt 1978 · S/N TC-2129N4515BWestern Parachute Sales Inc · Eagle Creek, ORBuilt 1955 · S/N 31414N4515MCooper Steve O · Phoenix, AZBuilt 1978 · S/N CE-767N4515SHarris Aviation LLC · Texarkana, TXBuilt 1975 · S/N E-725N4516SConcepcion Carlos L · Pembroke Pines, FLBuilt 1975 · S/N TE-1057N4517B4517b Holding Group LLC · Moses Lake, WAS/N 31416N4519SBlanck Greg J · Redwood City, CABuilt 1975 · S/N E-719N451CADelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2023 · S/N 9102N451JSPoole James Gregory III · Raleigh, NCBuilt 2026 · S/N 11141N451LXBassen Gerald R · Saint George, UTBuilt 2025 · S/N LIV-250N451MTimothy Duane High · Glenwood, MOBuilt 2005 · S/N LIV-367N451MVOne Mike Victor Aviation LLC · Belmont, CABuilt 2016 · S/N 4365N451NACooke J C Jr · Crystal Springs, MSBuilt 1969 · S/N 18259546
Back to AD 2000-23-21