AD 59-08-01

Registered aircraft · 564

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

N1896DBrabender Michael R · Montevideo, MNBuilt 1952 · S/N D-3168N1901DSouder Kasey Wayne · Longview, TXS/N D-3178N1903DToby Aviation Inc · Pigeon Forge, TNBuilt 1952 · S/N D-3180N1904Howard Stephen R · Augusta, GABuilt 1951 · S/N D-2914N1904DVaughn Ben E · Knoxville, TNBuilt 1952 · S/N D-3157N1906DHenning James N · Mc Daniels, KYBuilt 1952 · S/N D-3184N1912DHynes Ryan · Peoria, AZS/N D-3162N1914DAdams Lawrence H · Prescott, AZBuilt 1952 · S/N D-3143N1915DAtterberry Charlie G · Rockwall, TXBuilt 1952 · S/N D-3152N1919DWarren Wesley L · Coeur D Alene, IDBuilt 1952 · S/N D-3191N1920DHunt James W · Maryville, TNBuilt 1952 · S/N D-3192N1921DBrickhouse Aviation LLC · Franklin, TNS/N D-3193N1926DKoosmann Mark R · Corcoran, MNBuilt 1956 · S/N D-3198N1927DHawksworth Jeff · Laveen, AZS/N D-3199N1930DFletcher Ellexis L · Corpus Christi, TXBuilt 1952 · S/N D-3203N1935DCoppage Walter J · Wichita Falls, TXBuilt 1952 · S/N D-3209N1938DPlane Crazy Aviation LLC · Hickory, NCBuilt 1952 · S/N D-3214N1942DFrancis David L · Fort Worth, TXBuilt 1952 · S/N D-3219N1943DHartman Dylan · Avon, INBuilt 1952 · S/N D-3221N1948DDuncan Rodney P · Las Vegas, NVBuilt 1952 · S/N D-3227N1950BBharti Rajinder · Kingston, WAS/N D-2206N1953DFox Christopher R · Modesto, CAS/N D-3233N1954DMontes Muriel E · Edgewood, NMBuilt 1952 · S/N D-3234N1957DLiggenstoffer Buddy L · Kiowa, KSBuilt 1952 · S/N D-3238N1966DKing Kevin L · Anaheim, CABuilt 1952 · S/N D-3249N1975DAlsworth Cinimin Sea · Anchorage, AKBuilt 1952 · S/N D-3172N1976DRobertson William Jr · Powell, TNBuilt 1956 · S/N D-3190N1978DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1952 · S/N D-3177N1979DRoberts Lawrence A Trustee · Fishersville, VABuilt 1952 · S/N D-3200N1984DFoster Buell M · Yucca Valley, CABuilt 1952 · S/N D-3215N1986DWolfe Thomas V · Mountain Lakes, NJBuilt 1952 · S/N D-3220N1991DCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1952 · S/N D-3250N1993DSale Reported · Summer Shade, KYSale reportedBuilt 1952 · S/N D-3256N1995DAment Robert · Merritt Island, FLBuilt 1952 · S/N D-3265N1998DLundberg Cole M · Junction City, WIBuilt 1952 · S/N D-3263N1DNWarren Howard E · Cookeville, TNBuilt 1949 · S/N D-1967N1LJN1lj LLC · Edgewood, WABuilt 1950 · S/N D-2537N1PVMuzny Gregory · Magnolia, TXS/N D-3028N2001DOn The Roll Aviation LLC · Vail, AZBuilt 1952 · S/N D-3351N2005DT&H LLC · Cottage Grove, ORBuilt 1952 · S/N D-3355N2006DGraham Richard W · Rohnert Park, CABuilt 1952 · S/N D-3356N2007DHayes Donald · Mcloud, OKS/N D-3357N2008DDrevalas George · Bandon, ORBuilt 1952 · S/N D-3358N2011DGardner Robert J · Reno, NVBuilt 1952 · S/N D-3361N2015DAv8rs LLC · Portland, ORBuilt 1952 · S/N D-3366N2017DCream Puff Classics Inc · Hubertus, WIBuilt 1952 · S/N D-3368N2020DPearson Martha A · Walnut Grove, CABuilt 1952 · S/N D-3371N2021DDockter Travis R · Linton, NDS/N D-3372N2026DToro Miguel Angel · San Ysidro, CABuilt 1952 · S/N D-3377N2032DCochran Douglas B · La Jolla, CAS/N D-3383
Back to AD 59-08-01