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.

N3108KKirgiss Randy M · Johnson City, TNS/N F7-901N3110CKent Karen S · Port Allen, LAS/N F7-888N3119HEmpty Pockets Balloon Team LLC · Gallup, NMS/N F7-884N3120YBlue Ridge Hot Air Balloons LLC · Front Royal, VABuilt 1996 · S/N F7-910N31226Scarberry Wm G Jr · Piney Flats, TNBuilt 1996 · S/N F8B-517N3125KCole Timothy S · Greeley, COBuilt 1996 · S/N F7B-366N3126FReid Eric M · Albany, ORBuilt 1996 · S/N F8B-497N31271Allison J R · Albuquerque, NMS/N F71004N31326Balloon Stormers Inc · Ashland, MOBuilt 1997 · S/N F71027N313HDWilson Daniel E · Tucson, AZBuilt 1982 · S/N 096N31409Wilkinson Steve · Lake Havasu, AZS/N F6B-110N31427Benzer Terry L · Blountville, TNBuilt 2015 · S/N F8B-2119N31527Hutchinson Brian · Bonner Springs, KSBuilt 1997 · S/N F7B-378N31544Keller Sarah A · Huntertown, INS/N F8B-544N3155JLady Jester Natchez LLC · Natchez, MSS/N F7-902N31664Forenz Thomas · Georgetown, COBuilt 1997 · S/N F71017N3166JCline J Donald · Greensboro, NCBuilt 1996 · S/N F71000N3171LGoodnow Tony A · Topeka, KSBuilt 1996 · S/N F8B-493N3173KSky Adventures Inc · Oxford, MIBuilt 1996 · S/N F9B-013N31744Island Balloons Inc · Lanexa, VAS/N F7-893N3175SStarr William K · Buckeye, AZBuilt 1996 · S/N F9B-012N3176QBegin Echo R · Reno, NVBuilt 2000 · S/N F8B-562N3177UAubol-Hanks Nancy B · Bosque Farms, NMBuilt 1998 · S/N F7-1052N3178MBart Francis A · Old Town, FLS/N F7-894N317WSilver Lining Ballooning LLC · Prairie Grove, ARS/N F8-403N31800Cameron The Pilot LLC · Casper, WYS/N F8B-490N3180SEbiner Ann B · Santa Rosa, CAS/N F8B-506N3185TSky Adventures Inc · Oxford, MIBuilt 1997 · S/N F9B-017N31877Clemons Louise · Truro, IAS/N F71021N31910Ristaino Damien Edward · Charlotte, NCBuilt 1997 · S/N F8B-537N3191FPowell Timoth · Sanford, NCBuilt 1996 · S/N F71002N3198TDuren Richard S · Shelby, NCBuilt 1997 · S/N F8B-539N3202UJohnson Shaun T · Grand Forks, NDBuilt 1998 · S/N F7-1001N3202YPennell Mark · Sparta, NCS/N F7B-400N3208GNapa Valley Aloft Inc · Yountville, CABuilt 1996 · S/N F8-414N3209AAllred Kelly M · Longmont, COS/N F7-913N3209MOld World Balloonery LLC · Overland Park, KSBuilt 1997 · S/N F8B-529N32104Jones Brian C · Sapulpa, OKBuilt 1996 · S/N F8B-512N3210CBalloon Stormers Inc · Ashland, MOBuilt 1996 · S/N F7-906N3210RSena Paul A · Worthington, MABuilt 1996 · S/N F8B-501N3211ZSokovich Caleb S · Watertown, WIBuilt 1997 · S/N F71029N3212AMccomb Jay · Hendersonville, TNS/N F7-897N3213HMoormann Richard C · Winston Salem, NCBuilt 1995 · S/N F8B-494N3213TDelmarva Balloon Rides LLC · Chester, MDBuilt 1997 · S/N F8B-543N32143Eagle James A · Candler, NCS/N F8B-542N3218BWicker Basket Balloon Center · Wixom, MIBuilt 1996 · S/N F9B-014N3219QCrites Walter W · Auburn, MEBuilt 1998 · S/N F7-1049N3219YWiltse Bret A · Johnston, IABuilt 1998 · S/N F7-1056N32309Brownell Lynn K · Eagle Bridge, NYS/N F71026N32343Cross Paul · Monteagle, TNBuilt 1997 · S/N F71011
Back to AD 75-12-08