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.

N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78N2416CTa Ritchey LLC · Batavia, OHBuilt 1954 · S/N 30716N2416QAltitude Addiction LLC · Harker Heights, TXS/N 18257616N2416TFebruary Aviation LLC · Lake Geneva, WIBuilt 1962 · S/N NAV-4-2416N2417CW & K Aviation LLC · Omro, WIS/N 30717N2417QMcgough Julie Eileen · Red Oak, TXS/N 18257617N2417RJohary Aviation Inc · Apopka, FLS/N 18255517N2417SPiasecki Aircraft Corporation · Coatesville, PABuilt 1967 · S/N 337-0717N2417XGerding Thomas P · Philomath, ORBuilt 1965 · S/N 18256317N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136N24183Smither Tom M · Marietta, GABuilt 1978 · S/N D-10107N24187Heil Brad C · Homer, AKBuilt 1972 · S/N 18502031N2418CBlythe Anne T · Paso Robles, CABuilt 1954 · S/N 30718N2418GSunset Cay Orc Partners LLC · Key Largo, FLS/N 51718N2418NDah Aviation LLC · Boerne, TXBuilt 2022 · S/N 8953N2418SThomas Michael Ray · Marshall, MOBuilt 1967 · S/N 337-0718N2418XPoessel Frank George Jr · East Bernard, TXBuilt 1965 · S/N 18256318N24192Lindeman Rusty L · D Hanis, TXBuilt 1978 · S/N E-1223N24194Ge King LLC · Lewes, DEBuilt 1978 · S/N E-1222N24195Barrett Group LLC · Farwell, TXBuilt 1978 · S/N D-10110N2419FMartinez Rudy J · Wasilla, AKBuilt 1965 · S/N 18051619N2419GBig Sky Aviation LLC · Kapaau, HIBuilt 1958 · S/N 51719N2419QScholl Steven G · Bluffton, SCBuilt 1966 · S/N 18257619N241AJAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1958 · S/N 35789N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012N241BSAdventure Airways LLC · Sacramento, CABuilt 2008 · S/N 421014N241CMFalgout Scott · La Place, LABuilt 2002 · S/N 0357N241CPAdvanced Aircraft Sales LLC · Miami, FLBuilt 2006 · S/N 1713N241CVRrt Aircraft LLC · St George, UTBuilt 2019 · S/N 33-0017N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563N241DBSequoia Aeronautics LLC · Portland, ORBuilt 2007 · S/N L2K-290N241EBUsd Flyers Inc · Atlanta, GABuilt 2005 · S/N 42065N241FRTrailside Inc · Roseville, CABuilt 2017 · S/N T24002140N241GBPalmer Levi S · Upper Lake, CABuilt 2003 · S/N 42023N241GSCirrus Design Corp · Knoxville, TNBuilt 2010 · S/N 0032N241HAMcfarland Mark C · Cottage Grove, ORBuilt 1960 · S/N CD-84N241HHOddson Terrance J · Windom, MNBuilt 2001 · S/N E-3427N241HPWest Palm Breathe Free And Wellness LLC · West Palm Beach, FLBuilt 1984 · S/N 25-0804N241KTRiley Robert V Jr · Hattiesburg, MSBuilt 2007 · S/N 31-0075N241LCD&D Air Services LLC · Mooresville, NCBuilt 2018 · S/N 4731N241LMEntropy Elevation LLC · San Jose, CABuilt 2015 · S/N 1124N241MBFlying Brick LLC · Monroe, NCBuilt 2004 · S/N 0910N241NPNauti Plane LLC · Wilton Manors, FLBuilt 1968 · S/N TE-648N241PKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 0102N241RSalamon Uri · Boerne, TXBuilt 1980 · S/N CE-925N241RDRegistration Pending · Missoula, MTRegistration pendingBuilt 1975 · S/N 18502934N241RMNt LLC · Aberdeen, SDBuilt 2017 · S/N T24002126N241RSHood Jeffery M · Ada, OKBuilt 2008 · S/N E-3879N241SGFalasco Joseph R · Little Rock, ARBuilt 1999 · S/N 29-0196N241SHSky West Aviation Inc Trustee · Albuquerque, NMS/N 0398
Back to AD 2000-23-21