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.

N400JVAero Beach Club LLC · North Palm Beach, FLBuilt 2020 · S/N 4958N400KClydesdale Asset Management LLC · Park City, UTBuilt 1979 · S/N 18503889N400KCGoldsmith Aero Holdings LLC · Pensacola, FLBuilt 2006 · S/N 41616N400KGDg Aviation LLC · Mansfield, TXBuilt 2008 · S/N 411072N400KHWarren James B · Houston, TXBuilt 2006 · S/N 41598N400KMRegistered aircraftBuilt 2006 · S/N 41604N400LDLa Davis LLC · Strawn, TXBuilt 2005 · S/N 41507N400LFBoboltz Randy · Hector, MNBuilt 1975 · S/N D-9825N400LLMentor Flyers Inc · Paragon, INBuilt 1957 · S/N BG-400N400LPLuitjens Jacob Jelte · Cascade Locks, ORS/N 41512N400LXChartier Michael W · Las Vegas, NVS/N 411137N400MERegistered aircraftBuilt 1999 · S/N 30-0040N400MHOmega Aero LLC · Newark, DES/N 0834N400MLE Smith LLC · Wilmington, DEBuilt 2008 · S/N 411068N400MPPilipis Maximiliano F · Brooksville, FLBuilt 2026 · S/N 11486N400MTSpevco Inc · Pfafftown, NCBuilt 1955 · S/N G-145N400NZChandler Builders Inc · Ruidoso, NMBuilt 2006 · S/N 41634N400PBonanza V35 LLC · Bakersfield, CABuilt 1976 · S/N D-9933N400PLPennae LLC · Montgomery, TXBuilt 2008 · S/N 411078N400PTRon Wright LLC · Dayton, NVBuilt 2007 · S/N 41744N400RCSpiwak Andrew J · Canyon Lake, TXBuilt 1972 · S/N D-9312N400RDBhr Leasing Corp · Wilmington, DES/N 41519N400RRJax Transport LLC · Amarillo, TXBuilt 2007 · S/N 41729N400SJLockeby Aviation LLC · Norman, ARBuilt 1978 · S/N R1722876N400TFTef Air 2 LLC · New York, NYBuilt 2023 · S/N 9243N400TNSea&Air LLC · Beaufort, SCBuilt 2008 · S/N 2957N400TRAerial Ventures 1 Ltd · Austin, TXFirst renewal noticeBuilt 2004 · S/N 41037N400TVA & A Farms Inc · Arbuckle, CABuilt 2004 · S/N 42041N400TXNo-Bull Enterprises LLC · Saint Francis, KSBuilt 2004 · S/N NB1N400UKInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 41062N400VHalford John · Ballinger, TXBuilt 1973 · S/N D-9535N400VEBoondock Enterprises LLC · Boise City, OKBuilt 2007 · S/N 41727N400VTValiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 4018N400WOzment Dennis W · Palmyra, MOBuilt 1956 · S/N 35226N400WEOberti Gary A · Hillsborough, CABuilt 1975 · S/N D-9814N400WMBryan Craig · Ellisville, MSBuilt 1972 · S/N 310Q0634N400WTArtspret Aviation LLC · Sugar Grove, ILBuilt 2001 · S/N EA-690N400YCTuca 27 LLC · Lewes, DES/N G-128N4010ARegistered aircraftBuilt 1970 · S/N D-9099N4011DSkydive Inc · Eagle Creek, ORBuilt 1957 · S/N 34711N4012DEdgren Erik J · Oskaloosa, IABuilt 1957 · S/N 34712N4013Peters Joseph J · Brentwood, TNBuilt 1973 · S/N 18052326N4013AGeoghagan Dewayne · Indianapolis, INBuilt 1970 · S/N D-9115N4013QSegura Huey F Jr · Lafayette, LABuilt 1977 · S/N 28R-7703118N40141Fulton Wayne · San Luis Obispo, CAS/N 108-71N4014YFogglifter LLC · Mccall, IDS/N 185-0214N4015AOvad David Mark · Reisterstown, MDBuilt 1970 · S/N CE-297N4015DCotten Randy · Belgrade, MTBuilt 1957 · S/N 34715N4016DBates Michael B · Medford, ORBuilt 1957 · S/N 34716N4017Y17y LLC · Parma, IDBuilt 1961 · S/N 185-0217
Back to AD 2000-23-21