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.

N75280Stack Robert J · Mc Gregor, TXBuilt 1940 · S/N 1605N770Yates Cecil R · Westminster, CABuilt 1946 · S/N 4037N77803Lor Dara H · Breckenridge, COS/N 3530N77805Pickett Ronald K II · Mc Alpin, FLBuilt 1946 · S/N 3532N77806Gordon Jerry D · Sunset Beach, NCBuilt 1946 · S/N 3533N77807Taylor Benton A · Baldwin City, KSBuilt 1946 · S/N 3534N77808Sterner Robert E · Kettle Falls, WABuilt 1946 · S/N 3535N77809Kingsley Kiman J · Miller, MOBuilt 1946 · S/N 3536N77810Registration Pending · Norwalk, IARegistration pendingBuilt 1946 · S/N 3537N77819Deakyne Carl T · Federalsburg, MDBuilt 1946 · S/N 3546N77822Sibley Kevin W · Porter, TXBuilt 1946 · S/N 3549N77837Bolton Derwin B · Jacksonville, TXS/N 3564N77838Sparks Robert B · Alexandria, LABuilt 1946 · S/N 3565N77841Delaware Sport Flyers Inc · Farmland, INBuilt 1946 · S/N 3568N77842Lynch Darrell L · Lawton, OKBuilt 1946 · S/N 3569N77854Sierens James J · Palmetto Bay, FLBuilt 1946 · S/N 3581N77856Gregory Norb L · Farmington, MNBuilt 1946 · S/N 3583N77857Gehring Dennis M · White Bear Lake, MNFirst renewal noticeBuilt 1946 · S/N 3584N77861J P Aero Holdings Inc · Carson City, NVS/N 3588N77863Heinz Kenneth P · Broadway, VABuilt 1946 · S/N 3590N77869Briere Mark E · Mims, FLBuilt 1946 · S/N 3596N77874Panepinto Lane P · Lafitte, LAS/N 3601N77876Borre Alan D · Palmyra, WIBuilt 1946 · S/N 3603N77881Ramsey Cody M · Willits, CABuilt 1946 · S/N 3608N77883Shank Ronald D · Greensburg, KSBuilt 1946 · S/N 3610N77887Hannemann James R · Mercer, WIBuilt 1946 · S/N 3614N77890Johnson Rodney C · Wheaton, MNBuilt 1946 · S/N 3617N77893Slunecka Wendell J · Gering, NEBuilt 1946 · S/N 3620N77895Woodard Mark A · Hookstown, PABuilt 1946 · S/N 3622N77901Boese Erich A · Oakdale, CABuilt 1946 · S/N 3628N77903Twibell David J · Ceresco, NEBuilt 1946 · S/N 3630N77905Gajewski Lillia M · Billings, MTBuilt 1946 · S/N 3632N77906Smith Steve G · Powell, TNBuilt 1946 · S/N 3633N77909Ziegler Gerald K · Columbiana, OHBuilt 1946 · S/N 3636N77917Wieneke Steven J · Phoenix, AZBuilt 1946 · S/N 3644N77918Dewitt Machenical And Services LLC · Sycamore, ILBuilt 1946 · S/N 3645N77923Hamilton Mark D · Thomasville, GABuilt 1946 · S/N 3650N77925Miller Rondo T · Coon Rapids, MNS/N 3652N77926Kyle Tim Eugene · Wenatchee, WABuilt 1946 · S/N 3653N77927Rickard Donald S · Florence, ALS/N 3654N77929Boursaw Ward L · Concrete, WABuilt 1946 · S/N 3656N77931Krause Alex E · Oklahoma City, OKBuilt 1946 · S/N 3658N77933Wells Nicholas M · Holdrege, NES/N 3660N77935Glassburn Hugh S · Ephrata, WAS/N 3662N77937Harrison Mark S · Berrien Center, MIBuilt 1946 · S/N 3664N77939Dillahunty Chris D · Fresno, CABuilt 1946 · S/N 3666N77942Marburg Loren C · Etiwanda, CABuilt 1946 · S/N 3669N77946Gramke John M · Ukiah, CABuilt 1946 · S/N 3673N77948Keys Trevor · Chehalis, WABuilt 1946 · S/N 3675N77950Gottschall Kenneth Lee III · Santa Paula, CAS/N 3677
Back to AD 96-24-17 R1