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.

N59DTN59dt Inc · Malabar, FLBuilt 1998 · S/N 5360N59EAHorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26173N59EEKern Raymond L · Bedford, INS/N 27-3390N59EFTancredi Andrew D · Germantown, TNBuilt 2004 · S/N 18281359N59FBCox Steven D · Evergreen, COBuilt 2003 · S/N 81047N59FDPollux Aviation Ltd · Wasilla, AKBuilt 2004 · S/N 10460N59FFPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 172S12933N59FSRegistration Pending · Yazoo City, MSRegistration pendingBuilt 2005 · S/N 2109N59GFFisher George A · Earleville, MDS/N 136N59GRTkaczyk Gary J · Canton, MIBuilt 1981 · S/N 32-8106093N59GTMarianas Mission Aviation Inc · Tamuning, GUBuilt 1975 · S/N AA5B-0028N59HYRitter Mark C · Austin, TXBuilt 2001 · S/N 2159N59JAHare Michael R · Nye, MTBuilt 2001 · S/N 80819N59JHFlying Circus Pictures · Los Angeles, CAS/N 70048N59KBBond Kent F · Woods Cross, UTBuilt 2019 · S/N BONDI-1N59KCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 2018N59LAAlphin Lewis Jackson · Mount Olive, NCBuilt 1999 · S/N 430-99N59LGWillig Louis · Penn Valley, PABuilt 2011 · S/N 11406N59LHSpillman Robert L DBA · Port Orange, FLBuilt 2003 · S/N 81202N59LJL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281043N59LPHalkett Blair Ross · Knoxville, TNBuilt 1999 · S/N 001N59LTHall Morgan R · Los Osos, CABuilt 2008 · S/N 2044N59LVGreek John W · Tustin, CABuilt 1959 · S/N 24-1229N59MSSojka Michael J · Bainbridge, INBuilt 1994 · S/N 735-94N59PGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260347N59PHSeider Jason · Dallas, TXBuilt 1968 · S/N 680116N59PMPyland Jack · Seagoville, TXBuilt 2007 · S/N 075N59PPJohnson Monte W · La Porte, INBuilt 1960 · S/N 1646N59RBRegistered aircraftBuilt 1994 · S/N B-3N59RHSmith Mikeal A · Acton, CABuilt 1959 · S/N 24-1006N59RVNghiem Daniel · Westminster, CABuilt 1995 · S/N RV21635N59SMChandler Ronald J S · Tucson, AZBuilt 1997 · S/N 21734N59SRRaeder James · Caldwell, IDS/N 001N59SWLg Services LLC · Chino, CABuilt 1966 · S/N 32-753N59TPeters Willie W · Brownfield, TXBuilt 1990 · S/N 20225N59TDDavison Terry W · Melba, IDBuilt 2010 · S/N 72688N59TPRegistered aircraftBuilt 2012 · S/N 82534N59TWAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13249N59VLKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259905N59WBWhiskey Bravo LLC · Scottsdale, AZBuilt 1990 · S/N 1571N59WDHorner Michael W · Manakin Sabot, VABuilt 2007 · S/N 1423-2007N59WLHerrmann Mark D · Dillingham, AKS/N 269-70N59WMHudson River Wings LLC · Montclair, NJBuilt 1991 · S/N 10037N59WYHat Trick Aviation LLC · Coeur D Alene, IDBuilt 2020 · S/N 3354N59YLPanariello Gary F · Sausalito, CABuilt 2018 · S/N 82381N59YYBay Richard P · West Jordan, UTBuilt 1960 · S/N 56429N5AASimanski Charles J · Onley, VABuilt 1973 · S/N 28-7325670N5ADCraig Philip A Jr · West Richland, WABuilt 1992 · S/N 20954N5ARCraig William O · Holland, MIBuilt 1978 · S/N 7211CN5AUCrosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 28-7725239
Back to AD 81-18-04 R2