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.

N78358All American Aviation LLC · Fort Worth, TXS/N 17257585N78359Burns Stanley R · Flagler, COBuilt 1968 · S/N 17257586N7835NOrrill Bill · Godfrey, ILBuilt 1969 · S/N 28-5289N7835YRegistration Pending · Lewes, DERegistration pendingBuilt 1965 · S/N 30-912N78367Dardis Barry J · Great Falls, MTBuilt 1968 · S/N 17257587N7836NMelancon Scottie J · Baton Rouge, LABuilt 1969 · S/N 28-5291N7836PKearney Kory · Papillion, NEBuilt 1962 · S/N 24-3056N78371Lillace Kevan · Shelby, MTBuilt 1968 · S/N 17257590N78375Bozeman Leasing Inc · Bozeman, MTS/N 17257593N78379Bottrell John E II · Yukon, OKBuilt 1962 · S/N 500A-1265-88N7837GGlass Jay Thomas · El Dorado, ARBuilt 1970 · S/N 17259537N7837HCounsell Michael J · Moses Lake, WABuilt 1946 · S/N 12-737N7837MDiamond B Farm Inc · Gamaliel, KYBuilt 1962 · S/N 2373N7837PMobbd LLC · Vero Beach, FLS/N 24-3057N7837WHock Matthew G · Culbertson, NEBuilt 1964 · S/N 28-1854N78385Amf Aviation LLC · Dallas, GABuilt 1968 · S/N 17257595N78388Fortner Weston · Fort Payne, ALBuilt 1968 · S/N 17257596N7838NWright David P Jr · Chandler, AZBuilt 1969 · S/N 28-5293N78395Fgds LLC · Louisville, KYBuilt 1968 · S/N 17257599N7839DMartin David · Jackson, GABuilt 1957 · S/N 22-5489N7839GGerty Air LLC · Sidney, MEBuilt 1970 · S/N 17259539N7839NHaddle Eddie J · Lindon, UTBuilt 1969 · S/N 28-5295N7839VHafter Mark S · Cincinnati, OHBuilt 1965 · S/N 461N783AJApple Ronald L · Fort Myers, FLBuilt 1979 · S/N AA5B1093N783BWestside Air Inc Renton · Renton, WABuilt 1958 · S/N TD-55N783DGJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1980 · S/N 17274063N783FMFmfa Inc · Wilmington, DEBuilt 1980 · S/N 17274259N783LAN783la LLC · Philadelphia, PABuilt 2025 · S/N 28020215N783LKPullis Troy K · Hutchinson, MNBuilt 1959 · S/N 22-6900N783LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 4496381N783NDVertol Systems Company Inc · Destin, FLBuilt 2016 · S/N 4496398N783RVAvexp1 LLC · Fayetteville, GABuilt 2013 · S/N 74002N783SCWeiblen Glenn P · Castroville, TXBuilt 1979 · S/N R18201002N783SHKmc Aircraft Leasing LLC · Spanish Fork, UTBuilt 2004 · S/N 3617N783VVanstory Randy · New Braunfels, TXBuilt 2020 · S/N 41763N783WWThomas Michael D · Centralia, WABuilt 1998 · S/N 18280351N78408On The Fly Aero LLC · Ocean City, NJBuilt 1968 · S/N 17257604N7840DDavis Steven T · Colleyville, TXBuilt 1957 · S/N 22-5490N7840FLederach David B · Bethlehem, PABuilt 1976 · S/N 28-7790228N7840NBiby Steven R · Churchs Ferry, NDBuilt 1969 · S/N 28-5294N7840VShedd John G · Hopewell, NJBuilt 1965 · S/N 462N7840WTomic Milos · Westminster, COBuilt 1964 · S/N 28-1857N7840XShaw Christopher S · Porterville, CAFirst renewal noticeBuilt 1961 · S/N 48340N7840YArno Philip A · Clarence Center, NYBuilt 1965 · S/N 30-920N7841VKohler Donald L W · Hernando, FLS/N 463N7841WBasin Flyers LLC · Klamath Falls, ORS/N 28-1858N78424Acapulco Flying Club LLC · New Brighton, MNBuilt 1968 · S/N 17257611N78428Cypher Anne K · The Dalles, ORBuilt 1968 · S/N 17257612N78429Doughty Robert M · Earlville, ILBuilt 1968 · S/N 17257613N7842BLowe David M · Sacramento, KYBuilt 1956 · S/N 23-632
Back to AD 87-10-06 R1