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.

N979SHNovember Alpha LLC · Los Angeles, CABuilt 2006 · S/N 4073N979WDDolphin Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S10077N97ACReber Tim · Terrace Park, OHBuilt 1993 · S/N 706-93N97ADCunningham David · Thomasville, NCBuilt 1967 · S/N 28-22666N97AFArmstrong Aviation LLC · Ogallala, NEBuilt 1997 · S/N 2118N97APTruitt James B · Evansville, INBuilt 2011 · S/N 82099N97ATRainier Flight Service LLC · Renton, WABuilt 2005 · S/N 172S9853N97BCGuy George Hopkins III · Saratoga, CABuilt 2008 · S/N 510-2008N97BMZawodny Jeremy D · Groveland, CABuilt 1997 · S/N 5342N97BSSidewinder Services LLC · Genoa, NVBuilt 1973 · S/N 17262475N97BTMccullagh John A · Sugar Land, TXBuilt 1998 · S/N AV1075N97CREsmailka Harold E DBA · Ruby, AKBuilt 1977 · S/N 32R-7780078N97CVHigginson Robert W · Minooka, ILBuilt 2022 · S/N 1482-2022N97DJSilva Ronald C · Rescue, CABuilt 1995 · S/N 23257N97DVWaugh Terry R · Phoenix, AZBuilt 1977 · S/N AA5B0455N97ECCollum Auto Transport LLC · Milton, FLBuilt 1995 · S/N 0019N97EEMcnary Richard C · Eatonville, WAS/N 92075N97FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13207N97FRSmith Ralph E · Lyndonville, NYBuilt 1980 · S/N 17274188N97FZRegistered aircraftBuilt 1997 · S/N 79697N97GBTaf Aerial Servics LLC · Beeville, TXBuilt 1996 · S/N 14089CN97GCMohr Ronald G · Trenton, SCS/N 25611N97GHHoward Gregory · Beaverton, ORBuilt 1999 · S/N G2001014N97GLHarrison Christopher J · Danville, CAS/N 0709N97GPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1998 · S/N 1837N97HPPoutre Robert Paul Trustee · Osceola, WIBuilt 2003 · S/N NF0002N97HRRoberts Harold S DBA · Spartanburg, SCBuilt 1965 · S/N 32-73N97HUBamboo Land LLC · Tallahassee, FLBuilt 2018 · S/N 3297N97HWMarshall Robert W · Redlands, CABuilt 2022 · S/N 600N97JC7 Star Aviation LLC · Addison, TXBuilt 2021 · S/N 3367N97JEJolly Anthony G · Carthage, MSS/N 23194N97JNHowe Brian J · Wilsonville, ORS/N A-4N97JSHarbold Norris B Jr · Clover, SCBuilt 1951 · S/N 156-194N97JVVanbeber Jacob P · Boonville, NYS/N 8-0107N97JWDorn Albert William II Trustee · Tucson, AZBuilt 1978 · S/N R18200652N97KBBelue Kevin D · Madison, ALBuilt 2002 · S/N 25003N97KDYoakley Donald W · Fleming Island, FLBuilt 2014 · S/N 3332N97LAWhite Eagle 3 LLC · Wilmington, DEBuilt 1997 · S/N 3246076N97LHSteele James W · Nampa, IDBuilt 2001 · S/N 001N97LKKnife Edge LLC · N Redngtn Bch, FLBuilt 1997 · S/N 792-97N97LRAtwill Brock · Paragould, ARBuilt 1980 · S/N 28-8011116N97LWAdkins Clinton R · Corvallis, MTBuilt 2007 · S/N 3573N97LZZwijacz Michael F · South Lake Tahoe, CABuilt 1997 · S/N 000197N97MBNelson Garrett D · Bonney Lake, WABuilt 2004 · S/N 60142N97MMRegistered aircraftBuilt 2006 · S/N 81389N97MRRebel Back Home LLC · Waterford, MIS/N 426-REBN97MSJesnowski J Luke · Atchison, KSBuilt 2003 · S/N 01SN97MWRudderworks Aviation LLC · Fairfax Station, VABuilt 1975 · S/N 17264946N97NNAviation Business Corp · Saint Louis, MOS/N 23-435N97NTChasteen Coleman C · Keller, TXBuilt 1998 · S/N 001
Back to AD 81-18-04 R2