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.

N379SSky Chasers LLC · Mount Vernon, WABuilt 1980 · S/N R18201681N379TAChuck Smith Aircraft Inc · Torrance, CABuilt 2003 · S/N 172S9379N379XCjr Air Service LLC · Saint Louis, MOBuilt 1976 · S/N 7011CN37AGWalker Robert J · West Finley, PABuilt 1990 · S/N AG-5N37AHHand Andy A · Waco, TXBuilt 2020 · S/N 3348N37ARFlowers Charles L · Yelm, WABuilt 1999 · S/N 1134N37AWCcx-2000-0111 LLC · Garberville, CABuilt 1999 · S/N 2020N37BHHuelsman Bradley D · Dayton, OHBuilt 1996 · S/N AE92-101N37BKChanging Horizons LLC · Helena, MTBuilt 2004 · S/N 10542N37BTStucki Andre O · Deerfield Beach, FLBuilt 1981 · S/N 32R-8113083N37BYTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 951-2004N37CJFly172s LLC · Peoria, AZBuilt 1999 · S/N 172S8232N37CPRegistered aircraftBuilt 2012 · S/N 40795N37DAero Equities LLC · Ventura, CABuilt 1973 · S/N 570-73N37DKPreston Richard R Trustee · Albuquerque, NMBuilt 1978 · S/N GA7-0030N37DMWilliams Arzania S · Bolingbrook, ILBuilt 1968 · S/N 28-25245N37DNAshmore Seth S · Scottsboro, ALS/N 1030N37DRRegistration Pending · Redlands, CARegistration pendingS/N 217N37ELLee Ed C · Lancaster, SCBuilt 2002 · S/N 90361N37EZCaulkins John · Bay Village, OHBuilt 2003 · S/N 2198LN37FLN37fl LLC · Port Saint Lucie, FLBuilt 2020 · S/N 41658N37GGAvco Patrol LLC · Lyndon, KSBuilt 1999 · S/N 18280353N37GWSale Reported · Webster, MNSale reportedBuilt 2017 · S/N 50N37HDJohnston-Matejek Aviation LLC · Houston, TXBuilt 2006 · S/N 18281850N37HMRegistration Pending · West End, NCRegistration pendingBuilt 1981 · S/N TRGR-1N37HUNo Fear Aviation LLC · Madison, WIBuilt 2024 · S/N 3437N37HYRegistration Pending · Wasilla, AKRegistration pendingBuilt 1999 · S/N 2037N37JJMamuzich Robert J Jr · Ocala, FLBuilt 1987 · S/N 1243N37JNWings As Eagles Mission Air Service Inc · Oshkosh, WIBuilt 1997 · S/N 5373N37JR0s9 LLC · Poulsbo, WABuilt 1955 · S/N 18-3758N37KFFillips Karl · Alvin, TXS/N 317-77N37KTJr Ace LLC · Indianapolis, INBuilt 2001 · S/N 1N37LMMay Richard A · Fort Mill, SCBuilt 1971 · S/N 170N37LVLegros Aviation Services Inc · Crowley, LABuilt 1992 · S/N 695-92N37MFMueller Martin S · Coeur D Alene, IDS/N FREEMAN S T #1N37MLLacher Meldon J · El Cajon, CABuilt 1999 · S/N 001N37MTBeaver Valley Flying Club Inc · Beaver Falls, PABuilt 1999 · S/N 172S8205N37MVMonreal Michael · North Barrington, ILBuilt 1969 · S/N 32-40657N37MZHamm George W Trustee · Fort Worth, TXBuilt 2013 · S/N 70628N37NCGlace Charles L · Spartanburg, SCBuilt 2010 · S/N 1079N37NERotor Technologies Inc · Nashua, NHBuilt 1994 · S/N 2450N37NHLfs Inc · Ekalaka, MTFirst renewal noticeBuilt 2008 · S/N 3028N37PVan De Pol John M · Amherst, TXS/N 21564N37PDDannenberg Paul A · Zeeland, MIBuilt 2001 · S/N 001N37PHHoye Michael B · Heath, TXBuilt 2000 · S/N 001N37PKThill James L · Leesburg, VABuilt 2001 · S/N 80890N37PRS & R Planes LLC · Tulsa, OKBuilt 1950 · S/N 18-90N37RGMindspring LLC · New Orleans, LAFirst renewal noticeBuilt 1991 · S/N 2099N37RHRegistered aircraftBuilt 1995 · S/N 22585N37RKWardrop Donald Alexander · Bay Springs, MSBuilt 1985 · S/N 482
Back to AD 81-18-04 R2