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.

N7893VDarnell Noah Alexander · Searcy, ARBuilt 1964 · S/N 2855N7893YRegistered aircraftBuilt 1966 · S/N 30-980N78940Gaskins Gregory G · Godley, TXS/N 1974N78943Tutino John · Pleasant Valley, NYBuilt 1961 · S/N 1977N78945Ag-Aero Services LLC · Spring Hill, FLBuilt 1962 · S/N 1979N78946Terra Magic LLC · St Anthony, IDS/N 1980N78949Tour Talent LLC · Akron, OHFirst renewal noticeBuilt 1961 · S/N 1983N7894CAllen Rob · Lancaster, OHBuilt 1975 · S/N 28-7615066N7894GAr Aero Services LLC · Sacramento, CABuilt 1970 · S/N 17259594N7894PBayorek Barry E · West Wendover, NVBuilt 1962 · S/N 18-7876N7894VHydock David B · Leslie, ARBuilt 1965 · S/N 2937N7894WWiley Thomas W · Anchorage, AKBuilt 1964 · S/N 28-1921N7895Matukaitis William K · Millbury, MABuilt 1968 · S/N 123N78953Holman Richard S · Clearmont, MOBuilt 1961 · S/N 1987N78955Stuber Paul A · Kansas City, MOBuilt 1961 · S/N 1989N78956Pauly Traviston · Natrona Heights, PABuilt 1961 · S/N 1990N78959Nelson Brian · Pennsburg, PABuilt 1961 · S/N 1993N7895SOcean Aerial Ads Inc · Berlin, MDFirst renewal noticeBuilt 1976 · S/N 586-76N78960Lydon Ethan J · Lumberton, NJBuilt 1961 · S/N 1994N78961Schuster Christopher J · Sherman, TXBuilt 1961 · S/N 1995N78962Smith Eric A · Kelso, WAS/N 1996N78965Clore Gregory N · Ashland City, TNBuilt 1961 · S/N 1999N78968Harris Rex D · Mason City, IABuilt 1962 · S/N 2142N7896DJohnson Rickie G · Callahan, FLBuilt 1957 · S/N 22-5522N78972Quimby Dean Kelly · Lino Lakes, MNS/N 2006N78975Johnson William P · Shreveport, LABuilt 1962 · S/N 2009N78978Martin Gary P · Boonville, MOBuilt 1968 · S/N 17257796N7897WDimario Carmen · Wilmington, DEBuilt 1964 · S/N 28-1925N78982Douglass William W III · Panora, IABuilt 1962 · S/N 2016N78983Richard Kroll A Law Corp · Laguna Niguel, CABuilt 1962 · S/N 2017N78984Goodin Charles R Jr · Chillicothe, OHBuilt 1962 · S/N 2018N78987Sale Reported · Chickaloon, AKSale reportedBuilt 1962 · S/N 2021N7898GMccutcheon Frank Jr · Scottsboro, ALBuilt 1970 · S/N 17259598N7898PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301873N7898VBrown Dallas D · Taylors Falls, MNBuilt 1964 · S/N 2860N7898YPatry Aeronautical Institute · Kalispell, MTBuilt 1966 · S/N 30-986N78996Dodge Donald V · Newnan, GAS/N 2030N78997Frederick Daniel S · Broad Brook, CTBuilt 1962 · S/N 2031N78998Van Engen Ronald J Jr · Granbury, TXBuilt 1962 · S/N 2032N7899DBlake Richard E Jr · Marion, LABuilt 1958 · S/N 22-5819N7899WAmmon Sol · Papaaloa, HIS/N 28-1928N789ABRegistered aircraftBuilt 2008 · S/N 40298N789ACNiles Air LLC · Concord, NCBuilt 2023 · S/N 629-2023N789AWWalker Alan B · Sunnyside, WABuilt 2011 · S/N 91804N789BNelson Brett R · Shoreview, MNBuilt 1977 · S/N 18-7709171N789BGM9c146 Aviation LLC · Boynton Beach, FLBuilt 2000 · S/N 17280938N789BMMcanelly Gary Alan · Burnet, TXBuilt 2002 · S/N 001N789BNDanbom Jimmy D · Tavares, FLBuilt 2004 · S/N 90727N789BRDelong David P · Kirkland, WABuilt 2003 · S/N 90505N789CBBolan Walter Thomas · Gresham, ORBuilt 2026 · S/N B32-64B/65B-1671B
Back to AD 87-10-06 R1