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.

N220KCAvanti Air Co · Troy, MIBuilt 1989 · S/N 3433137N220KMBlue Streak Aviation LLC · Dupont, WABuilt 2017 · S/N 1536N220LATochima Air LLC · Laredo, TXBuilt 2023 · S/N 9230N220MEBoyle Flying Service Inc · Boyle, MSBuilt 1967 · S/N U206-0797N220MRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 3779N220MWLampert Aviation LLC · Phoenix, AZBuilt 1977 · S/N E-1063N220PKCirrus Design Corp · Knoxville, TNBuilt 2010 · S/N 0004N220RGWalden Hill III LLC · Signal Mountain, TNBuilt 2024 · S/N 10182N220RPDanzig Peter B · Menlo Park, CABuilt 1988 · S/N E-2438N220RVVans Aircraft Inc · Aurora, ORBuilt 2004 · S/N 40210N220SQValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11124N220SRBriar Flyer LLC · Bedford, NHBuilt 2002 · S/N 0391N220TCLanger Brent A · Owatonna, MNBuilt 1973 · S/N 18502153N220TGSeneca Tank Inc · Des Moines, IABuilt 2002 · S/N 3449265N220THJak Enterprises LLC · Brooklet, GABuilt 2005 · S/N 1574N220TJJaco Oil Co · Bakersfield, CAS/N 21063139N220VStartz John D · Dallas, TXBuilt 1969 · S/N TC-1235N220VAVision Air LLC · Rapid City, SDBuilt 2026 · S/N 11192N220VFVision Flight LLC · Knoxville, TNBuilt 2017 · S/N 1622N220VVSmith Peter I Trustee DBA · Ocala, FLBuilt 1989 · S/N 3433140N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194N220WRExecutive Services Inc · Columbus, MSBuilt 1994 · S/N E-2909N2210RCarroll James K · Paso Robles, CAS/N T210-0360N2210YN2210y LLC · San Antonio, TXBuilt 2000 · S/N 29-0212N2211FSkyvault Holdings LLC · Saint Petersburg, FLBuilt 1960 · S/N 39235N2211GKoepplin Ricky G · Missoula, MTBuilt 1958 · S/N 51511N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711N22126Compassion Medflight LLC · Pikeville, KYBuilt 2024 · S/N 10017N2212ASiewart Michael · Columbus, OHS/N 310G-0018N22131Kraxberger Rick R · Kasilof, AKBuilt 1976 · S/N 18503074N2213CTruffer Martin · Fairbanks, AKBuilt 1953 · S/N 30513N2213GAnzion Susan K · Nerstrand, MNBuilt 1958 · S/N 51513N2214CMarks Richard J IV · Norway, MEBuilt 1953 · S/N 30514N2214GGanfield Roger A · Guernsey, WYBuilt 1958 · S/N 51514N2214VJohr Bernardo M · Pembroke Pines, FLBuilt 1979 · S/N 28R-7931115N2214XElm Air LLC · Satellite Beach, FLBuilt 2003 · S/N 1319N2215CEnvialo LLC · Vail, COBuilt 2023 · S/N 9416N2215TBackcountry Wagons LLC · Kalispell, MTBuilt 1968 · S/N 185-1367N2215YNaran Ashish H · Brookhaven, GABuilt 2000 · S/N 30-0049N22166Reading Jared T · Uvalde, TXBuilt 2000 · S/N 29-0225N2216CAero Mark Inc · Idaho Falls, IDBuilt 1953 · S/N 30516N2216FSummit North LLC · Anchorage, AKBuilt 1982 · S/N U20606504N2216QQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 28R-7931069N2216URegistered aircraftBuilt 1974 · S/N U20602355N2216XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 337-0116N2217CSale Reported · Kerrville, TXSale reportedBuilt 1979 · S/N 18267230N2217RParke Mike D · Twin Falls, IDBuilt 1968 · S/N T210-0367N2217TTango LLC · Anchorage, AKBuilt 1968 · S/N 185-1369N22184Rosene Richard W · Newport, RIBuilt 2000 · S/N 29-0227N2218CMart Gary A · Bend, ORS/N 30518
Back to AD 2000-23-21