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.

N6870PPruitt Steven W · Sioux Falls, SDS/N 24-2005N6870UTahirovic Elmaz · Sharpsburg, GABuilt 1965 · S/N 2574N68714Registration Pending · Iuka, ILRegistration pendingBuilt 1981 · S/N 15285332N6871JRyan Air Ventures LLC · Auburn, GABuilt 1976 · S/N 28R-7635354N6871PHogue Kalum Shane · Monroe, TNBuilt 1960 · S/N 24-2006N6871WSkylux Aviation LLC · Coppell, TXBuilt 1965 · S/N 28-21027N6872NVivian Rodney E · Cincinnati, OHBuilt 1968 · S/N 680149N6872WMergen Andrew John · Colorado Springs, COBuilt 1965 · S/N 28-21028N68735Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1978 · S/N 15282345N68736Lake Elmo Aero LLC · Lake Elmo, MNS/N 15282346N6873BBent James L Jr DBA · Palatine Bridge, NYS/N 18-5053N6873CMabry Roger Louis Jr · Norwood, NCBuilt 1978 · S/N 32R-7885034N6873NWhitfield Jesse Leigh · Anacortes, WABuilt 1968 · S/N 680150N6873WUptegrove James L · Susanville, CABuilt 1965 · S/N 28-21029N68742Byars Cecil E · Tupelo, MSBuilt 1978 · S/N 15282351N6874BSale Reported · Mentor, OHSale reportedS/N 22-4118N6874CHuebner Charles P · Grosse Pointe Farm, MIBuilt 1978 · S/N 32R-7885035N6874PZide Joshua M · Newark, DEBuilt 1960 · S/N 24-2009N6874WEra Aviation LLC · Downers Grove, ILBuilt 1965 · S/N 28-21030N68750Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282356N68754Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282358N6875BCyr Kevin M · Brush, COS/N 22-4119N6875NKatlin Ethan W · Payson, AZBuilt 1968 · S/N 680151N6875TSkala James A · Hartselle, ALBuilt 2009 · S/N 90756N68767Snohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282367N68768Harris Thomas W · Roseville, MNBuilt 1978 · S/N 15282368N6876HSt Charles County Flying Club LLC · Portage Des Sioux, MOBuilt 1975 · S/N 17265622N6876JN6876j LLC · Provo, UTBuilt 1976 · S/N 28-7690417N6876KAndrews Thomas J · Lakeview, ORS/N 16-717N6876NCunneen Casey Joseph · Studio City, CABuilt 1968 · S/N 680152N6876UVan Der Hart Mark H · Tekamah, NEBuilt 1963 · S/N 2580N68775Gruca Paul G · Riverdale, MIBuilt 1981 · S/N 15285337N6877FAces Full Inc · Deadwood, SDBuilt 1976 · S/N 32-7700004N6877HKoenig Ned · New Bremen, OHBuilt 1975 · S/N 17265623N6877KLaurienzo Andrew A · Clarence, NYBuilt 1949 · S/N 16-720N6877NElliott John O · Lathrop, MOBuilt 1968 · S/N 680126N6877WFriedrich David Paul · Frankfort, INBuilt 1965 · S/N 28-21033N68789Sinden Donald L · Puyallup, WABuilt 1978 · S/N 15282374N6878BCriner Brad W · Canby, CABuilt 1959 · S/N 18-5061N6878GRundell Lanny · Winnsboro, LABuilt 2015 · S/N 2464N6878JLake Stephen · Geary, OKBuilt 1976 · S/N 28R-7635355N6878KMitchell David R · Conover, NCBuilt 1949 · S/N 16-721N6878PLangley Richard A · Sheyenne, NDBuilt 1960 · S/N 24-2014N68799Smtm Holdings Inc · Wilmington, DEBuilt 1978 · S/N 15282382N6879CParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816437N6879PCory Ipc Corp · Indianapolis, INS/N 24-2015N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592N687BASvetfur Aviation LLC · Camden, SCBuilt 2015 · S/N 172S11581N687CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N 18282288N687HRSchroeder Scott M · San Martin, CABuilt 2020 · S/N 227
Back to AD 81-18-04 R2