OpenAirDocs.org
AD 96-24-17 R1

Registered aircraft · 1,458

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:96-24-17-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-17-R1')
  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.

N28488Doan Lawrence E · Seattle, WABuilt 1947 · S/N 1355N28494Pristo Paul J · Scottsdale, AZFirst renewal noticeBuilt 1940 · S/N 1361N28542Jatho Jim W · Augusta, GAS/N 1370N28547Shaw Kevin R · Canton, GABuilt 1940 · S/N 1376N28554Ruth-Ann Baughman Bell · Hummelstown, PABuilt 1940 · S/N 1383N28564Gingras John T · Bakersfield, CABuilt 1940 · S/N 1393N28574Mccutchan Clay T · Milton, FLBuilt 1940 · S/N 1403N28576White Paul M · Elizaville, NYBuilt 1940 · S/N 1405N28577Snodgrass James T · Gallipolis, OHS/N 1406N28579Lutz Terry L · Williamston, MIBuilt 1940 · S/N 1408N28580Goble John H · Cresson, TXBuilt 1940 · S/N 1409N28588Registration Pending · Mesa, AZRegistration pendingBuilt 1940 · S/N 1417N28595Sanders John P · Knoxville, TNBuilt 1940 · S/N 1424N28600Kenney Madelaine J · Seattle, WABuilt 1940 · S/N 1429N28601Williford Alicia · Terlingua, TXBuilt 1940 · S/N 1430N28606Fisher Al · Nampa, IDBuilt 1940 · S/N 1435N28612Jackson James E · Brainerd, MNBuilt 1940 · S/N 1441N28617Lyle Daniel D · Westmoreland, KSBuilt 1940 · S/N 1694N28628Boyette Robert J · Meridian, IDBuilt 1940 · S/N 1457N28632Webster David Ht · Columbia, TNS/N 1371N2863KJackson James E · Brainerd, MNBuilt 1947 · S/N 5590N2867KRamin Jeanette J Executor · Houston, TXBuilt 1947 · S/N 5594N28701Knight Robert T Sr · Baton Rouge, LAS/N 1462N28704Unger Benjamin T · Noblesville, INFirst renewal noticeBuilt 1940 · S/N 1465N28716Davis James R Trustee · Springfield, ORBuilt 1940 · S/N 1477N28729Davis Ted E · Brodhead, WIBuilt 1940 · S/N 1490N28731Bohlander Michael S · Marengo, ILBuilt 1940 · S/N 1492N28734Kranz Mark D · Varnville, SCBuilt 1940 · S/N 1495N28750Lahay Cameron · Saint Louis, MOS/N 1511N28751Ready Aim Flyer LLC · New Castle, DEBuilt 1940 · S/N 1512N28753Dyer Albert L · Batavia, ILBuilt 1940 · S/N 1514N28762Lutes Richard L · Hampshire, ILBuilt 1940 · S/N 1523N28782Nytko Rafal · Elk Grove, ILBuilt 1940 · S/N 1543N28783Huffine Stephen W · Ketchikan, AKBuilt 1940 · S/N 1544N28784Dubbert Roger D · Mexico, MOBuilt 1940 · S/N 1545N28789Freudenberg Joseph B · Almira, WAS/N 1550N28795Larch Jacob J · Lester Prairie, MNS/N 1556N28796Woodard Eric D · Trenton, MOS/N 1557N28798Flying A Aviation LLC · Archer City, TXBuilt 1940 · S/N 1559N28823Wilkie David J · Nashua, NHS/N 1565N28824Labbee Tyler J · White Swan, WABuilt 1940 · S/N 1566N28825Ledet Christian P · Huxley, IABuilt 1940 · S/N 1567N28826Archibald William B · Hollis, NHBuilt 1940 · S/N 1568N28829Engler William O · Filion, MIBuilt 1940 · S/N 1571N28830La Porte Timothy J · Iliamna, AKBuilt 1940 · S/N 1572N28837Hamlin Timothy B · Garden City, KSBuilt 1940 · S/N 1579N28841Sword Scott B · Sublimity, ORBuilt 1940 · S/N 1583N28853Greencastle Chapter 1374 Eaa · Reelsville, INBuilt 1940 · S/N 1595N28864Magnuson Lloyd W · Opelousas, LABuilt 1940 · S/N 1606N28868Schoen David H · Plain, WIBuilt 1940 · S/N 1610
Back to AD 96-24-17 R1