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.

N7236PMark A Smith Aircraft Sales Inc · Homosassa, FLBuilt 1961 · S/N 24-2410N7236QTeren Nelson F · Friday Harbor, WABuilt 1972 · S/N 17260536N7237DBobinchak Richard G · Sheridan, WYBuilt 1957 · S/N 22-5063N7237GIvoprop Corp · Long Beach, CABuilt 1970 · S/N 17258937N7237QMartin Bach Aviation LLC · Cornelius, NCBuilt 1972 · S/N 17260537N7237WPetropulos James J · Juneau, AKBuilt 1963 · S/N 28-1056N72383Niagarawings Aviation LLC · Niagara Falls, NYBuilt 1977 · S/N 28-7890141N7238FDoll William J · Carlisle, PABuilt 1968 · S/N 28-25150N7238LHorizon Flight Center LLC · Chesapeake, VABuilt 1981 · S/N ME-433N7238VKnutson Wayne R · Thompson, NDBuilt 1966 · S/N 1275N7238WRupert Shon D · Greenwood, ARBuilt 1963 · S/N 28-1057N7239DHaning Thomas B · Vian, OKBuilt 1957 · S/N 22-5065N7239KHodgson Joel R · Palmer, AKBuilt 1951 · S/N 18-131N7239PMccabe Gregory · Melbourne Beach, FLBuilt 1960 · S/N 24-2413N7239WWiza Jason · Custer, WIBuilt 1963 · S/N 28-1059N723AGShortt Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 40.427N723AJCavorite Aviation LLC · West Jordan, UTBuilt 2005 · S/N 2843613N723AKFrohnapfel Mark T · Cordova, AKBuilt 1974 · S/N 76-74N723CCavner Hudson A · Port Alsworth, AKS/N 18-1150N723CBPrivateflyer LLC · Lewes, DEBuilt 1978 · S/N 14398N723CFCay Air Inc · Largo, FLBuilt 1977 · S/N 32R-7780508N723CJNicholson Scott V · Kalamazoo, MIS/N 20011CN723CLVan Why Johnathan Ryan · Corvallis, ORBuilt 1999 · S/N 829-99N723CTN723ct LLC · Bend, ORBuilt 2006 · S/N 82292N723GPuerta Jose Fernando Del Valle · Miami, FLBuilt 1976 · S/N 17268008N723GALong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N GA7-0021N723JSAlbertson James M · Westville, FLBuilt 1967 · S/N 30-1512N723KYCommonwealth Of Kentucky · Frankfort, KYBuilt 1978 · S/N 31-7852122N723LHParker Robert · Oklahoma City, OKBuilt 1990 · S/N 723N723MRaber Micah D · Wasilla, AKS/N 23003CN723MLVertical Corp · Kalispell, MTBuilt 1996 · S/N 2639N723PC43rd Aviation Flying Club Inc · Norfolk, CTFirst renewal noticeBuilt 1998 · S/N 2843194N723PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 17280675N723PMCeu LLC · Greer, SCBuilt 1967 · S/N 28-4329N723RGHatchett Creek Leasing Inc · Delta, ALBuilt 2005 · S/N 10658N723RVSmith Stuart T · Murrieta, CABuilt 1981 · S/N 727N723SSmaltz David I · Newmanstown, PAS/N M-1384N724Morrison Richard L Trustee · Anchorage, AKBuilt 1999 · S/N 2009N72400Brown Michael · Greeneville, TNFirst renewal noticeBuilt 1999 · S/N 2031N72403Drury Edward D · Little Silver, NJS/N 33701576N7240FDewberry Dylan C · Springfield, ORBuilt 1968 · S/N 28-25153N7240GKendallville Flying Club Inc · Auburn, INBuilt 1970 · S/N 17258940N7240JFlytt LLC · Naples, FLBuilt 1968 · S/N 28-24577N7240YHodges David S · Reidsville, GABuilt 1964 · S/N 30-264N7241CHeritage Timothy D · Glendale, AZBuilt 1975 · S/N 28-7625073N7241DFrisby James A · Palmer, AKBuilt 1957 · S/N 22-5262N7241JHopkins Justin C · Benson, AZFirst renewal noticeS/N 28-24578N7241WBurtchett Tyler D · Buckeye, AZBuilt 1963 · S/N 28-1075N72421N83882 Inc · Huntington, NYBuilt 1968 · S/N 17257407N72424Magill William J · Moncks Corner, SCS/N 241523
Back to AD 87-10-06 R1