OpenAirDocs.org
AD 90-15-15 R1

Registered aircraft · 826

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

N38ACCesafsky Allen A · Trinity Center, CABuilt 1990 · S/N 643-90N38LTStevens Richard D · Isola, MSBuilt 1993 · S/N 718-93N38MBWest Joseph A · Ballston Lake, NYBuilt 1993 · S/N 715-93N38WHButler David · Palos Park, ILBuilt 1995 · S/N 748-95N390PEBoney Grady F · Rhine, GABuilt 2015 · S/N 1156-2015N390XDDecathlon Xtreme Inc Trustee · Wilmington, DEBuilt 2014 · S/N 1144-2014N391AJOreck Tom · Asheville, NCBuilt 2004 · S/N 954-2004N393TMAvion Acrobatico LLC · Waterloo, ILBuilt 1973 · S/N 82-73N394RBJones Luther L · Covington, LABuilt 1999 · S/N 837-99N396ACMayfly Aviation LLC · Quincy, FLBuilt 2002 · S/N 895-2002N398AGShin Howard I · New York, NYBuilt 2008 · S/N 1079-2008N398BCNorthwest Back Country Aircraft LLC · Caldwell, IDBuilt 2026 · S/N 1231-2026N398SBYuba Sutter Aviation Inc · Olivehurst, CABuilt 1998 · S/N 821-98N39JLLundberg Jonathan S · Fayetteville, TNBuilt 2012 · S/N 1115-2012N39LTGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 924-2003N400ABFlydallasbay LLC · Soddy Daisy, TNBuilt 1999 · S/N 838-99N400HWHotel Whiskey LLC · Sylvania, OHBuilt 1994 · S/N 739-95N400VWSpuza Dan D · Sanger, TXBuilt 1992 · S/N 681-92N400WHHorrigan William Jr · Roxbury, CTBuilt 2001 · S/N 875-2001N401ADAlexander Brad K · Melissa, TXS/N 154-74N404JEMedia Stew LLC · Carson City, NVBuilt 1993 · S/N 724-93N405RCWaterman David N · Amery, WIS/N 4-71N40ACRadecki Louis · Helenville, WIBuilt 1991 · S/N 644-91N40EMYour Moms Upset LLC · Saint Paul, MNS/N 696-92N4119YSmith Robert R · Benton, LAS/N 276-76N411DWKibler Joseph T · Mount Airy, MDBuilt 1996 · S/N 772-96N411LRHensley Ty · Lake Wylie, SCBuilt 1992 · S/N 679-92N411YSky Pirate LLC · Provo, UTBuilt 1977 · S/N 326-77N4134YLandon Jeff · Quartz Hill, CAS/N 278-76N4142YRegistered aircraftBuilt 1976 · S/N 279-76N4148YTailwheel Flying LLC · Rochester, MNBuilt 1976 · S/N 280-76N4161YWings Enterprizes Ltd Co · Yukon, OKBuilt 1977 · S/N 282-77N41696Aaa Aviation LLC · Donalsonville, GABuilt 1973 · S/N 116-73N4170YCraig Jerome A III · Plantation, FLBuilt 1977 · S/N 284-77N41797Valdes Eusebio · Miami, FLBuilt 1973 · S/N 117-73N4187YStohr Beuford G · Woden, IABuilt 1977 · S/N 289-77N4198YGallo Michael R · High Falls, NYBuilt 1977 · S/N 292-77N419DSLien Christian B · Rapid City, SDBuilt 2006 · S/N 1030-2006N419JRRaf LLC · Lenexa, KSBuilt 1995 · S/N 759-95N419SAStephens Kristi J · Bellingham, WABuilt 2003 · S/N 912-2003N41AGSkyline Agrinautics Inc · Osage, IABuilt 1996 · S/N 768-96N4204YCharles Tim W · Caldwell, IDBuilt 1977 · S/N 293-77N421LJAaces Flight Operation LLC · Ellisville, MOBuilt 2010 · S/N 1095-2010N4242GMaritz Paul A · Mercer Island, WABuilt 2000 · S/N 867-2000N431MARegent Trust Corporation Trustee · Wichita, KSBuilt 2022 · S/N 1200-2022N431SAArgotsinger Michael · Wichita, KSBuilt 2004 · S/N 952-2004N433TJKennedy John A · Marietta, GABuilt 1992 · S/N 661-92N43ACThomas Air Service Inc · Hastings, NEBuilt 1991 · S/N 645-91N43BPMichael W Miller LLC · Wilmington, DES/N 782-96N43EAVisionary Holdings LLC · Missoula, MTBuilt 2026 · S/N 1230-2026
Back to AD 90-15-15 R1