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.

N726Veerhusen Daniel F · Homer, AKS/N 18-8309021N72608Gv Air Inc · Medford, ORBuilt 2001 · S/N T20608268N7260FRandy'S Rodz LLC · Missoula, MTBuilt 1968 · S/N 28-25178N7260HN2617f LLC · Frankfort, KYBuilt 2000 · S/N 18280896N7260KAmbitious Aviation LLC · Newport News, VABuilt 2000 · S/N 18280895N7260PPotts Leah Marie · Roanoke, VABuilt 1961 · S/N 24-2436N7260QNaples Flying Club Inc · Naples, FLBuilt 2001 · S/N 18280957N7260WO'Day John E · Rindge, NHBuilt 1963 · S/N 28-1092N7260YDeuce Aire LLC · Middletown, DEBuilt 1964 · S/N 30-294N72614Liberty Leasing IV LLC · Melbourne, FLBuilt 2000 · S/N 20608117N7261GKindblade Aeronautics LLC · Casper, WYBuilt 1970 · S/N 17258961N7261MCox Jeff C · Newark, OHBuilt 2000 · S/N 18280901N7261PHolleman William James · Simpsonville, SCBuilt 1961 · S/N 24-2437N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561N7261WKurywchak Daniel A · Cameron Park, CABuilt 1963 · S/N 28-1093N7261YKocak Robert G Jr · Peoria, AZBuilt 1964 · S/N 30-295N72623Law Office Of Vincent G Rieger Pc · Kalispell, MTS/N T20608162N7262ACf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2000 · S/N 20608138N7262FParlee Chad E · Lakeport, CABuilt 1968 · S/N 28-25181N7262JKemp Lyman E · Ketchikan, AKBuilt 1968 · S/N 28-24584N7262MRegistered aircraftBuilt 2000 · S/N 18280900N7262PParker Dennis Scott · Lubbock, TXBuilt 1961 · S/N 24-2438N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562N7262WDube Colin T · Minot, MEBuilt 1963 · S/N 28-1095N72634Rnd Technologies LLC · Lancaster, CABuilt 1999 · S/N T20608108N72638Dysart Jack L · Steamboat Springs, COBuilt 1999 · S/N T20608127N72639Dischler Stephen · New Lisbon, WIBuilt 1999 · S/N 17280806N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963N7263JKl Aviation LLC · Catawba, NCBuilt 1968 · S/N 28-24548N7263PHoffman Raymond F · Encinitas, CABuilt 1960 · S/N 24-2439N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563N7263WKontour Shawn K · Wheatland, WYBuilt 1963 · S/N 28-1096N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1964 · S/N 30-298N7263ZAnderson Daniel A · Overly, NDBuilt 1965 · S/N 25-3200N7264DGravity & Grace LLC · Mill Valley, CABuilt 1999 · S/N 20608062N7264FPodyaire LLC · Ruston, LAS/N 28-25184N7264HDelta Sierra Aviation LLC · White Salmon, WABuilt 1999 · S/N T20608103N7264JHoseney Richard W Jr · Como, MSBuilt 1968 · S/N 28-24532N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564N7264WFehringer John T · Sidney, NES/N 28-1097N7264YYogi Air LLC · Wadsworth, OHBuilt 1964 · S/N 30-299N7265Walker Teresa L · Enid, OKBuilt 1963 · S/N 24-3454N72653Atp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280807N72658Tidewater Flying Club Inc · Newport News, VABuilt 1999 · S/N 18280643N7265BHolladay Aviation LLC · Jacksonville, FLBuilt 1999 · S/N 17280749N7265FShouling & Philip Enterprise · Lancaster, CAS/N 28-25185N7265JSwoboda Charles · Anchorage, AKBuilt 1968 · S/N 28-24528N7265KSale Reported · Phoenix, AZSale reported, canceledBuilt 1950 · S/N 18-158N7265PQuinlan John H · Claxton, GABuilt 1961 · S/N 24-2441N7265REmerald City Aircraft Leasing Inc · Port Orchard, WAS/N T20608045
Back to AD 87-10-06 R1