AD 72-18-01
Registered aircraft · 830
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:72-18-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:72-18-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:72-18-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:72-18-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.
N1866DFarris Russell L · Fort Mill, SCN1871DTiehen James P · Huntington Beach, CAN1875DJohnson Clayton D · Desert Hot Springs, CAN1880DAdams Marvin R · Peyton, CON1881DHerrell Lynn K · Wichita, KSN1889DKish James D · Centennial, CON1890DBrott Edwin T · Cincinnati, OHN1891DDale Richard C · La Vernia, TXN1892DLong Jory J · Lake Ozark, MON1894DAiken Wayne B Jr · Greenville, SCN1896DBrabender 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, TXN1YMSupreme Aeronautics LLC · Haymarket, VAN2001DOn The Roll Aviation LLC · Vail, AZ
Back to AD 72-18-01