OpenAirDocs.org
AD 87-12-09 R1

Registered aircraft · 250

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:87-12-09-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:87-12-09-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.

N2812YThor And Associates Inc · Montgomery, TXBuilt 1991 · S/N 1142N28228Sunspray Sailing Ltd · Pompano Beach, FLS/N 1121N2824FKelty Matthew James · San Jose, CABuilt 1990 · S/N 1103N290DYZumm Thomas Lawrence · Wheaton, ILBuilt 2002 · S/N 2108N291GTNattjat Aviation LLC · El Dorado Hills, CABuilt 2001 · S/N 2091N291SGMiller John J · Fairfax, VABuilt 1990 · S/N 1032N292VSandaric LLC · Wittman, MDBuilt 1997 · S/N 1815N298SAFb Aviation Services LLC · Wilmington, DEBuilt 1998 · S/N 1865N3039PScholz Rolf H · Columbus, INS/N 1490N3039SChaco John R · Bonita, CAS/N 1501N30417United States Of America Owner · Travis Afb, CAS/N 1508N30486N30486 Partners LLC · San Luis Obispo, CABuilt 1993 · S/N 1544N3050NLuttrell Robert E III · Mckinney, TXS/N 1547N3056RHassenpflug Derek G · Cincinnati, OHS/N 1598N30573Dentdel Inc · Wilmington, DEBuilt 1994 · S/N 1615N3058VN5237l LLC · Oswego, NYS/N 1617N311DR7427 Aviation LLC · Clovis, CAS/N 955N319AVBermudez Reinaldo · Doral, FLS/N 707N31TBRusso Christopher · Huntsville, TXS/N 483N324BBN324bbjf Inc Owner Trustee · Wilmington, DEBuilt 1999 · S/N 647N341TBWil Aviate LLC · Merced, CAS/N 1696N343TBQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N 1697N345TBInternational Air Services Inc Trustee · Carson City, NVS/N 1914N351TBLetter Ride LLC · Woodbury, MNBuilt 1995 · S/N 1708N356GTPadre Bendice Este Vuelo LLC · Groveton, TXBuilt 1998 · S/N 1850N356TBSky West Aviation Inc Trustee · Albuquerque, NMS/N 1709N358TBSlezak David · Davison, MIBuilt 1995 · S/N 1716N366TBLouie Co Pilot LLC · Liberty Lake, WAS/N 1724N377CValiair Limited Company Trustee · Casper, WYBuilt 2005 · S/N 2222N37RKWardrop Donald Alexander · Bay Springs, MSBuilt 1985 · S/N 482N388JGBeggins Thomas J · Madison, CTBuilt 2000 · S/N 2021N38TBDrier Properties LLC · Gillett, ARBuilt 1985 · S/N 491N397TBLiberty Industries LLC · Washington, DCBuilt 1997 · S/N 1804N398SAGembala Gary L · Strongsville, OHBuilt 1998 · S/N 1824N399YAWadyac Inc Trustee · Wilmington, DES/N 2175N411JSPenniless Pilots Inc · Bowie, MDS/N 1139N41PWWhitehouse Thomas · Bethlehem, GABuilt 1985 · S/N 527N41TBMarikan LLC · Strongsville, OHS/N 485N421TBHale Concepts LLC · Marietta, OHBuilt 2002 · S/N 2081N422ENHicks Avionics LLC · Dawson, GAS/N 1241N42TGMurray Frederick D · Evans, GAS/N 684N456TBValentine David L · Katy, TXBuilt 1999 · S/N 1911N4734KLenox Robert P · Palo Alto, CABuilt 1984 · S/N 400N4736EBarstow Barnstormers LLC · Midland, MIBuilt 1984 · S/N 415N47SGStanley Kristy · Coldwater, MSBuilt 1984 · S/N 428N500TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 1195N501LFMilchev Valentin · New Hampton, NHBuilt 1995 · S/N 1758N51TBSorenson Gary Trustee · Storden, MNBuilt 1985 · S/N 488N525DVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1987 · S/N 763N52JGMalloy Marc · Fletcher, NCS/N 670
Back to AD 87-12-09 R1