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.

N9458JTibbitts Dennis C · Woodstock, ILBuilt 1966 · S/N 28-3571N9458NSwaz Aviation LLC · Mesa, AZBuilt 1969 · S/N 28R-35174N9458PAmerican Standard Aviation LLC · Burleson, TXBuilt 1971 · S/N 24-4966N9459Sullivan Stanley D · South Jordan, UTBuilt 1973 · S/N S1SN9459NEngel Stephen J · Plymouth, INBuilt 1969 · S/N 28R-35175N9459PRegistered aircraftBuilt 1971 · S/N 24-4967N945DBHoskins Joshua C · Frisco, TXBuilt 2000 · S/N 2843312N945DPPeer Thomas A · Tullahoma, TNBuilt 2022 · S/N 002N945DSKnox Matthew · New Carlisle, OHBuilt 1962 · S/N 28-620N945EBFlying Z LLC · East Lansing, MIBuilt 1998 · S/N 18280137N945FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1980 · S/N R18201484N945GBWarbalow Peter R · Minocqua, WIBuilt 2004 · S/N 5709N945LBAllegro Jeff · Upper Lake, CABuilt 1979 · S/N 28-7990404N945PDHickmott Mark T · Sunol, CABuilt 2001 · S/N 18280945N945PLWheatley John P Jr · Thorp, WABuilt 2005 · S/N 001N945SMFive Rivers Flight Training LLC · Livermore, CABuilt 1981 · S/N 17274742N945TC R Transport Inc · Wilmington, DES/N 17265082N945TADms Aviation Services LLC · Wildwood, MOS/N 11-04N945TELebanon Flying Club Inc · Lebanon, TNBuilt 2003 · S/N 10224N945TLShirley Mae LLC · Franklin, MIBuilt 2004 · S/N 40.413N945UMd Ag Services LLC · Sterling City, TXBuilt 2005 · S/N 10763N945VKTiedemann Daniel W · Carmel, INBuilt 2001 · S/N 20118N9460BEdwards Ag Service · Primghar, IABuilt 1958 · S/N 55260N9460DOlsen Marr B · Kelseyville, CABuilt 1959 · S/N 18-6810N9460JDerosa Michael D · Hewitt, TXBuilt 1966 · S/N 28-3573N9460VDodie Aviation LLC · Sheridan, WYBuilt 1970 · S/N 700038N9461CClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890412N9461DDurghinescu Cris Nicolae · Rancho Mirage, CABuilt 1984 · S/N 172RG1174N9461JKobbeman Joseph B · Louisville, KYBuilt 1966 · S/N 28-3574N9461NJames Neville & Company Inc · Ocala, FLBuilt 1969 · S/N 28R-35177N9461PErickson Jess L · Saco, MTBuilt 1975 · S/N 18-7509133N9461VZembraski Jeffrey · Nocona, TXBuilt 1970 · S/N 700056N9462DEvans Randall Btrustee · Fallon, NVBuilt 1959 · S/N 18-6811N9462NLombardo Gene S · New Bern, NCBuilt 1969 · S/N 28R-35178N9463DHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1984 · S/N 172RG1175N9463KRegistered aircraftBuilt 1976 · S/N 28-7690253N9463VHatcher Mark F · Aloha, ORBuilt 1970 · S/N 700057N9463WHassebroek Leroy A · Little Rock, IABuilt 1968 · S/N 28-11186N9464D907 Aviators LLC · Eagle River, AKBuilt 1958 · S/N 18-6707N9464JReinert Roger J · Duluth, MNS/N 28-3578N9464NTempleton Katherine M · Madison, WIBuilt 1969 · S/N 28R-35180N9464WHollingsworth Ronald W · Shawnee, KSBuilt 1968 · S/N 28-11187N9465DMehrer Fritz J · Oceanside, CAS/N 172RG1176N9465JTaylor Robert J · Woodbridge, VABuilt 1966 · S/N 28-3579N9465NStenhouse Place I LLC · Fountain Inn, SCBuilt 1969 · S/N 28R-35181N9465PFtb Aviation LLC · Arden, NCS/N 24-4974N9466DGerrard Michael K · Kaysville, UTS/N 18-6813N9466EGood Flight Aviation LLC · Stockton, CABuilt 1979 · S/N 17272272N9466JHawk Aviation Academy LLC · Saint Petersburg, FLBuilt 1966 · S/N 28-3580N9466KSpanaflight LLC · Puyallup, WABuilt 1976 · S/N 28R-7635244
Back to AD 87-10-06 R1