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.

N72MRSnide Thomas C · Dublin, OHBuilt 1998 · S/N 18280123N72MVBeck Douglas J · Lincoln, NEBuilt 2001 · S/N 80842BN72MWStaggs Austin · Cudjoe Key, FLBuilt 1963 · S/N 30-171N72NEr Flight LLC · Reedsville, PABuilt 1971 · S/N 28-7205125N72NVCarroll Cecil Dean · Dexter, MOBuilt 2009 · S/N 70086N72NXNexair Avionics LLC · Plymouth, MABuilt 1976 · S/N 17267923N72PGFox William Casey Trustee · Pipe Creek, TXBuilt 1998 · S/N 631N72PMAircraft & Aviation Professionals LLC · Coldwater, MIS/N AA1A-0426N72QTRegistered aircraftBuilt 1972 · S/N 365-72N72RCSchmid Mark D · Haddon Heights, NJBuilt 1996 · S/N 459N72RJEngerer Dennis E · Northville, MIBuilt 1968 · S/N 28R-30891N72RMSparks Brian E · Monmouth, ORBuilt 1981 · S/N 8020CN72RPVisscher Fred D · Madison, GABuilt 1952 · S/N 18-2214N72RVHarral Blake G · Prescott Valley, AZFirst renewal noticeBuilt 1999 · S/N 2401N72SFMcintosh Stephen · Fishers, INBuilt 2003 · S/N 3053N72STSierra Tango Air LLC · Senoia, GAS/N 17269433N72TGuazzerotti Fred · Mooresville, NCBuilt 1979 · S/N AA5B1086N72TDHerzog Eric M · New Waverly, TXS/N 1076N72USUnited States Aviation Underwriters Inc · Toledo, OHBuilt 2001 · S/N 18280936N72VBVan Bladeren Ronald W · Vancouver, WABuilt 2003 · S/N 81548N72VMFreeman Monty W · Kansas City, MOBuilt 2001 · S/N 2114N72WACrosby Seth J · Anchorage, AKS/N WA-72N72WGJaja Properties LLC · Laurinburg, NCS/N 28-7310033N72WJKinnard Harris P · Pensacola, FLBuilt 1988 · S/N 72N72WLSingleton Colin · Walkerton, INBuilt 1994 · S/N 21063N72WMPalmer Phillip · Manchester, NHBuilt 1986 · S/N 6746N72WNPatmor Richard D Trustee · Dayton, NVBuilt 2006 · S/N 879-320-676N72WRFratzke Nathan A · Sterling, AKS/N 18-8982N73001Spooter Air LLC · Obion, TNBuilt 1976 · S/N 17267232N7300DClendaniel Randon · Desert Hot Springs, CAS/N 22-5087N7300LBarlow Tyrone J · St George, UTBuilt 1972 · S/N AA5-0230N7300SHerring Alan T · Laredo, TXBuilt 1981 · S/N R18201702N7300WTaylor Robert P · Bothell, WABuilt 1963 · S/N 28-1064N7300YAdriatic Holdings LLC · Cheyenne, WYBuilt 1964 · S/N 30-341N73010Rico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17267235N73015Alameda Flying Club Inc · Richmond, CABuilt 1976 · S/N 17267238N7301DGrant Cary · Cave Creek, AZBuilt 1957 · S/N 22-5088N7301FMcpherson Alan · Big Bend Ntl Park, TXBuilt 1968 · S/N 28-25213N7301GFreeport Flyers Inc · Freeport, ILBuilt 1970 · S/N 17259001N7301JJach Joshua Spenser · Grand Prairie, TXBuilt 1968 · S/N 28-24596N7301WFry Mark · Danville, PABuilt 1977 · S/N R18200051N73020Ajf Enterprises LLC · Des Moines, IABuilt 1976 · S/N 17267239N73028Halley Craig H · Lanai City, HIBuilt 1976 · S/N 17267241N7302GSmith Neil W · Rincon, GABuilt 1970 · S/N 17259002N7302WSanders Robert E · Whitewater, MOBuilt 1977 · S/N R18200052N7302YJohnson Robert Daniel · Seabrook, TXBuilt 1964 · S/N 30-345N7303FAyrey Elias · Bellingham, WABuilt 1968 · S/N 28-25215N7303JButtleman Robert L · Traverse City, MIBuilt 1968 · S/N 28-24588N7303PWeisend Chad · Peru, INBuilt 1961 · S/N 24-2478N7303YCedar River Flyers · Seattle, WABuilt 1977 · S/N R18200114
Back to AD 81-18-04 R2