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.

N88278Crosswell Joe D · Springtown, TXBuilt 1974 · S/N 167-75N88288Cain Philip K · Escondido, CABuilt 1974 · S/N 168-75N88309Larkin Edward C · Covington, KYBuilt 1975 · S/N 171-75N883JJJaffe Jordan E · Horseshoe Bay, TXBuilt 2003 · S/N 910-2003N88428Mason Fred B · Waterford, OHBuilt 1974 · S/N 162-75N88467Atwood Christopher M · Brownsburg, INBuilt 1974 · S/N 163-75N886THMock Joseph R · Huntsville, TXBuilt 1974 · S/N 142-74N887PAReall George Dan · Castle Rock, COBuilt 2016 · S/N 1162-2016N889GSKlock Dexter F · Driggs, IDBuilt 2000 · S/N 853-99N891DBSpivak Maxim · San Jose, CABuilt 2001 · S/N 891-2001N891JTTrowbridge Jason Wesley · Arlington, TNBuilt 1973 · S/N 584-80N8956Martini Philip D · Bethel Park, PABuilt 1973 · S/N 123-74N89GKCasa Jets Inc · Pittsford, NYS/N 1086-2009N89MMSic Sac Fliers LLC · Gainesville, FLS/N 1185-2020N89TWAlpine Aerobatics LLC · Chelsea, MABuilt 2005 · S/N 977-2005N8ETAshby Dennis A · Paris, TXBuilt 1980 · S/N 619-80N8PMChristmas Michael G · Long Beach, CABuilt 1975 · S/N 192-75N8SFScarbrough Christopher R · Palestine, TXBuilt 1972 · S/N 59-73N901KGBeaty Chris · Dothan, ALBuilt 1979 · S/N 593-80N904JBMitchell Thomas H · Batesville, MSFirst renewal noticeBuilt 1978 · S/N 417-78N905KTmd Enterprises LLC · Amarillo, TXBuilt 2006 · S/N 1020-2006N906NCactus Pilots LLC · Tulsa, OKBuilt 2022 · S/N 1203-2022N90919Allman Joseph S · Blackstone, VABuilt 1973 · S/N 61-73N90965Guinn Gary L · Tulsa, OKBuilt 1973 · S/N 60-73N90975Schiestle Jason · Greenville, PAS/N 65-73N90GEWc Three LLC · Wilmington, DEBuilt 2018 · S/N 1174-2018N90GKPruitt Russell · Athens, GABuilt 2021 · S/N 1192-2021N90GTHawk Aviation LLC · Buffalo, NYBuilt 2017 · S/N 1172-2017N910DKUpside Down Holdings LLC · Sherman Oaks, CABuilt 2005 · S/N 1007-2005N912MAEmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2004 · S/N 9482004N9178LClarke Paul W · Cape Girardeau, MOBuilt 1972 · S/N 5-72N917AXGast Matthew Adam · Weston, WIBuilt 2026 · S/N 1233-2026N922DEMichigan Aviation LLC · Commerce Township, MIBuilt 2013 · S/N 1117-2013N923SQSprecher Susan E · Locust Grove, GAS/N 86-73N924JWStephenson James M Jr · Hyampom, CABuilt 2000 · S/N 860-2000N927SANpg Group LLC · Missoula, MTBuilt 2003 · S/N 927-2003N929ELPatterson Bryan J · Brooks, GABuilt 1999 · S/N 828-99N92GKRatchford Herman Jr · Bessemer City, NCBuilt 2025 · S/N 1222-2025N92KBRaphael Dennis C · Colorado Springs, COBuilt 1992 · S/N 662-92N92SGStraight And Level LLC · Woodbine, MDBuilt 2014 · S/N 1149-2014N933BCPathak Rahul · Mercer Island, WABuilt 2024 · S/N 1219-2024N939CBRegistered aircraftBuilt 1975 · S/N 207-75N93DNRiseaero LLC · Florence, SCBuilt 1993 · S/N 712-93N93WEBoeing Employees Flying Assoc · Renton, WABuilt 1992 · S/N 659-92N944TLAims Community College · Loveland, COBuilt 2019 · S/N 1180-2018N949MWMgm Landing LLC · Lewes, DEBuilt 2014 · S/N 1143-2014N94BMRambarran Brian · Clarence Center, NYBuilt 2008 · S/N 1066-2008N94GKBeech Baron LLC · Wilmington, NCBuilt 2022 · S/N 1206-2022N951AGAcn951ag LLC · Worthington, OHBuilt 1999 · S/N 850-99N952EROliver Lawrence G · Lewiston, MEBuilt 2011 · S/N 1109-2011
Back to AD 90-15-15 R1