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.

N831SHHutchison Eugene W · Armagh, PABuilt 2005 · S/N 3793N831TSWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 28-7415485N831VZMelbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276416N83208Rothrock Cara J · Streator, ILS/N 28-8116124N8320AMendez Leonel Jr · Corpus Christi, TXBuilt 1995 · S/N 2510N8320CRiffle Bruce H · Chesterton, INBuilt 1975 · S/N 28-7690115N8320PCallicrate Michael P · Saint Francis, KSBuilt 1963 · S/N 24-3571N8320VThurman Randall N · Mcminnville, ORBuilt 1966 · S/N 399N8320WOracle Aviation LLC · Omaha, NEBuilt 1965 · S/N 28-2495N8320YKling Aviation Inc · Friendswood, TXBuilt 1967 · S/N 30-1460N83210Chapman Jeremy · Niagara Falls, NYBuilt 1980 · S/N 32-8106035N83212Salty Flights LLC · Labelle, FLBuilt 1980 · S/N 32R-8113034N83213P-R Aircraft LLC · Snellville, GABuilt 1981 · S/N 32R-8113035N8321CJackson Blane · Beaufort, NCBuilt 1975 · S/N 28R-7635147N8321HJust Plane Fellas LLC · Omro, WIBuilt 1980 · S/N 28-8116125N8321LArevalo Gilbert Jr · Loranger, LABuilt 1980 · S/N 28-8190136N8321MFox Two LLC · Camino, CABuilt 1980 · S/N 28-8190137N8321PSmoketown Helicopters LLC · Smoketown, PABuilt 1995 · S/N 2538N8321RThompson Grady R · Athens, ALBuilt 1966 · S/N 2822192N8321TRobinson Denise · Middletown, CTBuilt 1980 · S/N 28-8190140N8321WWeighman David R · Battle Creek, MIBuilt 1965 · S/N 28-2496N8322EHorton Ernest J III · Galveston, TXBuilt 1959 · S/N 1500N8322KSmith Gregory L · West Des Moines, IABuilt 1980 · S/N 32R-8129031N8322LHorizon Aviation Of Myrtle Beach LLC · Myrtle Beach, SCBuilt 1980 · S/N 32R-8129032N8322PBroken Arrow Crop Insurance Inc · Perryton, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129033N8322SAtp Aircraft 4 LLC · Wilmington, DEBuilt 1980 · S/N 44-8195014N8322V11 Point Aviation LLC · Alton, MOBuilt 1966 · S/N 65N8322WLickteig Eric Kirk Trustee · Ellensburg, WABuilt 1965 · S/N 28-2499N8322YDayhoff Miller Alice J · Springfield, OHBuilt 1967 · S/N 30-1463N83231Padilla Rafael R · Monee, ILBuilt 1980 · S/N 28-8111047N8323AWisconsin Aviation Inc · Watertown, WIBuilt 1981 · S/N 28-8216019N8323BMidcoast Helicopter Services Inc · La Ward, TXBuilt 1995 · S/N 2535N8323FDavis William · Texarkana, TXBuilt 2000 · S/N 18280879N8323SOdell Ronald W · Peachtree City, GABuilt 1982 · S/N 32-8324005N8323WConcord Aviation Services LLC · Concord, NHBuilt 1965 · S/N 28-2500N8323YRochester Flying Club Inc · Rochester, NYBuilt 1980 · S/N 28-8111045N8323ZChapman Farms Inc · Vernon, COBuilt 1980 · S/N 28-8111046N8324EGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 17272189N8324PCirrus Air LLC · Eden, NCBuilt 1963 · S/N 24-3575N8324TTango LLC · Chesterfield, MOS/N 32-8106036N8324USyren David N · Anchorage, AKBuilt 1995 · S/N 2570MN8324YStein Anthony J · Locust Grove, GABuilt 1967 · S/N 30-1465N8325EAnzaldi Carl J · Cherry Valley, CABuilt 1959 · S/N 1503N8325LLeading Edge Flight Services Inc · Hampshire, ILBuilt 1980 · S/N 28-8116131N8325RSy Aviation LLC · Judsonia, ARS/N 28-22197N8325TColumbia Jet Center Inc · Columbia, MOBuilt 1980 · S/N 28-8116134N8325UCross Dustin · Tonto Basin, AZBuilt 1964 · S/N 17252225N8325VPct Hawk Inc · Wilmington, DEBuilt 1980 · S/N 28-8190143N8325WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 28-2502N83268Wright Kim B · Bozeman, MTS/N 18-7609057
Back to AD 87-10-06 R1