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.

N8TRAviation Academy LLC · Wichita, KSBuilt 1972 · S/N 17260672N8TTLee Jerry L · New Port Richey, FLBuilt 1996 · S/N 396N8TYPayne Troy N · Luthersville, GABuilt 2009 · S/N 81349N8UBInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 0001N8UKIvey Thomas S · Gladewater, TXS/N 134N8UPFelix David S · Salome, AZBuilt 2010 · S/N 81597N8UUBoltair Ltd · Seward, AKBuilt 2008 · S/N 118N8VTAleph Leasing LLC · Eagle Mountain, UTBuilt 2005 · S/N 40.480N8VYHoese Clinton M · Spring Branch, TXS/N VAC-107-78N8WHGarrett Ag Equipment Ltd · Danbury, TXBuilt 2004 · S/N 18281499N8WXRushing Ben H Jr · Natchitoches, LABuilt 1987 · S/N 291N8XARogne Fred A · Fallon, NVBuilt 1997 · S/N 1374N8XCGreenblatt Stan M · Brick, NJBuilt 1997 · S/N 1382N8XEFordice Daniel K III · Vicksburg, MSBuilt 2001 · S/N 2135N8XFGosselin Matthew B · Londonderry, NHBuilt 2005 · S/N 81979N8XJLefore Nikolas · Milton Freewater, ORBuilt 1997 · S/N 1388N8XLHigh C Farms · Saint John, KSBuilt 1999 · S/N 80112N8XNClisham Daniel J · Ann Arbor, MIBuilt 1979 · S/N DC-2N8XTFarrar Lawrence C · Butte, MTBuilt 2003 · S/N 166N8XULevine Laurence · Hernando, MSBuilt 1997 · S/N 1356N8XVWildman Jeanne L · Independence, ORBuilt 2013 · S/N 23200N8XYDuffield Mark F · Shreveport, LABuilt 2002 · S/N 80342N8XZParrish Brian · Lakeland, FLBuilt 2001 · S/N 81022N8YAInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N R18201716N8YQHartlieb Gordon Wesley · Anchorage, AKBuilt 1972 · S/N 17701718N8YVBixby John D · Houston, TXBuilt 2006 · S/N 82030N8ZEtzelmiller Matt P · Heath, TXBuilt 1998 · S/N JONAS - 0008N8ZAMacniven Donald B · Colorado Springs, COBuilt 1992 · S/N 0653N8ZBEastern Nevada Aviation LLC · Gardnerville, NVBuilt 1997 · S/N 3257011N8ZKCalifornia Aviation Services Inc · Riverside, CAS/N 0964N8ZLJackson Steven R · Amado, AZBuilt 2010 · S/N 82903N8ZNRegistered aircraftBuilt 2000 · S/N 80313N8ZQLogue Patrick J · Henderson, NVBuilt 1999 · S/N 6024N8ZVCollins Paul C · Boise, IDBuilt 2013 · S/N 82684N8ZWMccarthy Edward D · New Milford, CTBuilt 1965 · S/N 28-2474N8ZXKansas Farm And Ranch Inc · Seneca, KSBuilt 1995 · S/N 1210-95N9000LHuff Ryan P · Oak Harbor, WABuilt 1968 · S/N 680005N9001DMiller Nancy Lee · Mathews, VABuilt 1958 · S/N 22-6136N9001JZuckerman Kenneth · Grass Valley, CABuilt 1966 · S/N 28-3026N9001WRegistered aircraftBuilt 1964 · S/N 28-10582N9002EWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 17272214N9002FPray Aviation Inc · Augusta, KSS/N 28-7715297N9002HAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265892N9002QNewman Lance H · Maple Valley, WABuilt 2004 · S/N 23891N9003EBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17272215N9003FStack Steven E · Santa Clarita, CABuilt 1976 · S/N 28-7790273N9003JBlack David · Lakeville, MNBuilt 1966 · S/N 28-3028N9003WWard John G · Palm City, FLBuilt 1964 · S/N 28-10584N9004DStevens Matthew W · Elsie, MIBuilt 1958 · S/N 22-6139N9004LThoman Mark C · Jacksonville, NCBuilt 1970 · S/N 240-70
Back to AD 87-10-06 R1