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.

N71505Argyros William T · Minneapolis, MNBuilt 1946 · S/N 2932N71507Oreair Richard L · Jacksonville, FLFirst renewal noticeBuilt 1946 · S/N 2934N71519Lee Joseph B · Oxnard, CABuilt 1946 · S/N 2946N71523Koch Kirt K · Cleveland, GABuilt 1946 · S/N 2950N71524Macey Donald L · Fallon, NVBuilt 1946 · S/N 2951N71529Lindee Daniel J · Star Prairie, WIBuilt 1946 · S/N 2956N71532Kraus Russell E · Albemarle, NCBuilt 1940 · S/N 2959N71535Wood Stephen K · Whitewater, COBuilt 1946 · S/N 2962N71537Allen Roger M · Salem Lakes, WIBuilt 1946 · S/N 2964N71540Murphy Frank · Thomasville, GAS/N 2967N71541Crowley Jeffrey B · Newnan, GAS/N 2968N71547Pratt Adam D · Shawnee, KSS/N 2974N71549Sodergren Kit · Davis, CABuilt 1946 · S/N 2976N71555Whaley Paul W · El Dorado, KSBuilt 1946 · S/N 2982N71556Hood Matthew G · Argyle, TXBuilt 1946 · S/N 2983N71565Prindle Albion E · Auburn, MAS/N 2992N71567Bennett George G · San Augustine, TXBuilt 1946 · S/N 2994N71574Almena State Bank · Almena, KSBuilt 1946 · S/N 3001N71575Pyle William V · Sun Prairie, WIBuilt 1946 · S/N 3002N71577Fugate Terry L · Atoka, OKBuilt 1946 · S/N 3004N71586Anderson Mark A · Bates City, MOBuilt 1946 · S/N 3013N71600Morrissey John C · Lees Summit, MOBuilt 1946 · S/N 3027N71603Hallstrom Warren C · North Little Rock, ARBuilt 1946 · S/N 3030N71608Perunko Daniel R · Grass Valley, CABuilt 1946 · S/N 3035N71613Morrison John L · Oklahoma City, OKBuilt 1946 · S/N 3040N71615Goetz Thomas J · Woodland, MEBuilt 1946 · S/N 3042N71625Harris Scott · Oregon City, ORBuilt 1946 · S/N 3052N71628Mccormick Edward J Jr · Kenton, OHBuilt 1946 · S/N 3055N71632Landsgaard Theodore J · Rosamond, CABuilt 1946 · S/N 3059N71635Swift Timothy G · Washington, IAS/N 3062N71643Mccain Rod A · El Cajon, CAS/N 3070N71647Mehrdad Zarifkar · Mount Vernon, IABuilt 1946 · S/N 3074N71660Ramin Jeanette J · Houston, TXBuilt 1946 · S/N 3087N71662Chapin William V · Fayetteville, GABuilt 1946 · S/N 3089N71668Lovley Vaughn T · Webster, MNBuilt 1946 · S/N 3095N71676Johnson Jimmy L · Saint Charles, MOBuilt 1946 · S/N 3103N71686Dubbert Roger · Mexico, MOBuilt 1946 · S/N 3113N71688Ott Edward C · Walnut Creek, CABuilt 1946 · S/N 3115N71691Burka Mark A · Finchville, KYBuilt 1946 · S/N 3118N71692Mccoy Kenneth L Jr · Syria, VAS/N 3119N71694Driscoll Patrick J · Caldwell, IDBuilt 1946 · S/N 3121N71698Kaurich Steven J · O Brien, FLS/N 3125N71704Maxwell Steven L · Safford, AZS/N 3131N71708Sievert Stephen L Sr · Plainfield, ILBuilt 1946 · S/N 3135N71711Mohrbacher Dale A · Naples, FLBuilt 1946 · S/N 3138N71712Oshins Lawrence W · Gainesville, FLBuilt 1946 · S/N 3139N71715Gelbart Uriel A · Anchorage, AKS/N 3142N71717Bradford William F · Independence, MOBuilt 1946 · S/N 3144N71718Johnson Bonnie L · Sedgwick, KSBuilt 1946 · S/N 3145N71730Shipley John L · Tremonton, UTS/N 3157
Back to AD 96-24-17 R1