OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N3059GStulp Annessa C · Lamar, COBuilt 1968 · S/N 37N3059RTimes Arrow LLC · Highland, MDBuilt 1969 · S/N 28R-35620N3059SRatte Clifford H · Gulf Breeze, FLBuilt 1979 · S/N 28R-7918061N305BSAllen Andra L · Gila, NMBuilt 1999 · S/N S1796N305CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11532N305DKWashington State Patrol · Olympia, WABuilt 1999 · S/N 20608080N305DWPugleasa William Hunter · Lowell, ARBuilt 1982 · S/N 15285502N305JRHarrison Aviation LLC · Salem, ORBuilt 2005 · S/N 18281692N305KGBelisle Kenneth C · Jacksonville, FLS/N SN038N305KTAlvord Jonathan Drew · Prosser, WABuilt 2010 · S/N 40064N305MDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020255N305NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881616N305NKKamasano LLC · Highland, CABuilt 2001 · S/N 3163N305PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264131N305RCWashington State Patrol · Olympia, WABuilt 2001 · S/N 18281001N305RSElite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 172S8834N305SNMeshoppen Air LLC · Tunkhannock, PABuilt 1984 · S/N 2038N305TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13227N305UMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020051N305XXDs Group LLC · Miami, FLBuilt 1975 · S/N 17265513N30602Reinert Joseph M · Ringgold, GAS/N 28-8011055N30603Registered aircraftBuilt 1969 · S/N 17701353N30608Christiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496180N3060BPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7990139N3060FEl Paso Aero Inc · El Paso, TXBuilt 1978 · S/N 28-7990227N3060LLang Scott T · Waseca, MNBuilt 1979 · S/N 28-7916251N3060RArrow N3060r LLC · Sheridan, WYBuilt 1969 · S/N 28R-35621N3060YB&D Flight Club LLC · Portage, INBuilt 1979 · S/N 28-7916370N30612Wheeler Vincent · Harwinton, CTBuilt 1969 · S/N 17701360N30615Yanichko Robert · Weeki Wachee, FLBuilt 1969 · S/N 17701362N30617Executive Flight Training & Services LLC · Sanford, NCBuilt 1974 · S/N 17264149N3061MSchmidt Anthony D Jr · Jordan, MNBuilt 1947 · S/N 12-1749N3061RCohns Willie · Elizabethtown, KYBuilt 1969 · S/N 28R-35622N3061WCcn Air LLC · Bloomington, INBuilt 1979 · S/N 32-7940079N3061YHott Steven A · Kokomo, INBuilt 1979 · S/N 28-7990388N3061ZKell Thomas G · Anchorage, AKS/N 22-7016N30622Money Aerial Media LLC · San Diego, CABuilt 1940 · S/N 5-223N30626Hoese Ray D · San Antonio, TXBuilt 1969 · S/N 17701368N3062LMerino Rodrigo R · Chilton, WIBuilt 1979 · S/N 28-7916252N3062MRegistered aircraftS/N 12-1583N3062RBuddys Aviation LLC · East Bernstadt, KYBuilt 1979 · S/N 32R-7985084N3062SRiver City Aviation LLC · Carmichael, CABuilt 1967 · S/N 15066962N3062WD M Aviation II Llp · Park River, NDBuilt 1979 · S/N 32-7940080N3062YSwaringen Jeanne A · Lakeside, CABuilt 1979 · S/N 28-7990389N3062ZSchofield Wayne D · Polson, MTBuilt 1959 · S/N 22-7017N30630Erickson Keith E · Anchorage, AKS/N 17701369N30632Evv Pilots Club Inc · Evansville, INFirst renewal noticeBuilt 1969 · S/N 17701371N30634Beck Alan · Las Vegas, NVBuilt 1969 · S/N 17701372N30636Schub William C · Oakdale, NYBuilt 1969 · S/N 17701373N30637Diamond Paul · Londonderry, NHBuilt 1969 · S/N 17701374
Back to AD 81-18-04 R2