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.

N78890Edmondson Donald M · Harvest, ALBuilt 1964 · S/N 2905N78891Registered aircraftBuilt 1964 · S/N 2906N78892Rathbun Robert E · Maywood, MOS/N 2907N78893King Eugene A · Rch Palos Vrd, CABuilt 1964 · S/N 2908N78894Gonzalez Francisco C · Biloxi, MSBuilt 1965 · S/N 2909N78897Knox Phillip A · Snellville, GABuilt 1964 · S/N 2912N78898Clawson Michael · Allentown, NJS/N 2913N7889GFricker Mark W · Avon, INFirst renewal noticeBuilt 1970 · S/N 17259589N7889PWalker Zachary R · Burlington, NDBuilt 1963 · S/N 2403N7889VPoorman Christopher · Burleson, TXBuilt 1964 · S/N 2851N7889WBetts Paula H · Valparaiso, INBuilt 1964 · S/N 28-1913N788BGSeminole Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 4496143N788BWNelson Thomas H Jr · Chatham, MSBuilt 1997 · S/N 1230-97N788CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281777N788FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13166N788JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020088N788JBIsert Brian L · Melba, IDBuilt 2018 · S/N 40335N788MCRoberts James A · Edina, MNBuilt 1978 · S/N 17270430N788RKSalomonsson Mats E · Hayward, CAS/N 28-24831N788RMVan Bortel Aircraft Inc · Arlington, TXBuilt 2012 · S/N 18282321N788RVHigh Flight Aviation Inc · Wilmington, DEBuilt 2008 · S/N 82297N788SStrauss Richard A · Palm City, FLBuilt 1981 · S/N 32R-8113097N788SHSouthwest Technology Center School Dist No. 27 · Altus, OKBuilt 2004 · S/N 3631N788TDBurdick Kelly E · Wasilla, AKBuilt 1972 · S/N 18-9001N788TKRudd Wayne G · Basalt, COBuilt 2005 · S/N 10703N788WTFletcher Joseph E · Enid, OKBuilt 1999 · S/N 25036CN788XDonahue Patrick J · Carriere, MSBuilt 1997 · S/N 793-97N788ZStaton Robbie L · Lonoke, ARS/N 670N78901Emslie Ronald H · Sacramento, CABuilt 1961 · S/N 1915N78903Brar Kulbir Singh · Fresno, CABuilt 1961 · S/N 1917N78907Pritchard John A · Perry, KSS/N 1921N78909Takemura Chris · Mountain View, CABuilt 1961 · S/N 1923N7890GAltus Aircraft LLC · Taylor, TXBuilt 1970 · S/N 17259590N7890HTwo Feathers Industries LLC · Baker City, ORFirst renewal noticeBuilt 1946 · S/N 12-794N7890VDoherty Kevin R · Silver Spring, MDBuilt 1964 · S/N 2852N7890YMhr Leasing LLC · Hickory Corners, MIBuilt 1966 · S/N 30-977N78911Watt Charles D · Marietta, OHBuilt 1961 · S/N 1940N78912Mid America Plumbing LLC · Moscow, TNBuilt 1961 · S/N 1941N78913Ambrose Gary L · Camden, NCBuilt 1961 · S/N 1942N78914Collins Camden B · Millersport, OHS/N 1943N78915Hendryx Alec B · Coffeyville, KSBuilt 1961 · S/N 1944N78918Pearlman Fredric M · Southfield, MIBuilt 1962 · S/N 1952N7891AAce Aeromotive Inc · Miami, FLS/N 11-1466N7891GSam Aviation LLC · Long Beach, CABuilt 1970 · S/N 17259591N7891PN7891p Partners LLC · Suffolk, VABuilt 1962 · S/N 24-3120N7891WN7891w LLC · North Las Vegas, NVBuilt 1964 · S/N 28-1916N78920Duncan Mark T · Orange Grove, TXBuilt 1961 · S/N 1954N78923Rodriguez Julian P · New York, NYBuilt 1961 · S/N 1957N78925Sale Reported · Winthrop, MESale reportedBuilt 1962 · S/N 2037N78927Sly David P · Nevada, IAS/N 1961
Back to AD 81-18-04 R2