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.

N8853JN8853j LLC · Oak Park, ILBuilt 1965 · S/N 28-2817N8853PGebhart Kevin E · Burley, IDBuilt 1965 · S/N 24-4309N8854CMid Continent Aircraft Corp · Hayti, MOBuilt 1953 · S/N 18-2900N8854DKidd Clifford L Jr · Monahans, TXBuilt 1958 · S/N 22-6025N8854LPfs Air Inc · Yellville, ARBuilt 1974 · S/N AA5-0654N8854WCherokee235 LLC · Kalispell, MTFirst renewal noticeBuilt 1964 · S/N 28-10408N8854YSeeds John S Jr Trustee · Tequesta, FLBuilt 1970 · S/N 39-9N8855NIndy Distributors Inc · Noblesville, INBuilt 1969 · S/N 28-25709N8855PTja Pop Ltd · Dix Hills, NYBuilt 1965 · S/N 24-4311N8856CBritton Mark W · Wasilla, AKBuilt 1953 · S/N 18-2913N8856FRotorcraft Unlimited LLC · Brooksville, FLS/N 43-0194N8856JFifty Six Juliet LLC · West Lafayette, INS/N 28-2820N8856LRuales Edison R · Miami, FLFirst renewal noticeBuilt 1974 · S/N AA5-0656N8856NGrant Shane J · Cape Coral, FLBuilt 1969 · S/N 28-25711N8856WSouthard Brian W · Washington, OKS/N 28-10410N8857Aviation Management Systems LLC · Fallbrook, CABuilt 1973 · S/N 254-73N8857DHollan William E Jr · Winston Salem, NCBuilt 1958 · S/N 22-6028N8857JNguyen Tu K · Costa Mesa, CABuilt 1965 · S/N 28-2822N8857MDunn Brady · Gilmer, TXS/N M-597N8857NWolf Terry T · Lake Katrine, NYBuilt 1969 · S/N 28-25712N8857YLewis Leslie S · Glendale, AZBuilt 1970 · S/N 39-12N8858JBirdie N88 LLC · Conifer, COBuilt 1965 · S/N 28-2928N8858PMachmiller A A · San Jose, CABuilt 1965 · S/N 24-4315N8858WCassidy Kirk B · La Canada, CABuilt 1964 · S/N 28-10412N8859DBbc Group LLC · Sanford, NCBuilt 1958 · S/N 22-6030N8859NThrash Enterprises LLC · Clarksville, TNBuilt 1969 · S/N 28-5340N8859PGowins John C · New Philadelphia, OHBuilt 1965 · S/N 24-4317N885ACWingsleasing LLC · Wichita, KSBuilt 2020 · S/N 2881396N885ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496322N885FTFlorida Institute Of Technology · Melbourne, FLBuilt 2006 · S/N 4496225N885HAFox Airways LLC · Wasilla, AKS/N 31-7405416N885LHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLBuilt 2002 · S/N 1268N885SABlevins Edgar R · Zachary, LABuilt 2001 · S/N 0014N885SMDews Robert Mark · Jefferson, TXS/N 24673N8860DCooley Tony A · Dallas, ORBuilt 1958 · S/N 22-6032N8860JBjg LLC · Langdon, NHBuilt 1965 · S/N 28-2826N8860WLayth Air LLC · Martin, TNBuilt 1964 · S/N 28-10414N8861FMurtaza Syed S · Minneapolis, MNBuilt 1976 · S/N 28-7715292N8861NMcdonald Timothy A · Rush City, MNBuilt 1969 · S/N 28-25410N8861PForney Garry L · El Centro, CABuilt 1965 · S/N 24-4318N8861WFrancavilla Charles · Fremont, CABuilt 1964 · S/N 28-10416N8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715293N8862LTisdale Matthew · Alameda, CABuilt 1974 · S/N AA1B-0362N8862NHatley Wayne S · Hermitage, TNBuilt 1969 · S/N 28-25717N8862TAdams Donald L · Huntsville, ALBuilt 2010 · S/N 72640N8862VInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31022N8862YState Of Montana · Helena, MTBuilt 1973 · S/N 18-7409026N8863Lilly Daryl A · Winterset, IABuilt 2010 · S/N 40458N8863DSanders Darrel T · Camp Douglas, WIBuilt 1958 · S/N 22-6037N8863FCain James W · Big Rapids, MIS/N 63-0243
Back to AD 87-10-06 R1