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.

N816GHolland Travel Air LLC · Holmen, WIBuilt 1964 · S/N TD-562N816GMAtd Pilot Training LLC · Kansas City, MOBuilt 1976 · S/N 28-7615219N816HAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1999 · S/N 17280825N816JHIndy Aviation LLC · Carmel, INBuilt 2001 · S/N 18280982N816JPKnox James P · Park Rapids, MNBuilt 1961 · S/N 18-7602N816KCCrews Kevin S · Winter Haven, FLBuilt 2010 · S/N 24021N816LRegistration Pending · Anderson, SCRegistration pendingBuilt 1968 · S/N 17256833N816LGGray James · Jupiter, FLBuilt 1977 · S/N 17268592N816LLAero Equities LLC · Ventura, CABuilt 2003 · S/N 913-2003N816RARochester Air Center LLC · Canandaigua, NYBuilt 1979 · S/N 17272388N816RCSerani Enterprises LLC · Broomfield, COBuilt 2006 · S/N 40341N816RFTerhaar Ronald D · Albany, ORBuilt 2009 · S/N 40097N816RMRegistered aircraftBuilt 2024 · S/N 42201N816STForensic Doctors Group Pc · San Francisco, CABuilt 1985 · S/N 323N816TSCd Logic Inc · Wilmington, DEBuilt 1985 · S/N 24-1562N816TXDavis Derek P · Sebastian, FLBuilt 1979 · S/N R18200811N816WAFredericks Ruth · Miami, FLS/N 28-7525173N816WBNorthern Aggregate Inc · Bemidji, MNBuilt 1980 · S/N 32-8006015N816WMRent A Copter LLC · Homer Glen, ILBuilt 2000 · S/N 0824N816WRDonovan Mark J DBA · Moultonborough, NHBuilt 1982 · S/N 18-8309017N816YQazwbt LLC · Arroyo Grande, CABuilt 2003 · S/N 2273N816YPB&D Air Solutions LLC · Austin, TXBuilt 1978 · S/N 32R-7885267N8170CGibbens Brett S · Mc Grath, AKBuilt 1954 · S/N 18-3626N8170FAlfonso Peter J · Jamestown, RIBuilt 1980 · S/N 32R-8013071N8170NFalter George H III · Baltimore, MDBuilt 1968 · S/N 28-25366N8170SSkywagons.Com LLC · Placerville, CAS/N 32R-8029067N81713Brown Matthew · Spokane, WABuilt 1980 · S/N 28-8016290N81715Registration Pending · Hanford, CARegistration pendingS/N 28-8016291N8171DLueking Clyde F · Holdrege, NEBuilt 1957 · S/N 18-6100N8171NOndrovic Rick · Belton, SCBuilt 1968 · S/N 28-25367N8171WAnderson Christopher J · Ogden, UTBuilt 1965 · S/N 28-2291N8171YFaith Works Aviation LLC · Glenmoore, PABuilt 1980 · S/N 28-8016284N8172Magrini Shawn P · Salem, OHBuilt 1970 · S/N RJB-2N81723Aero Legacy Foundation · Basehor, KSS/N 31047N81729Bushroe Dennis J · Temperance, MIBuilt 1996 · S/N 20847N8172CDrath Mark O · Reedsville, WIBuilt 1954 · S/N 18-3628N8172NBeasley Michael Jeffrey · Dothan, ALS/N 28-8090261N8172PRemarkable Resources LLC · Bristol, WVBuilt 1981 · S/N 32R-8129028N8172QFrost Aviation Services Inc · Las Cruces, NMBuilt 1980 · S/N 28-8090263N8172WMile High Advertising LLC · Dover, DEBuilt 1965 · S/N 28-2294N8172YKline John C · Wolcottville, INBuilt 1966 · S/N 30-1286N8172ZAverka Steven D · Sutton, MABuilt 1980 · S/N 28-8090264N8173DAaa Flying Service Inc · Wellington, TXBuilt 1957 · S/N 18-6097N8173ESky Equity LLC · Woodbury, MNBuilt 1978 · S/N 17272147N8173HMcmahon Mary G · Winchester, CABuilt 1980 · S/N 28-8011097N8173NJones Roy F · Benson, AZBuilt 1968 · S/N 28-25369N8173PLao Investments LLC · Meeker, COBuilt 1980 · S/N 32-8024015N8173WRoadrunner Flight School LLC · Farmington, NMS/N 28-2295N8173YAltitude Aviation Group LLC · Kissimmee, FLS/N 30-1287N81741Corsican Aviation LLC · Westfield, INBuilt 1980 · S/N 28-8090134
Back to AD 87-10-06 R1