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.

N31293Scroggins Darrel T · Springfield, MOBuilt 1972 · S/N 56-73N313MTNguyen Nhu-An T · Parkville, MDBuilt 1977 · S/N 356-77N313WFSalisbury Peter R · White Bear Lake, MNBuilt 2001 · S/N 879-2001N317JRUnd Aerospace Foundation · Grand Forks, NDBuilt 2010 · S/N 1105-2011N317SDSipila Hart A · Soquel, CAS/N 778-96N318JRFlywell Aviation LLC · Bowling Green, KYBuilt 2006 · S/N 1013-2006N31SETangent LLC · Phoenix, AZBuilt 2005 · S/N 978-2005N31XEverson Dustin J · Providence, RIBuilt 1992 · S/N 671-92N31YFCharliefoxtrot LLC · Farmington, MOBuilt 2015 · S/N 1158-2015N321RJGritter Richard J · Catlett, VABuilt 1977 · S/N 323-77N322ERucinski Thomas · Paramus, NJBuilt 1992 · S/N 698-93N323CAChatman Ira D · Mountain Home, ARS/N 807-98N327XNew Horizon Aviation Inc · Warwick, RIBuilt 2008 · S/N 1058-2007N328MDJames Douglas M Trustee · Scottsdale, AZBuilt 1995 · S/N 758-95N32LDms Aviation Services LLC · Wildwood, MOBuilt 1991 · S/N 654-91N330MSCanyon Airmotive LLC · Frisco, TXBuilt 1995 · S/N 750-95N335DSWhitaker Martin · Portland, MEBuilt 2008 · S/N 10702008N336WTRomney Chad · Rigby, IDBuilt 2023 · S/N 1210-2023N33BP33bp LLC · Sand Springs, OKBuilt 1992 · S/N 691-92N33BYSellmeyer Flying Service · Knobel, ARBuilt 2005 · S/N 990-2005N33GRHeadrick John Eric · Eolia, MOS/N 259-76N33LTKelly Tony R · Aberdeen, MSBuilt 1997 · S/N 799-97N345ASDwyer Aaron B · San Jose, CAS/N 592-80N345RADavis Scott · Morse, TXBuilt 2002 · S/N 900-2002N347MABent David Thomas · Port Saint Lucie, FLS/N 897-2002N349BCJasper Dirt LLC · Bluffton, SCS/N 1184-2020N359CAFly Inverted LLC · Brighton, MIBuilt 2005 · S/N 997-2005N35BWCauthen Joe A · Canton, MSBuilt 1992 · S/N 678-92N35BYSuper D LLC · Broomfield, COBuilt 2005 · S/N 998-2005N35RXRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 496-79N36013Jones Joseph D · Broken Arrow, OKBuilt 1973 · S/N 98-73N36035Hilstad Steve D · Mayville, NDBuilt 1973 · S/N 100-73N36139Flying Sportsmen Inc · Sussex, NJBuilt 1973 · S/N 105-73N36176Otte Duane P · Plainfield, INBuilt 1973 · S/N 101-73N36244Neel Aviation LLC · Lakeland, FLBuilt 1973 · S/N 103-73N36337Boling Derek · Paragould, ARBuilt 1973 · S/N 107-73N36352Smith Steven Glen Trustee · Orem, UTBuilt 1973 · S/N 108-73N36413Steward James D · Monument, COBuilt 1973 · S/N 109-73N36593Kentucky Stick And Rudder Academy LLC · Springfield, KYBuilt 1973 · S/N 112-73N36628Quale David R · Cottage Grove, WIBuilt 1973 · S/N 113-73N375TJohnson Nick H · Houston, TXBuilt 2023 · S/N 1209-2023N3770Joebravo Aviation LLC · Derby, KSS/N 204-75N378JGByrkit Dale D · Clay Center, NEBuilt 1992 · S/N 680-92N378JPN8zw LLC · East Hampton, NYBuilt 2005 · S/N 980-2005N37BYTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 951-2004N37KFFillips Karl · Alvin, TXS/N 317-77N37LVLegros Aviation Services Inc · Crowley, LABuilt 1992 · S/N 695-92N37TRTrofimchuck Matthew P · Coal City, ILBuilt 1996 · S/N 775-96N381DMStuart John R · Taylorsville, KYBuilt 2000 · S/N 865-2000N385EASchuch Glenn F Jr · Dubois, PAS/N 1208-2023
Back to AD 90-15-15 R1