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.

N5677LDuncan Lincoln · Dix, ILBuilt 1969 · S/N AA1-0077N5677PMourouzis Jack · Indianapolis, INBuilt 1959 · S/N 24-749N5677QDeramus Doris L Executor · El Paso, TXS/N 3037N5677UGolden Age Aviation LLC · Naperville, ILBuilt 1969 · S/N 28-26474N5677WLangel Brandon · Saint Charles, MOS/N 28-909N56780Stewart Donald Kent · Denver, NCBuilt 1973 · S/N 28R-7435041N56782Avie Ation LLC · Suwanee, GABuilt 1973 · S/N 34-7450031N56783Dennerline Rhett R · Northfield, ILBuilt 1973 · S/N 28-7425035N56786Janda Robert J · Grafton, OHBuilt 1973 · S/N 28-7415012N56788Osgood Aaron · Glen Mills, PABuilt 1973 · S/N 28-7405031N5678NRedwood Area Flyers LLC · Springfield, MNBuilt 1966 · S/N 0292N5678PWhite John O · Camarillo, CABuilt 1959 · S/N 24-750N5678QPerkins C Trent B · Naubinway, MIBuilt 1965 · S/N 695N5678UPaul William R · Oconomowoc, WIBuilt 1969 · S/N 28-26475N5678WMckinney Douglas Andrew · Hastings, MNBuilt 1963 · S/N 28-913N5678YTaildragger LLC · Glade Spring, VAS/N 18-8317N56790Bradfield Breyson · Mandaree, NDBuilt 1973 · S/N 28R-7435042N56791Brosher Melvin G · Decaturville, TNS/N 28R-7435043N56793Dodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 32-7400009N56798Warrior Airways LLC · Coral Springs, FLBuilt 1973 · S/N 28-7415013N5679DAce Flight Center Inc · Saint Thomas, VIFirst renewal noticeBuilt 1959 · S/N TD-188N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751N5679QLambert John D · El Paso, TXBuilt 1965 · S/N 3038N5679SWinters Kevin L · Nine Mile Falls, WABuilt 1966 · S/N MB-122N5679UInverted Holdings LLC · Newnan, GABuilt 1969 · S/N 28-26476N567AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11418N567BBBeers Suzanne M · Colorado Springs, COBuilt 1973 · S/N 17701880N567CPCivil Air Patrol · Maxwell Afb, ALS/N 18282167N567DDAir America Flight Center LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9971N567DHDoyel Landy N · Klamath Falls, ORBuilt 1998 · S/N 5152N567FLRidgeline Assets LLC · Wilmington, DEBuilt 2026 · S/N 4496643N567GAAdkins Gordon L · Kenova, WVBuilt 2004 · S/N 3668N567JBenike Ross A · Birchdale, MNBuilt 2002 · S/N 5677N567JWKingdom Power And Glory LLC · Colorado Springs, COBuilt 1999 · S/N 172S8187N567KKCapobianco Melissa M · Magee, MSS/N JS-JK-WN567KSKing Sky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15282634N567LUS Department Of The Interior · Boise, IDBuilt 2016 · S/N CC18-0080N567MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.308N567NDMoore Aviation Inc · Beaver Falls, PABuilt 2008 · S/N 172S10805N567RVMarini Robert A · Brighton, COBuilt 1991 · S/N 20567-RV6N567SFCockpit LLC · Melbourne, FLS/N 002N567SHSpitzer Helicopter LLC · Wilmington, DEBuilt 2008 · S/N 1859N567SPAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12705N567TB567tb LLC · Rockford, OHBuilt 1999 · S/N 1915N567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationBuilt 1970 · S/N 39-63N567VEEngbring Jered · Durango, COBuilt 2026 · S/N JE001N56809Hudak Susanne Marie · Gold Canyon, AZS/N 28-7425041N5680HEpting Robert L · Chapel Hill, NCBuilt 1949 · S/N 16-292N5680LStackpole Thomas M · Temecula, CABuilt 1969 · S/N AA1-0080N5680VTime To Fly LLC · Cleveland, MSBuilt 1977 · S/N 28-7716198
Back to AD 81-18-04 R2