AD 75-12-08

Registered aircraft · 949

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-12-08')
    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-12-08')
  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.

N2210HDenicola Samuel W · Greenwell Springs, LAS/N F7-2034N2210VCrabtree Elliott S · Topeka, KSBuilt 2003 · S/N F8B-2053N2211PPurvis George W · Tallahassee, FLBuilt 2004 · S/N F8B-2061N2212CAirborne Adventures Ballooning Inc · Munnsville, NYBuilt 2005 · S/N F8-2013N2223HSwanson Richard · Sandia Park, NMS/N F7-806N2266HDavis John C IV · Evergreen, COBuilt 1978 · S/N 509N2380HDekoevend Enterprises Inc · Fort Garland, COBuilt 1978 · S/N 7724N238ZASuskin Dan · Atlanta, GABuilt 1998 · S/N F8B-552N2428ZBechtold Larry E · Apple Valley, CABuilt 1978 · S/N 8101N242MSScott Michael R · Rio Rancho, NMBuilt 1997 · S/N F7B-379N2502KClark Roger D · Greer, SCBuilt 1991 · S/N F7-764N25048Carnegie Ronald S Jr · Williamsburg, VABuilt 1992 · S/N F8B-407N2517TJames Steve W · Savannah, MOBuilt 1992 · S/N F7-766N25214Gower Marshall L · Town Creek, ALBuilt 1992 · S/N F7-767N25250Baldwin Thomas R · Asbury, NJS/N F8B-411N25272Cleary Robert A · Ironton, OHS/N F7-768N25303Christopher Chris A · Morgantown, WVS/N F8B-412N25326Blair Paul · Portales, NMBuilt 1992 · S/N F8B-413N2538KKeenan Thomas · Las Vegas, NVFirst renewal noticeBuilt 1992 · S/N F7-769N2539JEasy Breezes Inc · Pittstown, NJBuilt 1993 · S/N F8B-460N2542JBartsch Thomas A · Panguitch, UTS/N F7-814N2544USutter Denis M · Hallsville, MOBuilt 1995 · S/N F7-874N25510Blair John C · Bridgeton, NJS/N F8B-417N25529Ehlinger Robert E · Highlands Ranch, COS/N F8B-423N25536Dekoevend Enterprises · Fort Garland, COBuilt 1992 · S/N F8-389N2553FRaya Shawn M · Highland, MIBuilt 1993 · S/N F8B-434N2553HBrakeman David M · Decatur, ALBuilt 1992 · S/N F7-790N2553KV1 Rotate LLC · Statesville, NCS/N F7-793N2554QLucas Claire M · Vallejo, CAS/N F8B-457N25556Ingraham Richard · Littleton, COBuilt 1992 · S/N F8B-420N2556EStarr William K · Buckeye, AZBuilt 1994 · S/N F9B-009N25577Gallant Michael T · Columbus, INBuilt 1995 · S/N F7B-361N2557KLta Partners LLC · Lindon, UTS/N F8B-444N25588Cunningham Brian C · Thornton, COBuilt 1992 · S/N F7-786N25592Mcglade Zane Kg · Woodward, IABuilt 1992 · S/N F7B-332N25616Irwin Patrick S · Lovelock, NVBuilt 1992 · S/N F7-783N25619Mabee Bryant J · Vestal, NYBuilt 1992 · S/N F8B-418N2563HAeronautical Solutions LLC · Taos, NMBuilt 1993 · S/N F8B-426N2563QAerostat Promotions LLC · East Granby, CTS/N F8B-468N2563YGransbury Theodore C · Plainfield, INBuilt 1992 · S/N F8B-414N25651Hyde Daniel C · Albuquerque, NMBuilt 1992 · S/N F7-798N25654Sewell Robert M · Reno, NVS/N F7-838N25655Fitch Matthew F · Albuquerque, NMS/N F7-844N25657Olmstead Robert C II · East Randolph, VTS/N F7B-352N2565ZHartshorn Sharon · Amarillo, TXS/N F8B-461N25664Thomas George E · Hallsville, MOS/N F7B-351N2566KBowman James A · Oklahoma City, OKBuilt 1994 · S/N F7-857N25672Jennings Jay A · San Ramon, CAS/N F7-808N25682Studebaker Charles C · Albuquerque, NMS/N F8B-455N2568KI-Review Corp · Galesburg, ILS/N F7-873
Back to AD 75-12-08