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.

N1949RClemons Pamela K · Boone, IAS/N F8B-2026N19JDCline Jo Ann · Greensboro, NCBuilt 1975 · S/N 709N2001EZamora Loretta · Albuquerque, NMBuilt 2007 · S/N F8B-2094N20035Sky Adventures Inc · Oxford, MIBuilt 2005 · S/N F9B-2014N2007FKirby Adam R · Scotts, MIBuilt 1996 · S/N F7-890N2020FFlying Unlike Noneother Ltd · Raymond, NEBuilt 1975 · S/N 607N2029TGardner Thomas E · Albuquerque, NMS/N F8B-2090N2031FDavis John C IV · Evergreen, COBuilt 1975 · S/N 702N2039HMarkowitz David B · Maryland, NYBuilt 1981 · S/N 10865N2039TLillard Larry J · Colorado Springs, COBuilt 2006 · S/N F7-2067N20441Jd Adventures LLC · Piscataway, NJBuilt 2006 · S/N F8B-2091N2044FWilliams Frank M · Clearwater, FLBuilt 2005 · S/N F7-2058N2046HWallis Edward J · Calistoga, CABuilt 1978 · S/N 7718N2052SSanderson Alan R · Albany, ORBuilt 2006 · S/N F8B-2093N2052XCentennial Aerosports LLC · Choctaw, OKBuilt 2006 · S/N F7-2064N2057FGrand Junction Balloon Port · Fruita, COBuilt 2000 · S/N F8B-604N20586Richardson Sean M · Kannapolis, NCS/N F8-2014N2059BChapton Donald H Trustee · Menifee, CAS/N F6B-2005N2075NPowers Daron A · Pewaukee, WIBuilt 2006 · S/N F7-2062N20796Marketing Services Inc Of Pueblo DBA · Colorado Springs, COBuilt 2006 · S/N F8-2016N2080CCaputo Joseph A · Pittston, MEBuilt 2006 · S/N F7B-2013N2081KSkylifter LLC · Naples, FLBuilt 2005 · S/N F8B2083N2085EScheve Eric J · Spirit Lake, IABuilt 2006 · S/N F8B-2096N2086DSuskin Dan · Atlanta, GABuilt 2007 · S/N F8B-2098N2088FRogina James W · Anchorage, AKBuilt 1976 · S/N 801N2096HPortland Rose Balloons LLC · Wilsonville, ORBuilt 2005 · S/N GLX-10710N20NDarling Louann · Cleburne, TXS/N F7-600N2103FGivler James B · Hudson, MABuilt 1976 · S/N 748N2103YPage Charles T · Cleveland, NCBuilt 2006 · S/N F8B-2095N21046Harrison Stephen R · Murray, UTBuilt 2006 · S/N F7B-2012N2105MAeronautical Adventures Inc · Eagle, IDBuilt 2005 · S/N F9-2005N2106FDekoevend Gery R · Fort Garland, COBuilt 1976 · S/N 501N2115HSale Reported · Cincinnati, OHSale reported, pending cancellationBuilt 1977 · S/N 794N2116GLongeill David J · Auburn, NYBuilt 2006 · S/N F8B-2089N2117PKenworthy Christopher M · Rio Rancho, NMBuilt 2006 · S/N F8B-2092N2132UGauger Aaron D · Rolesville, NCBuilt 2006 · S/N F7-2066N21349Sky Adventures · Oxford, MIBuilt 2005 · S/N F8B-2082N21410Welz Zerek A · Albuquerque, NMS/N F7-2059N2145HO Brien Michael J · Berkley, MIBuilt 2005 · S/N F7-2060N21467Sanderson Alan R · Albany, ORS/N F8B-2081N21510Caldwell Clint C · Rio Rancho, NMBuilt 2005 · S/N F8B-2080N2156SBarnes Alfred Cavis III · Norwich, NYBuilt 2006 · S/N F7B-2014N2161LCastanier Susan B · Albuquerque, NMBuilt 2005 · S/N GLX-1129BN216FSLowenstein Albert L · Albuquerque, NMBuilt 2016 · S/N 203N21823Lewis John R · Leakey, TXS/N GLX-10610N21824Thornton Ronald · Littleton, MABuilt 2003 · S/N F8B-2052N21830Bauschatz Ross A · Colonial Heights, VABuilt 2005 · S/N F7-2049N21847Allbaugh Laurie B · Waterloo, IABuilt 2005 · S/N F7-2051N2184CCline Ricky W · Hickory, NCS/N F7B-2010N2184GLansdown Jeffrey L · Danridge, TNS/N F7-2057
Back to AD 75-12-08