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.

N949GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881225N949KEPureflight Aviation Training LLC · Newberg, ORBuilt 2019 · S/N 1260N949MRivera Justin J · Orlando, FLFirst renewal noticeBuilt 2001 · S/N 80540N949MDUnruh Leasing LLC · Blossom, TXBuilt 1973 · S/N 21059889N949MWMgm Landing LLC · Lewes, DEBuilt 2014 · S/N 1143-2014N949PHedgpeth Richard L · Evergreen, NCBuilt 1960 · S/N 24-1851N949PWMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1970 · S/N 121N949RVVan Wagenen Stanley Keith Trustee · Las Vegas, NVBuilt 2003 · S/N 90369N949SMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 172RG0713N949SPN949sp LLC · California, MDBuilt 1999 · S/N 172S8145N949TEBarron Wesley Thomas · Port Orange, FLBuilt 2003 · S/N 10228N949TSSmith Emmet Q · Portola, CABuilt 2018 · S/N 0818N949WParrish Shawn J · Great Falls, MTBuilt 2010 · S/N 90467N949WCCampbell Weldon W · Great Bend, KSBuilt 1997 · S/N 23469N949WRMurley Kent K · Sequim, WABuilt 2000 · S/N 3RX073N949ZDunn Michael S · Pendleton, SCBuilt 1964 · S/N 1ST64N94AAPhillabaum Stephen D · Deer Park, WABuilt 2011 · S/N 11424N94ABMiller Paul · El Dorado Springs, MOBuilt 1994 · S/N 21923N94AGSimmons Mark A DBA · Pawcatuck, CTBuilt 1998 · S/N 23052CN94AKWestern Aviation LLC · Bloomfield, MIBuilt 1996 · S/N 32-46043N94AXJudd Howard C · Tehachapi, CABuilt 2003 · S/N G202-016N94BDMcelwain Russell D · Lancaster, KSBuilt 1999 · S/N 80379N94BMRambarran Brian · Clarence Center, NYBuilt 2008 · S/N 1066-2008N94BNRegistered aircraftBuilt 2008 · S/N 91038N94BRSingletrack Aviation LLC · Brecksville, OHBuilt 2025 · S/N 1487-2025N94BSMcdonnell John T · Yardley, PABuilt 1989 · S/N 2N94CLEasterbrooks Paul · Chesapeake, VABuilt 1978 · S/N AA5B0742N94CPAhlhorn Travis Wayne · New Braunfels, TXBuilt 1979 · S/N 17273150N94CRGilbert Michael John · Louisville, KYBuilt 1999 · S/N 22297N94DBFox Joseph L · Ocean City, NJBuilt 1983 · S/N 362N94DFBesa Aircraft Corp · Lafayette Hill, PAS/N 61P-0279-062N94DGGreen Daryl K · Grove City, OHBuilt 2005 · S/N 21507N94DLWhiskey November Aviation LLC · Minneapolis, MNBuilt 1973 · S/N 28-7415076N94DWTracy David B · West Haven, UTBuilt 2002 · S/N 80636N94DZHigh Desert Aero Holdings LLC · Portland, ORS/N 90718N94ERHill Andrew T · Smithville, TXBuilt 1983 · S/N 17276053N94FDBeaver Jonathan D · Greensboro, NCBuilt 2002 · S/N 81243N94FRFischer Michael A · Oak Park, ILBuilt 1995 · S/N FRF-1N94GCCook Gregory L · Carl Junction, MOBuilt 1994 · S/N 20020CN94GKBeech Baron LLC · Wilmington, NCBuilt 2022 · S/N 1206-2022N94HFDefenbaugh Matthew J · Biggsville, ILBuilt 1979 · S/N 1153-79N94HHHarris Hill Soaring Corp · Horseheads, NYBuilt 1969 · S/N 25-4331N94HJGable Taylor Lee · Nicholson, GABuilt 1975 · S/N 17265633N94HUTronstad John L · Baker, MTBuilt 1994 · S/N 1260N94HWLach John F · Warren, OHBuilt 2002 · S/N 90045N94HYWest Metro Aviation LLC · Buffalo, MNBuilt 2005 · S/N 2297N94KBBaker Bryn M · Clinton, UTBuilt 2000 · S/N 23929N94KDSprik Robert J · Hamilton, MIBuilt 1995 · S/N KD-03N94KKKokemiller Kelley M · Boone, IABuilt 2010 · S/N 91678N94KWHine Garrett Christopher · Panama City Beach, FLBuilt 1994 · S/N 19026C
Back to AD 81-18-04 R2