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.

N1541BLaux Christopher B · Gladstone, MOBuilt 1955 · S/N 6168N1544BAdalias Family Farms LLC · Fort Pierce, FLBuilt 1948 · S/N 6171N1544KMcmillan Gary L · Rockwall, TXBuilt 1946 · S/N 4271N1545BMcmullen Morrell E · Angleton, TXBuilt 1948 · S/N 6172N1550KJerale Lance F · Manitowoc, WIBuilt 1946 · S/N 4277N1553BGurley John A · Dania Beach, FLBuilt 1948 · S/N 6180N1554BPingston Robert D · Morrice, MIBuilt 1948 · S/N 6181N1555KPerdue Adrian V · Denton, NCBuilt 1946 · S/N 4282N1556KHilton Gregory Lee · Dallas, GABuilt 1946 · S/N 4283N1559BBeierle Michael · Hanover Township, PABuilt 1948 · S/N 6186N1560BJackson David Clark · Penn Yan, NYBuilt 1948 · S/N 6187N1560KHayward Jeffrey L · Thomasville, GABuilt 1946 · S/N 4287N1562KClark Stephen R · Sonoma, CABuilt 1946 · S/N 4289N1564KMenzies Joan K · Menard, TXS/N 4291N1565KKonechne Patrick F · Chamberlain, SDBuilt 1946 · S/N 4292N1569BLedwith Kenneth E · Lincoln, CABuilt 1948 · S/N 6196N1571KDunham Roger S · Athol, IDBuilt 1946 · S/N 4298N1572BGallegos Paul A III · Blackfoot, IDBuilt 1948 · S/N 6199N1573BWeber Joel A · Goddard, KSBuilt 1948 · S/N 6200N1575KSnodderly Jean · Ward Cove, AKBuilt 1946 · S/N 4302N1576BBennett Robert M · Felton, DEBuilt 1948 · S/N 6203N1577KDawson Dan P · Chico, CAS/N 4304N1579KDematteo Scott R · Arroyo Grande, CABuilt 1946 · S/N 4306N1582KKegley Robert E · Naples, FLS/N 4309N1583BColvin Clu D · Big Cabin, OKBuilt 1948 · S/N 6210N1585BCoulter James J · Copperopolis, CABuilt 1948 · S/N 6212N1585KMcbride David T · Albuquerque, NMBuilt 1946 · S/N 4312N1586KSilkworth Michael · Willoughby, OHS/N 4313N1589BWomack Thomas G · Lonoke, ARBuilt 1948 · S/N 6216N1590KAntique Aircraft And Automobile LLC · Van Alstyne, TXBuilt 1946 · S/N 4317N1591BPerry Jim · Monroe, WAS/N 6218N1591KGreenheck Austin J · Minot, NDS/N 4318N1592BMcneill Daniel A · Placerville, CAS/N 6219N1594BTinkler Sharon W · Tullahoma, TNBuilt 1948 · S/N 6221N1594KChandler Robby L · New Hope, ALBuilt 1946 · S/N 4321N1607KPerdue Sandy L · Asheboro, NCBuilt 1946 · S/N 4334N1608KHultberg Randy S · Newport News, VABuilt 1946 · S/N 4335N1609KHoot Brian D · Toldeo, OHBuilt 1946 · S/N 4336N1611KEverhart Benjamin F Jr · Winston Salem, NCBuilt 1946 · S/N 4338N1616KSeiter Randy R · Lake Isabella, MIBuilt 1946 · S/N 4343N1618KHoffman Christopher P S · Elizabethtown, PABuilt 1955 · S/N 4337N1625KDalzell Dean M · Donnelly, IDBuilt 1946 · S/N 4352N1635KPellegrino Richard · Honolulu, HIBuilt 1946 · S/N 4362N1639KGordon Earl S · Custer, SDBuilt 1946 · S/N 4366N1641LRasch Kevin W · Denton, TXS/N 4368N1658KFischer James H · Wisconsin Rapids, WIBuilt 1946 · S/N 4385N1669KDaphna Inc · Middletown, DEBuilt 1946 · S/N 4396N1674KLa Roche Joseph F · Waukesha, WIBuilt 1946 · S/N 4401N1676KYowell Kirby D · Phoenix, AZBuilt 1946 · S/N 4403N1677KKnutson Chad H · Volga, SDBuilt 1946 · S/N 4404
Back to AD 96-24-17 R1