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.

N37038Hilbert Elroy E II · Rockford, ILBuilt 1941 · S/N 1699N37039Jones Marcia Beth · Troy, MTBuilt 1941 · S/N 1700N37041Kozar Joseph G · Warren, MIBuilt 1941 · S/N 1702N37055Schneck Terry A · Slatington, PABuilt 1941 · S/N 1716N37067Collins Glenn D · Rustburg, VABuilt 1941 · S/N 1728N37068Lutz Terry L · Williamston, MIBuilt 1941 · S/N 1729N37081Jones Raphael S Jr · San Jose, CABuilt 1941 · S/N 1742N37087White Paul M · Elizaville, NYBuilt 1941 · S/N 1748N37096Lehner Christopher E · Battle Ground, WABuilt 1941 · S/N 1757N373CSCook Kyle H · Newberry, FLBuilt 1946 · S/N 4524N37GHAckland Gordon S · Frederick, MDBuilt 1947 · S/N 4683N39012Gregg Ray A · Rangely, COBuilt 1941 · S/N 1773N39025Henrikson Robert D · Chesterfield, MOBuilt 1941 · S/N 1782N39028Registration Pending · Midland City, ALRegistration pendingBuilt 1941 · S/N 1789N39034Anderson Mark A · Bates City, MOS/N 1795N39041Pearsall David N · New Milford, CTBuilt 1941 · S/N 1802N39053Obrien Brian Bolton · Waltham, MABuilt 1941 · S/N 1814N39062Lucas Steven · Delaplane, VABuilt 1941 · S/N 1823N39063Warnock Edward R · Mesa, AZBuilt 1941 · S/N 1824N39067Miller Rondo T · Coon Rapids, MNBuilt 1941 · S/N 1828N39077Davis David A · Spring Hill, KSBuilt 1941 · S/N 1838N39078Stringer Gregory A · Egg Harbor Twp, NJBuilt 1941 · S/N 1839N39079Christy Ronald · Lake City, MIS/N 1840N39087Wolford Phillip J · Abingdon, ILBuilt 1941 · S/N 1848N39092Blauser Edward C · Mansfield, OHBuilt 1941 · S/N 1853N40SDFlying S Airventures LLC · San Antonio, TXBuilt 1948 · S/N 6339N40VSDale David J · North Fort Myers, FLBuilt 1940 · S/N 1306N40WKKahn Walter I · Baldwinsville, NYBuilt 1940 · S/N 1484N411DEdwards Anthony C · Weaverville, CABuilt 1939 · S/N 947N41913Hallam Drew R · Orfordville, WIBuilt 1941 · S/N 1874N41917Daphna Inc · Middletown, DEBuilt 1941 · S/N 1878N41920Obrien Scott · Camarillo, CAS/N 1881N41921Irwin Tim · Greensburg, INFirst renewal noticeBuilt 1941 · S/N 1882N41922Howell Alan L · Enon, OHBuilt 1941 · S/N 1883N41932Shank Ronald D · Greensburg, KSBuilt 1941 · S/N 1893N41933Wilkie David J · Nashua, NHBuilt 1941 · S/N 1894N41944Karnaukh Mikhail B · West Jefferson, NCBuilt 1941 · S/N 1905N41945Walder Randall L · Whitethorn, CABuilt 1942 · S/N 1906N41947Von Wald Stephen A · Portland, ORBuilt 1941 · S/N 1908N41951Flannery Robert P · Durango, COBuilt 1942 · S/N 1912N41958Brown Jeffrey D · Saint Cloud, MNBuilt 1941 · S/N 1919N41961Murray Gregory T · Napa, CABuilt 1942 · S/N 1922N41965Rake Richard D · Tyler, TXBuilt 1942 · S/N 1923N45403Pickett Ronald K II · Mc Alpin, FLBuilt 1945 · S/N 1930N45404Denny Mark J · Battlefield, MOBuilt 1945 · S/N 1931N45405Pierce James C · Tallahassee, FLBuilt 1945 · S/N 1932N45410May Michael S · Axtell, NEBuilt 1945 · S/N 1937N45411Sikkel Robert M · Bucksport, MEBuilt 1945 · S/N 1938N45416Mckillop Bruce W · Rural Valley, PABuilt 1945 · S/N 1943N45419Belnap Bobby R · Vale, ORBuilt 1945 · S/N 1946
Back to AD 96-24-17 R1