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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1896DBrabender Michael R · Montevideo, MNN1901DSouder Kasey Wayne · Longview, TXN1903DToby Aviation Inc · Pigeon Forge, TNN1904Howard Stephen R · Augusta, GAN1904DVaughn Ben E · Knoxville, TNN1906DHenning James N · Mc Daniels, KYN1912DHynes Ryan · Peoria, AZN1914DAdams Lawrence H · Prescott, AZN1915DAtterberry Charlie G · Rockwall, TXN1919DWarren Wesley L · Coeur D Alene, IDN1920DHunt James W · Maryville, TNN1921DBrickhouse Aviation LLC · Franklin, TNN1926DKoosmann Mark R · Corcoran, MNN1927DHawksworth Jeff · Laveen, AZN1930DFletcher Ellexis L · Corpus Christi, TXN1935DCoppage Walter J · Wichita Falls, TXN1938DPlane Crazy Aviation LLC · Hickory, NCN1942DFrancis David L · Fort Worth, TXN1943DHartman Dylan · Avon, INN1948DDuncan Rodney P · Las Vegas, NVN1950BBharti Rajinder · Kingston, WAN1953DFox Christopher R · Modesto, CAN1954DMontes Muriel E · Edgewood, NMN1957DLiggenstoffer Buddy L · Kiowa, KSN1966DKing Kevin L · Anaheim, CAN1975DAlsworth Cinimin Sea · Anchorage, AKN1976DRobertson William Jr · Powell, TNN1978DRegistration Pending · Knoxville, TNRegistration pendingN1979DRoberts Lawrence A Trustee · Fishersville, VAN1984DFoster Buell M · Yucca Valley, CAN1986DWolfe Thomas V · Mountain Lakes, NJN1991DCentral Virginia Aviation Inc · North Dinwiddie, VAN1993DSale Reported · Summer Shade, KYSale reportedN1995DAment Robert · Merritt Island, FLN1998DLundberg Cole M · Junction City, WIN1DNWarren Howard E · Cookeville, TNN1LJN1lj LLC · Edgewood, WAN1PVMuzny Gregory · Magnolia, TXN2001DOn The Roll Aviation LLC · Vail, AZN2005DT&H LLC · Cottage Grove, ORN2006DGraham Richard W · Rohnert Park, CAN2007DHayes Donald · Mcloud, OKN2008DDrevalas George · Bandon, ORN2011DGardner Robert J · Reno, NVN2015DAv8rs LLC · Portland, ORN2017DCream Puff Classics Inc · Hubertus, WIN2020DPearson Martha A · Walnut Grove, CAN2021DDockter Travis R · Linton, NDN2026DToro Miguel Angel · San Ysidro, CAN2032DCochran Douglas B · La Jolla, CA
Back to AD 59-08-01