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.

N9284KMtm Aviation LLC · Lake Havasu City, AZBuilt 1976 · S/N 28-7615193N9284MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1985 · S/N 28-8616042N9284PDickinson Malcolm · Stamford, CTBuilt 1968 · S/N 24-4784N9284STamad Aviation LLC · Tracy, CABuilt 1975 · S/N MC-329N9284VBloomer Garett · Ballston Lake, NYBuilt 1969 · S/N 690064N9284WGutierrez Daniel M · Kennett Square, PABuilt 1967 · S/N 28-10960N9284X84x Leasing LLC · Idaho Falls, IDBuilt 1997 · S/N 4636087N9284ZFlex Aircraft Leasing Co LLC · Detroit, MIBuilt 1997 · S/N 3246064N9285November 9285 LLC · Higden, ARBuilt 1978 · S/N 1003N92855Falcon Flying Club · Mesa, AZBuilt 1973 · S/N 17261634N9285CSunset Flights LLC · Azusa, CABuilt 1978 · S/N 28-7890396N9285HOrion Aviation Aircraft LLC · Carlsbad, CABuilt 1975 · S/N 17266068N9285JCope Jarret C · Lexington, NCS/N 28-3369N9285M5 M Leasing LLC · Englewood, COBuilt 1985 · S/N 28-8616043N9285PStumpf Bernard L · Westerly, RIBuilt 1968 · S/N 24-4785N9285QJrb Aviation Ltd · Jasper, GABuilt 1997 · S/N 3257023N9285VEllsworth Bryan E · Garden City, UTS/N 690079N9285YUeeck Brett A · Anchorage, AKBuilt 1971 · S/N 18-8919N9286Drent Ethan M · Greenwood, INS/N 165N9286DCaldwell Bob · Columbus, MSBuilt 1958 · S/N 18-6592N9286FFlying High Like A Bird In The Sky · Longwood, FLBuilt 1974 · S/N 1040368N9286MWiley Aviation LLC · Murfreesboro, ARBuilt 1985 · S/N 28-8616044N9286TMccabe Robert C Jr Trustee · Santa Rosa Beach, FLBuilt 1996 · S/N 11247N9286VRupinski Casimir Michael III · Cape May, NJBuilt 1969 · S/N 690080N9286WAmigos Flight Club LLC · Schertz, TXBuilt 1967 · S/N 28-10962N92873Sonday Terrance P · Spring, TXBuilt 1973 · S/N 17261636N92878Jackson Richard L · Indianapolis, INBuilt 1973 · S/N 17261638N9287ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 1997 · S/N 2842019N9287SDale Michael W · Clayton, NCS/N MB-758N9287VRuschman Vaughn M · Boise, IDBuilt 1969 · S/N 690080N92884Bas Part Sales LLC · Greeley, COBuilt 1997 · S/N 4636107N92886Lewis John E · Clayton, NJBuilt 1973 · S/N 17261640N92888Knudsen Wayne D · Dakota City, NEBuilt 1973 · S/N 17261641N92889Miller Andy · Marana, AZBuilt 1973 · S/N 17261642N9288BWuest Air LLC · Wilmington, DEBuilt 1997 · S/N 3246079N9288JMccormack John P · New Castle, INS/N 28-3373N9288KCoug Air LLC · Oregon City, ORBuilt 1976 · S/N 28-7690240N9288MHogue Marc A · Tempe, AZBuilt 1966 · S/N 1221N9288PLivingston Jerry D · Wichita, KSBuilt 1968 · S/N 24-4788N9288RShane Wilson Pa · Fort Myers, FLBuilt 1978 · S/N R18200679N9288VMooney N9288v LLC · Fernandina Beach, FLBuilt 1969 · S/N 690081N9288WThut Bruno H · Chagrin Falls, OHBuilt 1967 · S/N 28-10965N92894Smith Rex H · Fort Bragg, CABuilt 1973 · S/N 17261644N9289CSmallwood Chadwick D · Newnan, GABuilt 1978 · S/N 28-7890397N9289MUa Aero LLC · Lewes, DEBuilt 1966 · S/N 660004N9289PSvetlik Ludvik Julius · Victoria, TXS/N 24-4789N9289SThomsen Patrick J · Star Prairie, WIBuilt 1975 · S/N M-1651N9289VSteel Richard Allen · Milford, NHBuilt 1969 · S/N 690081N9289WCoffman John H · Polo, ILBuilt 1967 · S/N 28-10966N928ARGuluzza Gary W · Canyon Country, CABuilt 1979 · S/N M-2236
Back to AD 87-10-06 R1