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.

N2017KMorris Shane E · Pewaukee, WIBuilt 1947 · S/N 4744N2018BShannon Randal S · Drexel, MOBuilt 1948 · S/N 6445N2019BBrown Nicholas K · Elkin, NCBuilt 1948 · S/N 6446N2020BLepkowski Daniel P · Industry, PABuilt 1948 · S/N 6447N2021KJinkins Robert Lee · Silver Springs, MDBuilt 1947 · S/N 4748N2025KByler Michael Jay · Mocksville, NCBuilt 1947 · S/N 4752N2026BLee Robert E · Medford, WIBuilt 1948 · S/N 6453N2026KGibboney Scott H · Temecula, CABuilt 1947 · S/N 4753N2027BHanna Samer · Rmv, CAS/N 6454N2028KHokuf Erik L · Bemidji, MNBuilt 1947 · S/N 4755N2029AFord Ethan G · Anchorage, AKBuilt 1953 · S/N 4375N2032BAyers Ryan · Santa Maria, CAS/N 6459N2035KAnderson Raymond · Grass Valley, CAS/N 4762N2037BSilvaire LLC · White Riv Jct, VTBuilt 1948 · S/N 6464N2038KWalker Ray A · Sanger, TXBuilt 1947 · S/N 4765N2040KSchnelker William A · Fort Wayne, INBuilt 1947 · S/N 4767N2041BOberholtzer John F · Davis, CAS/N 6468N2042KDalzell Dean M · Donnelly, IDBuilt 1947 · S/N 4769N2043KHyde Todd S · Loon Lake, WABuilt 1947 · S/N 4770N2045BHearst Jeffrey A · Saint Louis, MOBuilt 1948 · S/N 6472N2045KTyler Walter M · Canoga Park, CABuilt 1947 · S/N 4772N2047KTr Pegasus · Glenwood, NJS/N 4774N2050BHinton Steven J · Chino, CABuilt 1948 · S/N 6477N2050KWalton T Michael · Hudson Falls, NYBuilt 1947 · S/N 4777N2052KCromley Mark C · Lewisburg, PABuilt 1947 · S/N 4779N2054BMudry Ryan N · Del Rio, TXBuilt 1949 · S/N 6481N2057KMoghadam Jack · Ann Arbor, MIBuilt 1947 · S/N 4784N2058BVanreeth Philip J · Woodstock, ILBuilt 1948 · S/N 6485N2059KHunt Abby L · Leary, GABuilt 1947 · S/N 4786N2060BSicaras Paul G · Longmont, COBuilt 1946 · S/N 6487N2064BCrestair Air LLC · Dover, DEBuilt 1948 · S/N 6491N20657Morgan Leonard D · Greenville, SCBuilt 1938 · S/N 820N20659Dyer Albert L · New Smyrna Beach, FLBuilt 1938 · S/N 822N20663Maggio Ronald C · Alameda, CAS/N 826N2066BAeschlimann Stephen · Show Low, AZBuilt 1948 · S/N 6493N2066KMay-U Airways LLC · Saint Clair Shores, MIBuilt 1947 · S/N 4793N20687Dillahunty Chris D · Fresno, CABuilt 1938 · S/N 841N2068KWomack Wilbur A · Jackson, LABuilt 1947 · S/N 4795N20690Lunsford William E · Delaware, OKBuilt 1938 · S/N 844N20692Cleared Direct Inc · Woodlake, CABuilt 1938 · S/N 846N2070BGilbert Jill W · Kingfisher, OKBuilt 1948 · S/N 6497N2071KSale Reported · Hoxie, ARSale reported, canceledBuilt 1947 · S/N 4798N2073BWestrum D Troy · Norwalk, IABuilt 1948 · S/N 6500N2076KMuhammad Naseem · Syracuse, NYBuilt 1947 · S/N 4803N2077BFranklin James R · Henderson, NVBuilt 1948 · S/N 6504N2080BJohnson Christopher J · Tacoma, WABuilt 1949 · S/N 6507N2081BLepkowski Daniel P · Industry, PABuilt 1948 · S/N 6508N2083BOconnor Stephen J · Danbury, CTBuilt 1948 · S/N 6510N2084KDelisio Matthew W · Lake Elsinore, CAS/N 4811N2085KSmith Dawson · Halstead, KSS/N 4812
Back to AD 96-24-17 R1