AD 75-17-36

Registered aircraft · 148

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:75-17-36')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-17-36')
  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.

N3738HMccoy Timothy I · Pittsburgh, PABuilt 1983 · S/N F6B-001N3742RMaier Craig S · Crystal Lake, ILS/N F7-115N3746ELorenz Douglas A · Littleton, COS/N F7-120N3750ARogers Brandon M · Phoenix, AZS/N F7-132N37519Lynch William J · Granby, MOBuilt 1987 · S/N F7-382N3762LJames Steve W · Savannah, MOS/N F7-153N3764FBalloons Over Iowa Ltd · Carlisle, IABuilt 1984 · S/N F6B-011N40371Bowman James A · Oklahoma City, OKBuilt 1978 · S/N 6738N4037JBookman Benjamin I · Colorado Springs, COS/N 7799N4038RBalloons Over Iowa Ltd · Carlisle, IABuilt 1978 · S/N 6740N4038UEdwards Jeremy · Marietta, GABuilt 1978 · S/N 7814N4039GRutan Aaron R · Greentown, INS/N 7831N4039QRadloff Mark W · Argyle, NYBuilt 1978 · S/N 7824N4040LHill Martin Jr · Centennial, COBuilt 1979 · S/N 7835N40427Word D Glen · Anthony, NMBuilt 1979 · S/N 7861N4042DMile High Aeronauts Inc · Littleton, COBuilt 1978 · S/N 7855N4042KHalling Wayne C · Ceresco, NEBuilt 1979 · S/N 7856N4043YHall Bruce M · Kenwood, CAS/N 7869N4044EDezmelyk Robert · Newton, NHBuilt 1979 · S/N 7874N4044WThornton Ronald D · Littleton, MABuilt 1979 · S/N 7880N4047TShady Gail Ann · Casper, WYS/N 7905N40501De Koevend Enterprises Inc · Fort Garland, COS/N 7936N40518Vande Hoef Raymond L · Greeley, COS/N 11143N4051TLombardi Marcia M · Bristol, CTBuilt 1979 · S/N 7947N4052JFlameboyant Balloons LLC · Easton, PABuilt 1980 · S/N 10117N4052TLeonard Ian Q · Burlington, NCFirst renewal noticeBuilt 1981 · S/N 10040N4053YIhle Ronald W · Slater, IABuilt 1980 · S/N 10088N4054STerranova-Anderson Deirdre P · Norman, OKBuilt 1980 · S/N 10099N4057GBoyd Robert T · Quakertown, PABuilt 1981 · S/N 10115N40585Shady Raymond · Casper, WYS/N 6750N4061VKotecki Thomas G · Muskego, WIBuilt 1979 · S/N 7990N4065KHoffman Jeffrey W · Ringoes, NJFirst renewal noticeBuilt 1979 · S/N 10010N40672Fleck Jonathan D · Whitehouse Station, NJBuilt 1980 · S/N 10032N4069DGallagher Douglas L · Albuquerque, NMBuilt 1979 · S/N 10043N4070KPata John · Rio Rancho, NMS/N 10052N4071TUniversity Of Central Missouri · Warrensburg, MOBuilt 1980 · S/N 10066N4200PGreen Robert H · Elfin Forest, CAS/N F7-2075N469PKLiley Brian A · Fall Branch, TNBuilt 1977 · S/N 770N48JDCline J Donald · Greensboro, NCBuilt 1974 · S/N 141N5182UScott Michael R · Rio Rancho, NMBuilt 1987 · S/N 114N7103BBalloon Detail Inc · Norwich, NYS/N F7-365N7105HHarbold Clarke D · Charlotte, NCS/N F7-377N7105KDunn Jason A · Galesburg, ILS/N F5-378N71063Get High Incorporated · Longview, TXS/N F7-391N7106RGoodson Andrew J · Oxford, MIBuilt 1987 · S/N F7-387N7106XVezzosi Rosalie I · Milford, NJBuilt 1987 · S/N F7-390N7114GParrish Johnathon G · Toney, ALS/N F7-413N71159Mccalla Darrell P · Mountain Brook, ALFirst renewal noticeBuilt 1988 · S/N F7-420N7115HMakhlouf Mary H · Hurdle Mills, NCBuilt 1987 · S/N F6B-026N7117CBliss Stephen D · Norwich, NYBuilt 1988 · S/N F7-417
Back to AD 75-17-36