OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N888PFAbba Ffs LLC · Kalispell, MTBuilt 2013 · S/N TH-2390N888PJPatterson Edward · Midland, TXBuilt 1981 · S/N 21064244N888PLDavis Brent · Forney, TXBuilt 1977 · S/N 21062395N888REDill Harry H Trustee · Mebane, NCBuilt 2003 · S/N 29-0291N888SK5 Aviation LLC · Las Vegas, NVBuilt 1976 · S/N D-9937N888SALyman Joseph Scott · Kimberly, IDBuilt 1978 · S/N 21062542N888SGBlairwood LLC · Akron, OHBuilt 2003 · S/N 0762N888SHLopez Benjamin · Batavia, OHBuilt 1969 · S/N D-9066N888SSRegistration Pending · Houston, TXRegistration pendingBuilt 2005 · S/N 1302N888VVAbaco Xpress LLC · West Palm Beach, FLBuilt 1973 · S/N 421B0550N888WX888wx LLC · Muscatine, IABuilt 2007 · S/N TH-2191N888YMV1 Aviation LLC · Little Rock, ARBuilt 2005 · S/N 1437N8893HMac-Mor Ltd · Mukwonago, WIBuilt 1947 · S/N NAV-4-893N8898QNorthrop Grumman Systems Corp · El Segundo, CABuilt 1976 · S/N U20603561N889FTMolly Willis Ventures LLC · Albany, GABuilt 1997 · S/N TH-1828N889JSMoran Consulting Corp · Long Beach, CABuilt 1974 · S/N D-9579N889TSQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N TJ281N88ANJk Manufacturing Co · Wilmington, DES/N CE-1700N88BAir Taco LLC · Virginia Beach, VABuilt 1982 · S/N E-2036N88BLBrewer Jim L · Loco, OKS/N 206-0118N88BM350 Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 0798N88BPPlane LLC · Worcester, MABuilt 1993 · S/N E-2780N88BVCarr Phillip E · Cave Creek, AZBuilt 1977 · S/N D10060N88CJLyman Michael R · Lake Oswego, ORBuilt 1977 · S/N E-1042N88CLHarp Robert P · Houston, TXBuilt 1988 · S/N CE-1225N88ESChapman Kevin J · Williston, NDBuilt 1975 · S/N E-758N88EZMusack Randy A · Butternut, WIBuilt 2000 · S/N E-3364N88KBNshe Keller Bros LLC · Lititz, PABuilt 2016 · S/N TH-2474N88KSHolzschuh David D · Corpus Christi, TXBuilt 1967 · S/N CE-151N88MBLebanon Aviation Inc · Mount Juliet, TNBuilt 1971 · S/N TE844N88PBBraswell Jerrold W · Dillingham, AKS/N 207-00498N88PLKendler Peter · Lincolnshire, ILBuilt 2007 · S/N E-3809N88PMPrvny Pluk L L C · Houston, TXBuilt 1952 · S/N 34-48N88RRegistration Pending · Wilmington, DERegistration pendingBuilt 1973 · S/N D-9475N88RMAmerican Airpower Heritage Flying Museum · Dallas, TXS/N G-752N88TBSundancer Enterprises LLC · Norman, OKBuilt 2010 · S/N TH-2289N88TJCooley Bridget A · Seattle, WABuilt 1988 · S/N CE-1256N88TPCruson James W · Spring Creek, NVBuilt 1968 · S/N E-86N88TSWrb Aircraft LLC · New York, NYBuilt 1988 · S/N E-2409N88VVGrossglockner Inc · Canandaigua, NYBuilt 2014 · S/N E-4037N88YYSauer Stuart O · Fort Mohave, AZBuilt 1966 · S/N CE-64N88ZDN40as LLC · Brooklyn, NYBuilt 2019 · S/N E-4128N8902ULusby II Dale · Garden Valley, CABuilt 1965 · S/N D-7902N8903UMartin William C · Middleville, MIBuilt 1965 · S/N D-7903N8906UKelley William · Springtown, TXS/N D-7906N8907QBurks Excavation Corp · Hailey, IDBuilt 1976 · S/N U20603562N8907USprague Allen T · Warrenton, ORBuilt 1965 · S/N D-7907N8908UFly Buys Too LLC · Wilmington, DEBuilt 1965 · S/N D-7908N890CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1978 · S/N 402C0006N890CDTrue Course LLC · Lunenburg, MABuilt 2003 · S/N 0591
Back to AD 86-13-04 R3