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.

N7803GTomlin Jonathan S · Georgetown, OHS/N 17259503N7803PNoguess James E · Deming, NMS/N 24-3064N7803VArtlip James · Wake Forest, NCS/N 2787N7803W3w Group Inc · Hot Springs, ARS/N 28-1807N78048Latham Randall W · Georgetown, OHBuilt 1946 · S/N 2048N7804GWells Adam · New Lexington, OHBuilt 1970 · S/N 17259504N7804NApaa Aviation Group LLC · Frisco, TXBuilt 1969 · S/N 28-5254N7804PFisher B Barton · Bowman, NDBuilt 1962 · S/N 24-3023N7804VVickers David Dewayne · Douglas, GABuilt 1964 · S/N 2788N78051Sipple Ronald W Jr · Gardner, KSS/N 2051N7805DMoretti Anthony · Deming, NMBuilt 1957 · S/N 22-5450N7805GArgabright John · Waterford, OHBuilt 1970 · S/N 17259505N7805NCorrigan Air Center · Hondo, TXBuilt 1968 · S/N 28-5256N7805PN6760s LLC · Brooklyn, NYBuilt 1962 · S/N 24-3073N7805YN7805y LLC · Winchester, VAS/N 30-884N78066Orlandi Properties LLC · Blairstown, NJBuilt 1968 · S/N 17257470N7806DHillegeist Tracy L · Beverly, KSS/N 22-5453N7806GAircraft Management Services Inc · Milton, FLBuilt 1970 · S/N 17259506N7806NTab Air Time LLC · Longmont, COBuilt 1968 · S/N 28-5257N7806PSpires Kenneth G · Seville, OHBuilt 1962 · S/N 24-3025N7806VMouriz Javier · Leesburg, FLBuilt 1964 · S/N 2790N7806YHhozapnv-LLC · Las Vegas, NVBuilt 1965 · S/N 30-885N78074Bartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 2074N78076Clinton Aeroclub · Clinton, IABuilt 1968 · S/N 17257472N78078International Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17257473N7807GLake Of The Woods Aviation LLC · Baudette, MNS/N 17259507N7807NBwh Leasing LLC · Lewes, DEBuilt 1968 · S/N 28-5258N7807SSmith Travis T · Watsonville, CABuilt 1976 · S/N 584-76N7807VMad Dog Aviation LLC · Minot, NDBuilt 1964 · S/N 2791N7807YMcv2021 LLC · Saint Augustine, FLBuilt 1965 · S/N 30-886N78083Holcomb Garry · Point, TXBuilt 1946 · S/N 2083N78086Drake Ronald N · Helena, MTBuilt 1968 · S/N 17257475N7808VWalker Trenton A · Pittsburg, OKBuilt 1964 · S/N 2792N7808YKleiner Daniel S · Aliso Viejo, CABuilt 1965 · S/N 30-887N7808ZWiedeman Matthew A · Batesville, INBuilt 1966 · S/N 18-8485N78095Leuer James A · Encinitas, CABuilt 1968 · S/N 17257480N7809GHodge Aviation LLC · Monroe, LABuilt 1970 · S/N 17259509N7809NUninsured Justice Enterprises LLC · Joplin, MOBuilt 1968 · S/N 28-5260N7809SJo Ann Miller Marshall · Atlanta, GABuilt 1976 · S/N 265-76N7809WHand Lawrence E · Klamath Falls, ORBuilt 1964 · S/N 28-1816N780ACSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 301967N780BGMaw Enterprises USA LLC · Hudson, FLBuilt 1980 · S/N 17274382N780DAFawley Dean · Newnan, GABuilt 1969 · S/N 28-5328N780DMTexas Barnstormers LLC · Rogers, TXBuilt 2004 · S/N 464-2004N780GAPrairie Planes LLC · Mitchell, SDBuilt 1978 · S/N GA7-0067N780GCAir Eye Md LLC · Carolina, PRBuilt 1978 · S/N 317812069N780GWSchreiber-Beck Cynthia K · Wahpeton, NDS/N 780N780LAN780la LLC · Philadelphia, PABuilt 2025 · S/N 28020222N780NWBarthold David Keith · Gainesville, TXBuilt 2011 · S/N 73480N780SN780s LLC · Williamstown, NJBuilt 1978 · S/N 87
Back to AD 87-10-06 R1