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.

N7448WBoyce Gillis · Savannah, TNBuilt 1963 · S/N 28-1364N74499Dawn Wolf Technologies Inc · Wichita, KSBuilt 2006 · S/N 1598N7449GAvmajic LLC · Waterford, MIBuilt 1970 · S/N 17259149N7449PAshcroft James K · Hurricane, UTBuilt 1961 · S/N 24-2638N7449WMutch Robert E · Barrington, NHBuilt 1963 · S/N 28-1338N7449YMiddle Georgia Aviation Inc · Cochran, GABuilt 1964 · S/N 30-513N744AFCm3 LLC · North Las Vegas, NVBuilt 2008 · S/N 1955N744AKExpress Helicopters LLC · Houston, TXBuilt 2003 · S/N 10001N744BBCooper Roy · Lamesa, TXBuilt 1993 · S/N 001N744CJJersey Aviation LLC · East Orange, NJBuilt 2009 · S/N 2032N744CWSmith Shepard E · Los Angeles, CABuilt 1978 · S/N AA5A0655N744DMMaloney Daniel D · East Amherst, NYBuilt 2002 · S/N 3371N744DSShuey Jack L Jr · Owego, NYBuilt 2004 · S/N 70107N744ESUsaircraft Inc · Newark, DEBuilt 1993 · S/N 2319N744JCAck-Pg-LLC · Charlestown, MABuilt 1979 · S/N 31-7912119N744JNAvia Flight Academy LLC · Stratford, CTBuilt 1970 · S/N 28-5702N744KGLehmann Air LLC · Kerrville, TXBuilt 2005 · S/N 10998N744MDeforest Shawn L · Lexington, NCBuilt 1978 · S/N 17270562N744MTChrisman Kenneth A · Spring, TXBuilt 2009 · S/N 82498N744NDAir Shares LLC · Casper, WYBuilt 2017 · S/N 2843891N744PASkywest Leasing Inc · Saint George, UTBuilt 2018 · S/N 2881015N744RGJohnston Philip · Mountain Home, TXBuilt 2007 · S/N 1753N744RVAustin Aviation LLC · Maumelle, ARBuilt 2003 · S/N 4636342N744SGGimblin Robert Steven Trustee · Yuba City, CABuilt 2017 · S/N 582-2017N744TWTumbleweed Leasing Co Inc · Salt Lake City, UTFirst renewal noticeBuilt 2005 · S/N 10702N74500Lanier Equipment Leasing LLC · Gainesville, GABuilt 2005 · S/N 10792N74501Barnes Michael N · Lindstrom, MNBuilt 1961 · S/N 1812N74502Land Dustin M · Bascom, FLBuilt 1961 · S/N 1813N74505Registration Pending · Redlands, CARegistration pendingBuilt 1961 · S/N 1816N74507Bas Part Sales LLC · Greeley, COBuilt 1961 · S/N 1818N74508Agricultural Tours LLC · Cheyenne, WYBuilt 2006 · S/N 1600N7450GLewis Benjamin · Delano, MNBuilt 1970 · S/N 17259150N7450JBuchanan David · Elkin, NCBuilt 1968 · S/N 28R-30799N7450WCreager Scott L · Visalia, CABuilt 1963 · S/N 28-1339N74510Hood Joseph L · Ann Arbor, MIBuilt 1962 · S/N 1904N74511A & D Wings LLC · Clarkston, MIBuilt 1961 · S/N 1822N74513Munasinghe Chanaka · Portland, ORBuilt 1961 · S/N 1824N74514Krupinski Floyd M · Chugiak, AKBuilt 1961 · S/N 1825N74516Daniel Gary T · Athens, GABuilt 1961 · S/N 1827N74517Linstad Daniel E · Canby, ORFirst renewal noticeBuilt 1961 · S/N 1906N7451JMoore Jimmy I · Beach City, TXBuilt 1968 · S/N 28R-30800N7451KHendry Joshua · Carthage, TNBuilt 1950 · S/N 362N7451WSamson Ag Flying LLC · Wilmington, DEBuilt 1963 · S/N 28-1340N74522Blue Line Holding LLC · Little Falls, MNBuilt 1961 · S/N 1833N74525Barnard Vaughn N III · Raleigh, NCS/N 1836N74527White Jesse J · Penn Valley, CAS/N 1838N74529Harris Nathan J · Preston, IDBuilt 1961 · S/N 1840N7452JMcaleer John D · Molalla, ORBuilt 1960 · S/N 18-7452N7452PTimothy A Cox · Coshocton, OHBuilt 1961 · S/N 24-2641N74533Whalen Shenandoah · Amelia, OHBuilt 1961 · S/N 1844
Back to AD 87-10-06 R1