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.

N28880Dexter Fred H · Live Oak, FLBuilt 1940 · S/N 1622N2889KBarber Gregory A · Farmersville, TXBuilt 1947 · S/N 5616N28904Tyson Charles W M · Burleson, TXBuilt 1941 · S/N 1646N28905Nuss Thomas J · Conway Springs, KSBuilt 1941 · S/N 1647N28916Carnegie Scott W Trustee · Saint Charles, MOBuilt 1941 · S/N 1658N28918Proctor Taylor J · Statesboro, GABuilt 1941 · S/N 1660N28919Smithwick Patrick M · Kiowa, COBuilt 1941 · S/N 1661N2893KRossman Robert L · Crested Butte, COBuilt 1947 · S/N 5620N2894KYost Alfred R · South Bend, INBuilt 1947 · S/N 5621N2900KHenning Karl L · Burr Ridge, ILBuilt 1947 · S/N 5627N2908KBinns Jeffrey E · Hackettstown, NJS/N 5635N2915KFifer Logan J · Sycamore, ILBuilt 1947 · S/N 5642N2921KDenney Brent A · Fowler, COFirst renewal noticeBuilt 1947 · S/N 5648N2925KMurray Gregory T · Napa, CAFirst renewal noticeBuilt 1947 · S/N 5652N2933KSciolla Christopher M · Lumberton, NJBuilt 1947 · S/N 5660N2935KMataro Craig H · Justin, TXBuilt 1947 · S/N 5662N2942KCuvar Philip M · Granite City, ILS/N 5669N2943KDurke Raimund · Ben Wheeler, TXBuilt 1947 · S/N 5670N2944KHodges James M Jr · Manchester, GABuilt 1947 · S/N 5671N2951KJacobs John Henry · Fairfield, OHS/N 5678N2952KCloudbase Assets Ltd · Avon Lake, OHBuilt 1947 · S/N 5679N2953KAkin Mark P · Edgewood, KYBuilt 1947 · S/N 5680N2955KCoulson Michael D · Zanesville, OHBuilt 1947 · S/N 5682N2956KSterner Robert E · Kettle Falls, WABuilt 1947 · S/N 5683N2962KUniversity Flying Club Inc · Stevens Point, WIBuilt 1947 · S/N 5689N2967KDittmann William H · Palmetto, FLBuilt 1947 · S/N 5694N2969KAdsit David W · Huntsville, ALBuilt 1947 · S/N 5696N2971KHarmacinski Ilse Trustee · Punta Gorda, FLBuilt 1947 · S/N 5698N2972KPerry Carlton L · Mount Morris, NYBuilt 1947 · S/N 5700N2980KKubik Rodrick D · Waterloo, IABuilt 1947 · S/N 5707N2984KClark George R · Berryton, KSBuilt 1947 · S/N 5711N2992KWhetzel Herbert H · Clarkesville, GABuilt 1947 · S/N 5719N2993KLee Robert E · Medford, WIBuilt 1947 · S/N 5720N30448Jackson James E · Brainerd, MNBuilt 1945 · S/N 1926N311BKFlattum Steven II · Algonquin, ILBuilt 1946 · S/N 3261N311PMurphy Frank · Thomasville, GABuilt 1940 · S/N 1479N346YEakin Shawn M · Franklin, PAS/N 2262N34NWWarner Norris E · Pipe Creek, TXS/N 6756N3527GMcbee Joseph L · Atlanta, KSBuilt 1959 · S/N S-55N3528GBorg Michael A · Aptos, CAS/N S-56N3534GSchrock Michael L · Felton, DEBuilt 1959 · S/N S-63N3542GBibb Henry Q Jr · Durham, NCBuilt 1959 · S/N S-74N3545GObrien A Scott · Santa Rosa Valley, CABuilt 1960 · S/N S-77N3548GWild Animal Sanctuary · Keenesburg, COBuilt 1960 · S/N S-80N36FBCertified Aeronautical Products LLC · Moody, TXBuilt 1948 · S/N 6474N37014Golden Age Aviation LLC · Naperville, ILBuilt 1941 · S/N 1675N37024Townsend Kim · Manor, TXS/N 1685N37028Monson Todd J · Lemon Cove, CABuilt 1941 · S/N 1689N37034Schafer Aircraft Holding LLC · Mesa, AZS/N 1695N37036Shank Ronald D · Greensburg, KSS/N 1697
Back to AD 96-24-17 R1