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.

N4012TStull Joshua S · Tacoma, WABuilt 1968 · S/N M-1119N4012ZHronkin Jesse G · Palmer, AKBuilt 1963 · S/N 18-7963N4013ERogers Twyla M · Windham, MEBuilt 1977 · S/N 18-7809018N4013REquipment Plus LLC · Culpeper, VABuilt 1990 · S/N 1430N4013XN4013x LLC · Great Falls, MTS/N 5113N4014EMoriarty Gerald Joseph · Anchorage, AKBuilt 1978 · S/N 18-7809019N4014PGriffing Flying Service Inc · Port Clinton, OHBuilt 1958 · S/N 23-1489N4014XFournier Ronald A · San Diego, CAS/N 5114N4015NHazel Consulting LLC · Dayton, NVBuilt 1968 · S/N 680159N4015RJ And J Av8 LLC · Eatonton, GAS/N 32-40310N4015TBauries Brian W · Abilene, TXBuilt 1968 · S/N M-1122N4016RNorsworthy Aviation LLC · Redington Shores, FLBuilt 1967 · S/N 32-40312N4016ZLong Island Soaring Assoc · Yaphank, NYBuilt 1963 · S/N 18-7966N4017EJelinek Ed · Denton, MTBuilt 1977 · S/N 18-7809021N4017FHansen Drew A · Miami Springs, FLBuilt 1976 · S/N 287715002N4017P17p LLC · Caddo Mills, TXS/N 23-1492N4017ZB4b Co · Ridgeview, SDBuilt 1963 · S/N 18-7968N40189Jacob Mark K · East Lansing, MIBuilt 1943 · S/N 51218N4018EWilliams Matthew S Trustee · Anchorage, AKBuilt 1977 · S/N 18-7809040N4018RRyan Jeromie · Allen, TXBuilt 1967 · S/N 32-40315N4018TMalfaro William J · Boyertown, PABuilt 1968 · S/N M-1125N40193Rearden Logic Inc · Denver, COBuilt 1959 · S/N 24-1239N4019RFdmas LLC · Bellevue, WABuilt 1967 · S/N 32-40316N4019WSmith Timothy A · Granbury, TXBuilt 1966 · S/N 32-40027N4019XBoswell Joey L · Comanche, TXBuilt 1969 · S/N 5119N4019ZPercy Nolan C · Saint Francisville, LAS/N 18-7971N401ADAlexander Brad K · Melissa, TXS/N 154-74N401BJJohnson William L · Union City, INS/N 1N401BPSouthside Corp LLC · Rainsville, ALBuilt 2002 · S/N 3257289N401DKBuford Copter Co LLC · Colorado City, TXBuilt 1988 · S/N 0929N401DSDelaware State University · Dover, DEBuilt 1972 · S/N 34-7250156N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165N401FLRinaldi Isaac Paul · Richardson, TXBuilt 1971 · S/N 28-7125175N401HWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020283N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490N401LALee Hunter · Colorado Springs, COBuilt 1965 · S/N 2949N401LDBrady Kevin J Trustee · Afton, OKBuilt 1977 · S/N AA5B0511N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784N401MBFly Aztecs LLC · Waterloo, NEBuilt 1977 · S/N 27-7854013N401PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843444N401PJSkylens LLC · Hammond, LABuilt 1968 · S/N 27-4112N401PKJones Roderick H DBA · Thomasville, GABuilt 1998 · S/N 1438N401RSawyers Ron S · Hayden, IDBuilt 1991 · S/N 1647N401RHTofte Shawn A · Lewis Center, OHBuilt 1999 · S/N 1986N401SLCatalina Air Harbor Inc · Armuchee, GABuilt 1978 · S/N 32R-7887148N401TCPrecision Ag Air LLC · Pendleton, INS/N 20279N401WBNew England Airlines Inc · Westerly, RIBuilt 1969 · S/N 66N401ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881647N40200Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 27-7304997N4020DInnovative Design Group Inc · Watkinsville, GABuilt 1999 · S/N 21063C
Back to AD 87-10-06 R1