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.

N1404GJkc Farm LLC · Chinook, MTBuilt 1961 · S/N D-6893N1405GLefever Larry R · Fall City, WABuilt 1961 · S/N D-6891N1405MWilson George W · Tucson, AZBuilt 1975 · S/N 18264318N1405SVickers David A · Douglas, GABuilt 1976 · S/N 18264965N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851N1408GMorris Travis T · Chandler, AZBuilt 1961 · S/N D-6892N1408WLate10air LLC · Fullerton, CABuilt 2015 · S/N 4243N1409GAir Care Leasing LLC · Lamar, COBuilt 1961 · S/N TC-233N140AFBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1709N140BBMothership Enterprises LLC · Homestead, FLBuilt 2020 · S/N E-4140N140BVGlobal Jetcare Inc · Brooksville, FLBuilt 2011 · S/N 3780N140CDCirrus Design Corp · Duluth, MNBuilt 2001 · S/N 1023N140DKIsland Flight Services LLC · Hauppauge, NYBuilt 2009 · S/N 2029N140JRobert D Grace LLC · Amarillo, TXBuilt 1981 · S/N 414A0650N140KBMcclendon Dan · Burleson, TXBuilt 1979 · S/N EA 36N140KMKnight Edge LLC · Clearwater, FLBuilt 1981 · S/N 414A-0674N140NLN140nl LLC · Maumelle, ARBuilt 1966 · S/N CE-27N140RPlaster William L · Washington, NCBuilt 1951 · S/N 22834N140RBKessler Nicholas · Central Point, ORBuilt 1979 · S/N 310R1807N140SGta Air Inc · Addison, TXBuilt 1980 · S/N TH-1155N140TPHickox Joseph · Rollins, MTS/N 340A0235N140WLMorning Air LLC · Indian Rocks Beach, FLBuilt 1979 · S/N TC-2231N14100Ycb Wings LLC · Tavares, FLBuilt 2006 · S/N 41663N1410MRapp Steven W · Boulder City, NVBuilt 1971 · S/N 18260580N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693N1411GTd Investments LLC · Oakdale, CAS/N 42556N1411VForbes David · Garden Grove, CABuilt 1976 · S/N R1722186N1412GBruch Lance J · Emmetsburg, IABuilt 1961 · S/N D-6895N1412SJ&J Aviation LLC · Thedford, NEBuilt 1976 · S/N 18264971N1413SAgillaire Inc · Colleyville, TXS/N 18264972N1413VMercury International LLC · Cheyenne, WYS/N R1722187N1415KColumbia N1415k LLC · Leesburg, INBuilt 2006 · S/N 42547N1415MJ T Air LLC · Cleveland, ALBuilt 1975 · S/N 18264321N1416CSpanos Dean T · Port Matilda, PABuilt 2015 · S/N 1198N1416GNixon Terry L · Enid, OKBuilt 1961 · S/N D-6896N1416MTerra Firma Aviation LLC · Bowman, CABuilt 1975 · S/N 18264322N1416RSkyhawk LLC · Great Falls, VABuilt 2020 · S/N 4975N1416VRegistered aircraftBuilt 1976 · S/N R1722188N1416XTop Tier Truck And Trailer LLC · Dimmitt, TXBuilt 1975 · S/N 34-7570241N1417BDavis Brad Michael · Whitesboro, TXBuilt 1967 · S/N D-8550N1417GRomney James J · Fruit Heights, UTFirst renewal noticeBuilt 1962 · S/N D-6902N1417LBright David P · Wachapreague, VABuilt 1965 · S/N M-809N1417MRegistered aircraftBuilt 1975 · S/N 18264323N1417SCooper Patrick R · Houston, TXBuilt 1976 · S/N 18264974N1417WInternational Air Services Inc Trustee · Carson City, NVS/N 42523N1418Meek Rodney B · Topeka, KSBuilt 1985 · S/N DSM IIN1419GMcneal James B · Beaufort, SCBuilt 1962 · S/N D-6900N141AMMckendrick Ain · Redwood City, CABuilt 2002 · S/N 40038N141CSKing Leo Redell III · Miramar Beach, FLBuilt 2013 · S/N T24002014N141DEEssex Lisa · Oceanside, CABuilt 1973 · S/N 310Q-0805
Back to AD 2000-23-21