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.

N6TVTravelaire Service Inc · Wilmington, DES/N 17275278N6UCZborowski Ronald W · Eighty-Four, PABuilt 1975 · S/N 27-7554079N6UKN6uk LLC · Goshen, INBuilt 1978 · S/N 32-7840123N6UULoerzel James E · Arlington Heights, ILBuilt 2005 · S/N 25887N6VDEllison Jeremy · Dayton, NVBuilt 1981 · S/N A7354CN6WChase Roy M · Limington, MEBuilt 1970 · S/N 29PN6WADue North Aviation LLC · League City, TXBuilt 1971 · S/N 17701676N6WEHigh Flight Aviation LLC · Harwinton, CTBuilt 1993 · S/N 3213050N6WNDart Gregory G · Mayville, NYS/N 198N6XAFlying Farmers LLC · Dalhart, TXBuilt 1997 · S/N 1366N6XCNorthstar Aerospray Inc · Clara City, MNBuilt 1997 · S/N 1383N6XLCrowe Donald L · Mcallen, TXBuilt 1986 · S/N MHS-1985N6XQAccuracy 1st · Canadian, TXBuilt 1999 · S/N 2026N6YGArcher Project Management LLC · Forney, TXBuilt 2003 · S/N 25903N6YLHolman Leasing LLC · Anchorage, AKS/N 301162N6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 30-572N6YQBeek Dudley E · Miami, FLBuilt 1994 · S/N 451N6YSHawk Aircraft Sales & Leasing LLC · Sterling Heights, MIBuilt 2003 · S/N 1348N6YTCassinelli Steven W · Oceanside, ORBuilt 2002 · S/N 2198N6YVZadrozny Pedro A · Wellington, FLBuilt 1978 · S/N 32R-7885160N6ZHarris Hayden H · Chelsea, MIBuilt 1980 · S/N JM-2N6ZGTta Logistics LLC · Christiansted, VIBuilt 1968 · S/N 27-3872N6ZHPetranek Diana C · Albion, NYBuilt 2000 · S/N PMG002N6ZPAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274020N6ZRBreed Paul T · Solana Beach, CABuilt 1980 · S/N 61P07168063346N6ZTLewis Eddy L · Cortez, COBuilt 1957 · S/N 18-5824N700Dailey Jeffrey D · Weirton, WVBuilt 1971 · S/N 317-71N70000Carson Mark L Trustee · Northfield, MNBuilt 1976 · S/N 17267178N70004Gbl Aviation LLC · Laurel, MSBuilt 1976 · S/N 17267179N7000RJilek Peter Andrew · River Falls, WIBuilt 1966 · S/N 28-21693N7000WIndy Air Sales LLC · Anderson, INBuilt 1962 · S/N 28-671N7000XWalsh Peter F · Walpole, MABuilt 1971 · S/N 28R-7135172N7000YSlowpoke Air LLC · Palm Harbor, FLBuilt 1966 · S/N 30-1188N7001DOwens Eldon J · Arimo, IDS/N 22-4894N7001PPavlusik Tibor · Fort Mill, SCS/N 24-2146N7001WBrinc LLC · Lancaster, PABuilt 1963 · S/N 28-673N7002PMonterey Bay Aviation Inc · Watsonville, CABuilt 1960 · S/N 24-2147N7002ZKistler Michael J · Wasilla, AKS/N 18-8180N70032Alpha Wings Inc · Willoughby, OHBuilt 1976 · S/N 17267180N7003BByrd Kyle E · Unionville, MOBuilt 1956 · S/N 22-4253N7003PAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 24-2148N70046Zane Newton F · Rllng Hls Est, CAS/N 17267183N7004FSouthern Vector Aerospace LLC · Huntsville, ALS/N 28-7790176N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704N7004REasley Leroy · Novelty, MOFirst renewal noticeBuilt 1966 · S/N 28-21698N7004WLettsome Nesco · Beltsville, MDBuilt 1962 · S/N 28-676N7005Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020180N70052Hastings Heidi · Wasilla, AKBuilt 1976 · S/N 17267185N7005GHamilton Peter D · Bear, DEBuilt 1969 · S/N 17258705N7005QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260305
Back to AD 87-10-06 R1