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.

N5344YMerced County Mosquito Abatement District · Merced, CABuilt 1963 · S/N 27-2418N53455Real Robert · Miami, FLBuilt 2002 · S/N 3246204N53456Amelia Reid Aviation LLC · San Jose, CABuilt 1981 · S/N 17274754N5345FArcher Air LLC · Traverse City, MIBuilt 1976 · S/N 28-7790093N5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LABuilt 1980 · S/N 15284549N5345WShisler Bill · Missoula, MTBuilt 1962 · S/N 28-404N53460L & W Leasing LLC · Smyrna, TNBuilt 2003 · S/N 172S9351N53463Fara Nick · San Anselmo, CABuilt 1981 · S/N 17274758N53468Maya Aircraft Holdings LLC · Lee, NHBuilt 2003 · S/N 172S9394N5346DBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17272534N5346EOsprey Holding Company LLC · Foley, ALBuilt 1977 · S/N 17269573N5346FSo Send I You LLC · Cheyenne, WYS/N 28-7790094N5346KUsaeroflight LLC · Greenville, SCS/N 17274075N5346PBelt David Jr · White Hall, MDBuilt 1958 · S/N 24-391N5346UAverett University · Danville, VABuilt 2003 · S/N 2843542N5346VRegistered aircraftBuilt 1980 · S/N 172RG0510N53474Executive Air Taxi Corp · Bismarck, NDBuilt 2003 · S/N 172S9376N5347FDeland Aviation LLC · Deland, FLBuilt 1976 · S/N 28R-7635453N5347HMonterey Bay Aviation Inc · Watsonville, CABuilt 1975 · S/N 17265410N5347LKing Michael · Durango, COBuilt 1968 · S/N 28-4650N5348BBowers Curt E · Jennings, LABuilt 1979 · S/N 15283844N5348DSwaz Aviation LLC · Mesa, AZBuilt 1979 · S/N 17272536N5348EDexter Brady R · Chambers, NEBuilt 2003 · S/N 18281212N5348LPn4 Aviation Holdings LLC · Bishop, CAS/N 28-4651N5348PPari Aviation LLC · Marion, TXBuilt 1958 · S/N 24-395N5348TDavis Samuel T · Malad City, IDS/N 18-8009009N5348VKavon Clinreg LLC · Palm Beach Gardens, FLBuilt 1980 · S/N 172RG0511N5348ZDavis Robert D · Shongaloo, LABuilt 1961 · S/N 22-9068N53491Crossbrook LLC · Willoughby, OHBuilt 1981 · S/N 17274764N53494Gandarillas Andrew J · Toledo, WABuilt 1981 · S/N 17274765N5349DFisher Randall A · Salem, OHBuilt 1979 · S/N 17272537N5349LHart Brad S · Elephant Butte, NMS/N 28-4652N534APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843754N534CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881278N534DWValiair Ltd Co Trustee · Casper, WYBuilt 1976 · S/N 177RG1004N534EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13165N534FLGray Gary G · Kansas City, MOBuilt 1971 · S/N 28-7125364N534KSKent State University · Stow, OHBuilt 2012 · S/N 172S11241N534LU.S. Department Of The Interior · Boise, IDBuilt 2015 · S/N CC18-0075N534MPJones David C · Williston, VTBuilt 1991 · S/N 10066N534RHAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13473N534SASpur Aviation Services Lc · Twin Falls, IDBuilt 1968 · S/N 1816-22N534WCPrenter Christian E · Hermosa Beach, CABuilt 2002 · S/N 60473N53507Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274769N5350KCenterline Aviation LLC · Oklahoma City, OKBuilt 1980 · S/N 17274076N5350LN5350l LLC · Statesville, NCFirst renewal noticeBuilt 1968 · S/N 28-4653N5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1980 · S/N 15284553N5350PChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15284924N5350SSilver Tree LLC · Southern Pines, NCS/N R18201551N5350ZAgalotis Paul E · San Martin, CABuilt 1961 · S/N 22-9071
Back to AD 81-18-04 R2