AD 81-18-04 R2

Registered aircraft · 81,733

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

N6447MSpring Creek Land & Cattle LLC · Lance Creek, WYBuilt 2001 · S/N 25072CN6447PTuttle Glenn L · Lynnwood, WABuilt 1959 · S/N 24-1562N6447QP&M Enterprises LLC · North Charleston, SCBuilt 1967 · S/N 670526N6447RGensler Orion M · Bloomfield, MOBuilt 1966 · S/N 28-21630N6447UOlathe Spray Ser Inc · Olathe, COBuilt 1962 · S/N 2252N6447WSeverson Eric · Waukesha, WIBuilt 1964 · S/N 28-20519N6447ZH&H Ag Aviation Inc · New Underwood, SDBuilt 1961 · S/N 25-607N64485Registration Pending · La Harpe, ILRegistration pendingBuilt 1975 · S/N 17265262N6448ABrown Frederick A · Scottsbluff, NEBuilt 1978 · S/N 38-78A0425N6448JMurphy Richard F · Hughesville, MDS/N 28-4867N6448MTarrant County College · Fort Worth, TXBuilt 1980 · S/N 15284732N6448PPlowman James C · Upland, CABuilt 1959 · S/N 24-1563N6448QMicheliche Robert B · Federalsburg, MDBuilt 1967 · S/N 670527N6448RShaw Timothy E · Ashtabula, OHBuilt 1966 · S/N 28-21631N6448WSierra Lima Aviation LLC · Riverton, UTS/N 28-20520N64493Neron II LLC · Lewes, DEBuilt 1982 · S/N 17275565N6449JBentley Aviation Services · Lewes, DEBuilt 1980 · S/N 17273874N6449TPelayo Fernando · La Puente, CABuilt 1985 · S/N R18202028N644AKMd Ag Services LLC · Sterling City, TXBuilt 2004 · S/N 10364N644CLLeckie Charles W · Rosemount, MNBuilt 1997 · S/N 1834N644CMMckenzie Bradley J · Houston, TXBuilt 2004 · S/N 1376-2004N644CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282247N644DCCompton John Douglas · Morgan, UTBuilt 2020 · S/N 80790N644DDArfvidsson Emil · Mountain View, CABuilt 1978 · S/N 24-0664N644DFRegent Trust Corp Trustee · Wichita, KSBuilt 2023 · S/N 2881663N644DRNorthwestern Michigan College · Traverse City, MIBuilt 1953 · S/N 18-2867N644EZNorthern Air Spray LLC · Maple Grove, MNBuilt 2007 · S/N 11971N644FLAty Aviation Inc · Watertown, SDBuilt 1971 · S/N 28-7125552N644FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843704N644GRishel Keith D · Prineville, ORBuilt 1970 · S/N 28-26741N644GDDuda W Gregory · Grass Valley, CABuilt 1993 · S/N 644N644HKHalbrook Beal M · Albany, GAS/N 644N644JDDougherty Joseph D · Wheaton, ILBuilt 1994 · S/N 832N644JSScott Jerry E · Eastvale, CABuilt 2019 · S/N 4231N644KCollins Curtis R · Tennessee Colony, TXBuilt 1999 · S/N 60209N644KSKent State University · Stow, OHBuilt 2006 · S/N 4496220N644LSkyjams Holdings LLC · Las Vegas, NVBuilt 2016 · S/N 1321N644RABoston Helicopters · North Andover, MABuilt 2012 · S/N 2205N644TPBarrett Kevin M · Pittsburg, TXBuilt 1975 · S/N 301N644WGreen Wendell L · Argyle, TXBuilt 1967 · S/N 3N644WPDorna William H Jr Trustee · Chuluota, FLBuilt 2005 · S/N 3854N645Endsley Terry G · Wilkeson, WABuilt 1981 · S/N 120N6450Blueskys Inc · Wilmington, DES/N 125N64507Quigley Patrick M · Slidell, LABuilt 1975 · S/N 17265267N64508Roseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17265268N64509Wing Adney F III · Live Oak, FLBuilt 1975 · S/N 17265269N6450GN6450g Inc · Jacksonville, NCBuilt 1979 · S/N 17273597N6450JBurk Kevin M · Sunset, TXBuilt 1968 · S/N 28-4869N6450KOstrowski-Swope Roxanne M · Ortonville, MIBuilt 1980 · S/N 17274197N6450RPlan Bee LLC · Washington, DCBuilt 1966 · S/N 28-21635
Back to AD 81-18-04 R2