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.

N95HJSkyview Aviation LLC · Benton, KYBuilt 1965 · S/N TD-615N95HSRegistration Pending · Cologne, MNRegistration pendingBuilt 2013 · S/N 143N95JALane Christopher C · Dallas, TXBuilt 1979 · S/N 172RG0015N95JJHorrigan Patrick B · Shoreview, MNBuilt 2010 · S/N 90216N95JLZhang Weiyu · Madison, WIBuilt 2001 · S/N 24199N95JPKeller Justin Allen · Youngstown, FLBuilt 1973 · S/N 28-7305429N95KAAirborne Resources Inc · Midlothian, TXBuilt 1981 · S/N 318152146N95KBFront Range Heli Inc · Erie, COBuilt 2014 · S/N 2354N95KKGrimes Chris · Hudson, NYBuilt 1966 · S/N TD-649N95KPPainter Kenneth Lee · Luray, VABuilt 1973 · S/N 119-73N95KRAlta Aviation LLC · Granbury, TXBuilt 2020 · S/N 091N95MCMarten David H · Cheney, KSS/N MCCANN-0001N95MMManley Marvin W · Camp Verde, AZBuilt 1998 · S/N 60035N95NHOberlander Justin D · Colton, ORBuilt 1974 · S/N 105-74N95PGAviation Sensation LLC · Clearwater, FLBuilt 1974 · S/N 28R-7535026N95QLoftis Philip D · Buckhannon, WVBuilt 1975 · S/N 28-7515408N95RSpence Justin A · Memphis, TNFirst renewal noticeBuilt 1967 · S/N OAS-1N95RAKennedy Crosswind LLC · Wellsburg, IABuilt 1973 · S/N 32-7440054N95RWColberg Stefan D · North Bend, ORS/N I-AN95SHReady Aim Flyer LLC · New Castle, DEBuilt 1957 · S/N TD-21N95TRegistered aircraftBuilt 1987 · S/N 3213003N95TASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N 31-7300971N95TCMmec Air LLC · Oxford, MSBuilt 1983 · S/N 31-8352037N95TKTalos Aviation Group LLC · Blackstone, VABuilt 1970 · S/N 27-4555N95TSSkywest Leasing Inc · St George, UTBuilt 1997 · S/N 2843103N95VTChase Michael D · North Hero, VTBuilt 2017 · S/N 40644N95WCNorth Is Up LLC · Seattle, WABuilt 2001 · S/N T20608297N95WPPercival Wilhelm F · Las Vegas, NVBuilt 1987 · S/N 1995LN95WTDs Flight Services LLC · Battle Ground, WABuilt 1966 · S/N TD-677N95YWhite Tavis · Huntsville, ALBuilt 1964 · S/N TD-604N95ZMVanlandingham Russell · Salem, ORBuilt 2005 · S/N 5824N96009Loera Arnold · Dillingham, AKBuilt 1990 · S/N 1124N9600JCox Grant L · Moses Lake, WABuilt 1989 · S/N 1118N9600MAstrup Aviation Enterprises LLC · Lincoln, CABuilt 1966 · S/N 670177N9600SHargrove Tom R · Coffeyville, KSBuilt 1966 · S/N 2N9600UUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7816505N9601DRiffle David T · Woodinville, WABuilt 1958 · S/N 22-6510N9601JGevers Robert L · Lafayette, INBuilt 1966 · S/N 28-3747N9601QSteel Aviation Inc · Walnut Cove, NCBuilt 1975 · S/N 17265686N9602BLaguna Verde Leasing Inc · Wilmington, DES/N 172RG0912N9602EMerrill Mark · Ellensburg, WABuilt 1976 · S/N 76-31124N9602MCullen William P · Alexandria, VAS/N 670179N9602SKrepfl Martin J · Colorado Springs, COBuilt 1965 · S/N 50N96033Sullivan Leo W · O Fallon, ILBuilt 1990 · S/N 1127N9603DHeartland Aviation Inc · Alliance, NES/N 22-6512N9603FWylie Aviation LLC · Boise, IDBuilt 1989 · S/N 1121N9603QConnecticut Flyers Inc · Madison, CTBuilt 1975 · S/N 17265688N9603WMoore Alan Ray · Glenwood, ARBuilt 1967 · S/N 28-23055N96042Aeropaint LLC · Wylie, TXBuilt 1990 · S/N 1138N9604QStevens Joel N · Monticello, ARBuilt 1990 · S/N 1120
Back to AD 87-10-06 R1