OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-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-10-06-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.

N5881DKanooth Michael L · Washougal, WABuilt 1956 · S/N 18-5305N5881URegistered aircraftBuilt 1970 · S/N 28-26715N5882FGo Fly Mi LLC · Saginaw, MIBuilt 1976 · S/N 28-7790140N5882LBreazeale Peter · Orangeburg, SCBuilt 1972 · S/N AA5-0082N5882PEvans Gene · Henderson, TXBuilt 1959 · S/N 24-967N5882QBean Merton H III · Phoenix, AZBuilt 1965 · S/N 3149N5882UMartinez Guillermo E · Upland, CABuilt 1970 · S/N 28-26716N5883LOst Kenneth Alan · Langhorne, PABuilt 1972 · S/N AA5-0088N5883QSnyder Stephen L · Lebanon, TNBuilt 1965 · S/N 806N5884DMcmahan Johnny W · Gakona, AKBuilt 1956 · S/N 18-5308N5884QOasis Aero Inc · Willmar, MNS/N 3150N5884UB & R Aircraft LLC · Wadsworth, OHS/N 28-26719N5885DConatser Shawn C · Fairbanks, AKBuilt 1956 · S/N 18-5309N5885PCostanzo Christopher P · Staten Island, NYBuilt 1959 · S/N 24-970N5886DAg Solutions Of West Texas LLC · Roby, TXBuilt 1959 · S/N 18-5310N5886FBacktoeden LLC · Casper, WYBuilt 1976 · S/N 28-7790141N5886H86h LLC · Burlington, VTBuilt 1949 · S/N 16-503N5886LCook Charles N · Lakeside, TXBuilt 1975 · S/N 0707N5886PAce Aeromotive Inc · Miami, FLBuilt 1959 · S/N 24-971N5886XPeak Investments LLC · Roanoke, VABuilt 1994 · S/N 1809088N5887DBragdon James O · Monticello, FLBuilt 1956 · S/N 18-5311N5887NBerkshire Commander Air LLC · Pittsfield, MABuilt 1978 · S/N 14502N5887UFretz Richard G · Harrisburg, PABuilt 1970 · S/N 28-26722N5887YAlmost There Air LLC · Daytona Beach, FLBuilt 1965 · S/N 27-3040N5888PRegistered aircraftS/N 24-973N5888QCross The Line Sales Inc · Lexington, NCBuilt 1965 · S/N 3152N5888ULynch Francis X · Dumont, NJBuilt 1970 · S/N 28-26755N5889L100 Rads Corporation · Omaha, NES/N AA5-0089N5889RPatkotak Crawford A · Barrow, AKS/N 17253558N5889VRegistration Pending · Cherry Hill, NJRegistration pendingBuilt 1977 · S/N 28-7790507N5889WHarrison Joshua · Canyon Country, CABuilt 1965 · S/N 28-2627N588BCSamela Nicholas V · Thomaston, CTS/N 564-2014N588BSMeives Mark J · Barneveld, WIBuilt 1978 · S/N 32R-7887140N588CPTjomsland Bryan · Culver City, CABuilt 1958 · S/N 24-431N588DCDynoair LLC · Watertown, SDBuilt 1998 · S/N 18280243N588LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020106N588LESmith Jason E · Calliham, TXBuilt 2004 · S/N 3588N588NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496233N588RVBird Aloft LLC · Sheridan, WYBuilt 2007 · S/N 40545N588SFIntrepid Helicopters LLC · Sylvania, OHBuilt 2006 · S/N 11034N5890DCouey Robert H · Anchorage, AKS/N 18-5315N5890LSturgeon Kenneth V · Winter Garden, FLBuilt 1972 · S/N AA5-0240N5890NSmith William Leonard · College Station, TXBuilt 1979 · S/N 14504N5890PDaniels David R · Anthony, NMBuilt 1959 · S/N 24-975N5890QDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1965 · S/N 3153N5890UKempton Lana Julia Trustee · Douglasville, GABuilt 1970 · S/N 28-26786N5890VEller Patricia E · Lutz, FLBuilt 1977 · S/N 28-7790508N5891DRiggs J'Ann · Wasilla, AKBuilt 1956 · S/N 18-5318N5891LAlldridge Thomas H · Cochranville, PABuilt 1972 · S/N AA5-0091N5891RTun Bay Inc · Wasilla, AKBuilt 1966 · S/N 17253560
Back to AD 87-10-06 R1