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.

N8948YKilpatrick Kerry · Somerset, NJBuilt 1971 · S/N 39-109N89492Pilot Farm LLC · Grant, NEBuilt 1946 · S/N 8524N8949CMorgan Aviation LLC · Greensboro, NCBuilt 1976 · S/N 28R-7635186N8949JSchmidt Roger L · Plattsmouth, NEBuilt 1965 · S/N 28-2969N8949RMorten Jesse L · Larimore, NDBuilt 1960 · S/N 7GC-165N8949WSullivan Sean · Fort Worth, TXBuilt 1964 · S/N 28-10522N8949ZBills Mark W · Willow, AKS/N MB 101N894ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881413N894ALLancaster Wesley A · Saint Augustine, FLBuilt 2003 · S/N 894N894CDSykes Richard D · Longmont, COBuilt 1995 · S/N 20893N894CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281864N894EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13236N894FSMiller Dietrick J · Monte Vista, COS/N 1507N894KCFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10742N894MAHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020134N894MJWaite Richard H · Sun Valley, IDBuilt 1989 · S/N 1809035N894NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496609N894RVCox Aaron D · Kalama, WAS/N 1666N894YPodunk Planes LLC · Boulder, COBuilt 2009 · S/N 80151N895Ghosh Abhimanyu · Mojave, CABuilt 1978 · S/N AA5A0564N89503Menne Aviation LLC · Brooklyn Park, MNBuilt 1983 · S/N 17276007N8950FAloft · Haiku, HIS/N 15-0026N8950MPacific Flight Academy LLC · Honolulu, HIBuilt 1963 · S/N TD-558N8950UManley Steven T · Dallas, TXBuilt 1965 · S/N TD-641N8950WEthington Scott · Emmett, IDS/N 28-10523N8951DChadwick Stewart · Yuba City, CABuilt 1958 · S/N 22-6114N8951JMoehle Colleen M · Lincoln, ILBuilt 1966 · S/N 28-2971N8951LWoolslayer John P · Tulsa, OKBuilt 1974 · S/N AA1B-0401N8952CZell Zulu LLC · Greensboro, NCBuilt 1976 · S/N 32-7600010N8952WPollock William J · Agawam, MABuilt 1964 · S/N 28-10525N89531Glynco Manning Aviation Inc · Brunswick, GABuilt 1978 · S/N 15282771N89533Ashby Shawn Alan · San Luis Obispo, CABuilt 1978 · S/N 15282773N89539Jkg LLC · Murfreesboro, TNBuilt 1978 · S/N 15282775N8953DVassal Ministries · North Pole, AKBuilt 1958 · S/N 22-6112N8953WKinser Aviation LLC · Guthrie, OKBuilt 1964 · S/N 28-10526N89549Jodkin Jason J · Confluence, PAFirst renewal noticeBuilt 1978 · S/N 15282781N8955WSides Michael E · Bartley, NEBuilt 1964 · S/N 28-10529N8955YCarter Howard A III · Stafford, VABuilt 1971 · S/N 39-115N8956Martini Philip D · Bethel Park, PABuilt 1973 · S/N 123-74N8956CCosper Rodney S · Killeen, TXS/N 18-2934N8956JBays Bob D · Jasper, MOBuilt 1965 · S/N 28-2977N8956WHalleck Brandon R · Terre Haute, INBuilt 1964 · S/N 28-10530N8956YDark Side Aeronautical Inc · Wilmington, DEBuilt 1971 · S/N 39-116N8957CTracon Aviation LLC · Winter Springs, FLBuilt 1976 · S/N 28-7625137N8957JAirplane LLC · Farmington, UTBuilt 1965 · S/N 28-2978N8957VN8957v LLC · Fort Lauderdale, FLBuilt 1974 · S/N 17264313N8958English John H · Pittsburg, TXBuilt 1973 · S/N 610-74N89585Vinland Flight School LLC · Topeka, KSBuilt 1978 · S/N 15282796N89588Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15282797N8958CWinter John T · Tucson, AZBuilt 1976 · S/N 28-7625138
Back to AD 81-18-04 R2