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.

N2568LBuckles Lyndell G Trustee · Naples, FLFirst renewal noticeBuilt 1992 · S/N F8B-424N2568SRutherford Marcia A · Castle Rock, COBuilt 1993 · S/N F8B-437N2570EDekoevend Enterprises Inc · Fort Garland, COBuilt 1995 · S/N F9-060N2570GMills Ronald Keith · Piedmont, OKS/N F7B-343N2570WRutan Aaron · Greentown, INS/N F8B-428N2570YCity Of Riverton · Riverton, WYBuilt 1994 · S/N F8B-462N25711Russell Luke S · North Canton, OHFirst renewal noticeS/N F7-850N25713Maverick Balloons LLC · Commerce Township, MIS/N F8B-465N25714Reed David M · Lenexa, KSBuilt 1994 · S/N F7-852N25718Render Keegan C · Indianola, IAS/N F7B-349N2571WWright Bryan D · Tallahassee, FLS/N F7-819N25735Schmitt Ruth Ann · Mineral Point, WIS/N F7B-327N2573BBart Francis A · Old Town, FLS/N F7-802N25744Hoch Darcy R · Milo, IAS/N F7-861N25747Suarez Michael A · Albuquerque, NMS/N F7-809N2575PCampbell Philip L · Bayfield, COS/N F8B-436N2576UHasson James J · Meridian, MSS/N F7-828N25774Barnes Alfred C III · Norwich, NYS/N F7-801N2578GWolters Jim A · Holts Summit, MOS/N F7B-354N2578VWaddell Paul Patrick · Front Royal, VAS/N F8B-480N2579ZKent Karen S · Port Allen, LAS/N F8B-440N2580AKirk Chad Justin · Zebulon, NCS/N F7-800N2580FMullin James G · Palisade, COBuilt 1993 · S/N F8B-443N2580NOberman Michael W · Queen City, MOBuilt 1994 · S/N F7B-355N2580YShort Dennis L · Broken Arrow, OKBuilt 1995 · S/N F7-878N2580ZWatkins Tristan · Anthem, AZBuilt 1994 · S/N F7-865N2581EFitzsimmons Christian · Mount Horeb, WIBuilt 1994 · S/N F7-864N2581SSaul Garrett M · Temecula, CAS/N F7-795N25823Fritze Mark A · Tallahassee, FLBuilt 1994 · S/N F8B-467N25828Vaeth John P · Colorado Springs, COS/N F8B-448N2582UDavis Tyler J · Montrose, COBuilt 1995 · S/N F7-879N2584LSky Adventures · Oxford, MIS/N F8B-435N2584XBalloonstormers Inc · Ashland, MOS/N F8B-471N25857Aubreyaire LLC · Longview, TXBuilt 1994 · S/N F7-870N25866Turner Steve · Half Moon Bay, CAS/N F7-851N2586EBlake Stephanie · Morgantown, WVBuilt 1995 · S/N F7B-360N2587ZWhitten Randy L · Republic, MOS/N F7B-357N25884Parker Brian D · Marcellus, NYBuilt 1994 · S/N F6B-106N2588GGoodnow Tony A · Topeka, KSS/N F7-868N2588USky Adventures Inc · Oxford, MIS/N F8B-483N25897Sutter Denis · Hallsville, MOBuilt 1994 · S/N F7-867N25902Blue Ridge Hot Air Balloons LLC · Front Royal, VAS/N F8-406N2590LBallard James · Neosho, MOS/N F7-810N2590PYadkin Valley Balloon Adventures Inc · Tobaccoville, NCS/N F7-854N2590YCarter William A · Pleasant Garden, NCBuilt 1995 · S/N F7-875N2592KSilk Kyle J · Cuyahoga Falls, OHS/N F7-877N2592UField Kimberly A · Munnsville, NYBuilt 1995 · S/N F8B-478N25935Kelley Justin W · Auburn, MES/N F7-791N2593JJ M H Inc · Townville, SCS/N F7-863N2593MGoosey Rick W · Pleasant Hill, MOS/N F7B-353
Back to AD 75-12-08