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.

N83022Webber James F · Arvin, CABuilt 2016 · S/N 001N83029Travis Aviation LLC · Jacksonville, TXS/N 28-8311005N8302A4 Moons Aviation Inc · Danvers, MABuilt 1980 · S/N 28-8116092N8302CAcey Joseph P · Macomb, MIBuilt 1975 · S/N 28-7610073N8302JValley Gabriel · Holden, MEBuilt 1967 · S/N 15066202N8302RHofmann Richard C · Keizer, ORFirst renewal noticeBuilt 1966 · S/N 28-22079N8302TYarb LLC · Cleburne, TXBuilt 1980 · S/N 28-8190103N8302WNaccarato Aviation LLC · Woodstock, GABuilt 1965 · S/N 28-2467N8302YArnold Roger R · Jonesville, LAS/N 30-1441N83038Zimin Transportation LLC · South Naknek, AKBuilt 1980 · S/N 28-8116096N83039Macair Aviation LLC · Xenia, OHBuilt 1980 · S/N 28-8116097N8303DPhoenix Mooney LLC · Vista, CABuilt 1981 · S/N 28-8111032N8303QDucota 6 LLC · Jasper, INBuilt 1982 · S/N 28-8311006N8303WIrwin Jerome C · Anchorage, KYS/N 28-2468N8304KKrouse James · Cocoa Beach, FLS/N 28-8190107N8304LGarrai LLC · Rhinebeck, NYS/N 28-8190108N8304PBourne Robert E Trustee · Midland, MIBuilt 1963 · S/N 24-3556N8304RKnots And Attitudes LLC · Wimberley, TXBuilt 1966 · S/N 28-22171N8304VHorning Air LLC · Cresbard, SDBuilt 1969 · S/N 44N8304WCassin William J · Uvalde, TXBuilt 1965 · S/N 28-2471N8305LPipsara LLC · Jacksonville, FLBuilt 1980 · S/N 32-8106018N8305VBell Anthony J · Avondale, AZBuilt 1966 · S/N 98N8306CCoolidge Oliver · Downers Grove, ILBuilt 1975 · S/N 28-7625100N8306D75s Leasing LLC · Greenwood Village, COBuilt 1958 · S/N TD-30N8306RPernula Jacob D · Mount Vernon, WABuilt 1966 · S/N 28-22175N83076N83076 LLC · Wayne, PABuilt 1980 · S/N 28-8116102N8307RKlingerman Chester E Jr · Plymouth, INBuilt 1966 · S/N 28-22176N8307WPeden Travis Austin · Sheridan, WYBuilt 1965 · S/N 28-2476N8307YParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8116100N83089Mountz James M · Birmingham, ALBuilt 1980 · S/N 32-8106025N8308CN8308c LLC · Haymarket, VABuilt 1975 · S/N 28-7690113N8308EBo Rafter Tx LLC · Gail, TXBuilt 1960 · S/N 1580N8308LClassic Wings · Westlake Village, CAS/N 28-8316017N8308MGfl Aircraft Leasing Corp · Glens Falls, NYBuilt 1980 · S/N 32-8106020N8308RClassic Flyers Club Inc · Hastings, NEBuilt 1966 · S/N 28-22177N8308VCleary Paul D · Guilford, CTBuilt 1980 · S/N 32R-8129016N8308WSchlenker Richard A · Meeteetse, WYBuilt 1965 · S/N 28-2478N8309ASchmidtys Air LLC · Stuart, FLBuilt 1980 · S/N 32-8106026N8309EPlanewright Inc · Newberg, ORBuilt 1983 · S/N 28-8390013N8309KClaridge Michael A · Houston, TXBuilt 1982 · S/N 28-8390015N8309RPipal Cory J · Dublin, TXBuilt 1966 · S/N 28-22179N8309VSunde Bradley J · Fergus Falls, MNBuilt 1966 · S/N 95N8309YHolman Michael J · Anchorage, AKBuilt 1967 · S/N 30-1448N830ADb-Gbr LLC · Sarasota, FLBuilt 1962 · S/N M-36N830AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2000 · S/N 0838N830BMurphys Auto Gyro Sales LLC · Dade City, FLBuilt 2015 · S/N SC006N830BSShortt Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 40.395N830BVRegistration Pending · Manhattan, MTRegistration pendingBuilt 1979 · S/N 28-7911289N830CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281300N830LMKq Aviation LLC · Old Town, FLBuilt 1988 · S/N 11048C
Back to AD 87-10-06 R1