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.

N1866DFarris Russell L · Fort Mill, SCBuilt 1952 · S/N D-3136N1871DTiehen James P · Huntington Beach, CABuilt 1952 · S/N D-3181N1875DJohnson Clayton D · Desert Hot Springs, CAS/N D-3118N1880DAdams Marvin R · Peyton, COBuilt 1952 · S/N D-3151N1881DHerrell Lynn K · Wichita, KSS/N D-3153N1889DKish James D · Centennial, COBuilt 1952 · S/N D-3161N1890DBrott Edwin T · Cincinnati, OHBuilt 1952 · S/N D-3173N1891DDale Richard C · La Vernia, TXS/N D-3163N1892DLong Jory J · Lake Ozark, MOBuilt 1952 · S/N D-3164N1894DAiken Wayne B Jr · Greenville, SCBuilt 1952 · S/N D-3166N1896DBrabender 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-3028N1YMSupreme Aeronautics LLC · Haymarket, VAS/N D-1145N2001DOn The Roll Aviation LLC · Vail, AZBuilt 1952 · S/N D-3351
Back to AD 72-18-01