OpenAirDocs.org
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.

N5187ENowak Michael J · Waxahachie, TXBuilt 1978 · S/N 17271760N5187GThompson Edward A · Sunset Beach, NCBuilt 1979 · S/N 17273555N5187HJinnette Michael E · Lafayette, COS/N 14-505N5187JDagger Falls LLC · Boise, IDBuilt 1979 · S/N 313-79N5187LMcclelland Kip · Douglas, GAS/N 28-4475N5187RTke Ltd · Thief River Falls, MNBuilt 1974 · S/N 17263404N5187TLopes Steve R · Lancaster, WIBuilt 1967 · S/N 14N5187WGardner Robert E · Dixon, CABuilt 1961 · S/N 28-222N5187XBerkeland Jacob J · Bricelyn, MNBuilt 1969 · S/N 685N5187ZCottrell Mark C · Leitchfield, KYS/N 22-8854N51883Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274371N51885Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274372N5188HHartley Jerome K · Talkeetna, AKBuilt 1949 · S/N 14-506N5188LMascari Nicholas M · Mundelein, ILBuilt 2002 · S/N 18281112N5188SMiller Kaci · Bullhead City, AZBuilt 1970 · S/N 28-7105046N5188TCohen Edward R · Loomis, CABuilt 2002 · S/N 18281113N5188XMullahy Patrick O · Burlington, IABuilt 1969 · S/N 686N5188YElliott William R · Reno, NVBuilt 1962 · S/N 27-2235N51890Hyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 17274375N5189BFreedom Aviation Of America LLC · Newcastle, TXBuilt 1979 · S/N 15283797N5189LMicic Miodrag · Lake Elsinore, CABuilt 1968 · S/N 28-5129N5189SBender Douglas E · Kendallville, INBuilt 1970 · S/N 28-7105049N5189TZerck Joseph W · Anchorage, AKBuilt 1967 · S/N 199N5189ZNorthwest Florida State College · Niceville, FLBuilt 1961 · S/N 22-8856N518ACGernand Charles · Hoopeston, ILBuilt 2000 · S/N 448-2000N518AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2021 · S/N 28020047N518APWilliams Brian K · Mattituck, NYS/N M-1869N518BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842258N518BDM&B Onboard LLC · Lineville, ALBuilt 1973 · S/N BH120/205N518BW8bravo Wiskey LLC · New Liberty, KYBuilt 1974 · S/N 28-7405240N518CACompass Aviation Inc · Shelby, NCBuilt 1979 · S/N 17273049N518CMTreakle Robert W · Austin, TXFirst renewal noticeBuilt 1967 · S/N 30-1594N518CRM & A Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 18280281N518DPN518dp LLC · Spruce Pine, NCBuilt 1966 · S/N 32-765N518ERoland Kenneth R · Tell City, INS/N R-G-H-1N518EGStyer David B · Pendleton, ORS/N 812N518GMMountain Escape LLC · Pullman, WABuilt 1953 · S/N 18-2643N518JSDubbs Chad T · Naples, FLBuilt 2003 · S/N 3246212N518PLMoore David P Trustee · Chattanooga, TNBuilt 1975 · S/N AA5B-0144N518PUSalim Omar J · Olympia, WABuilt 1983 · S/N 172RG1135N518RMWinkelmann Pete J · North Fond Du Lac, WIBuilt 2002 · S/N 60099N518RVFehrs Aviation LLC · Seminole, TXBuilt 2011 · S/N 40518N518SDDykstra Scott E · Jenison, MIBuilt 2019 · S/N SD001N518SPGreater Flint Pilots Associations Inc · Flushing, MIBuilt 2000 · S/N 172S8379N518SWGilchrist Robert T · White Salmon, WABuilt 1955 · S/N 18-4389N518TPos LLC · Glencoe, MOS/N 3466N518TCBedell Gary L · Henderson, NVBuilt 2001 · S/N 9932CCN518TPFaber James A · Coppell, TXBuilt 2012 · S/N 40639N518TRCorrina Cumulus LLC · Kalispell, MTBuilt 2001 · S/N 22518N5190JAoa Kissimmee Inc · Kissimmee, FLBuilt 2002 · S/N 172S9151
Back to AD 81-18-04 R2