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.

N9474VCasa Patrick Greg · Albuquerque, NMBuilt 1970 · S/N 700061N9474WGoines Russel D · Highland, CABuilt 1968 · S/N 28-11204N9475DRoe Dennis N · Fairbanks, AKBuilt 1958 · S/N 18-6725N9475EBerzinis Wayne T · Windham, MEBuilt 1979 · S/N 17272275N9475PGorin Eugene · Cedar Grove, NJBuilt 1971 · S/N 24-4987N9475WGiese Aerial Inc · Hoffman, MNBuilt 1968 · S/N 28-11205N9476FF & M Miya LLC · Hanford, CABuilt 1998 · S/N 18280208N9476HHelicopter Partners Inc · Wellington, FLBuilt 1975 · S/N 17266172N9476JNery Thomas A · Mansfield, MABuilt 1966 · S/N 28-3592N9476NScheigert Delbert F Jr · Tucson, AZBuilt 1969 · S/N 28R-35193N9476PEdgar Montgomery Robert · Butler, PABuilt 1971 · S/N 24-4988N9477DJ H Miller & Son Inc · Saint John, WABuilt 1958 · S/N 18-6729N9477JMatthews Byron Kim · Hooper, UTS/N 28-3593N9477LSlipstream Aviation LLC · Carrollton, GABuilt 1986 · S/N 17276562N9477VMurnville Glenlove Flyers Ltd · Delaware, OHBuilt 1970 · S/N 700062N9477WBaker John E · Westfield Center, OHBuilt 1968 · S/N 28-11210N9478NChadwick Aviation Services LLC · Monroe, CTBuilt 1969 · S/N 28R-35196N9478WAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1968 · S/N 28-11211N9479DGrote Neal Scott · Harrison, NEBuilt 1959 · S/N 18-6822N9479WSchacher Daniel E · Muleshoe, TXBuilt 1968 · S/N 28-11213N947MRonneburger Brian · Northport, NYBuilt 1969 · S/N 30-1947N947TESkyway V LLC · Naples, FLBuilt 2003 · S/N 10226N947TTPucciariello Alexander A · Punta Gorda, FLBuilt 2000 · S/N 3947N9480CDave Gross Inc · Midland, TXBuilt 1978 · S/N 28-7816480N9480DKent State University · Stow, OHBuilt 1985 · S/N 172RG1180N9480EMoyer Aviation Inc · Tobyhanna, PABuilt 1979 · S/N 17272277N9480HMoynihan Patrick J · Lakeville, MNBuilt 1975 · S/N 17266173N9480J217 Moriarty LLC · Stonewall, MSBuilt 1966 · S/N 28-3597N9480PJmo LLC · Ridgeland, MSBuilt 1971 · S/N 24-4992N9480RWestern Montana Orthopaedic LLC · Missoula, MTS/N R18200708N9481DBoemig Madison K · Dalton, NHBuilt 1985 · S/N 172RG1181N9481JRuffner Samuel D · Powder Springs, GABuilt 1966 · S/N 28-3598N9481KHepp Investments LLC · Warrens, WIBuilt 1976 · S/N 28-7615205N9481NKing Cindy · Purvis, MSBuilt 1969 · S/N 28R-35199N9481PJeffcoat Cory D · Kountze, TXBuilt 1971 · S/N 24-4993N9481VStutzman Mervin · Kingman, INBuilt 1970 · S/N 700046N9481WMcintyre Stephen C · Lumberton, NCBuilt 1968 · S/N 28-11216N9482CSchuetz Ray · Davie, FLBuilt 1978 · S/N 28-7816481N9482DHanley Company LLC · Littleton, COBuilt 1958 · S/N 18-6734N9482PBurgar Charles G · Belton, TXBuilt 1971 · S/N 24-4994N9482WCantrall Aviation Flying Club LLC · Elizabethtown, KYBuilt 1968 · S/N 28-11218N9482ZChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280455N9483CCnczilla Co · Royersford, PABuilt 1978 · S/N 28-7816482N9483VScholls Arnold W · Syosset, NYBuilt 1970 · S/N 700042N9483WFlying D Aviation Of Kansas LLC · Wichita, KSBuilt 1969 · S/N 28-11221N9484HN9484h LLC · Wheeling, ILBuilt 1975 · S/N 17266175N9484KDoll Electric Co Inc · South Lake Tahoe, CABuilt 1976 · S/N 28-7615206N9484NBourjeili Elias · Glendora, CABuilt 1969 · S/N 28R-35202N9484PDavis Michael E Trustee · Brownsburg, INBuilt 1971 · S/N 24-4997N9484VHannon Fredrick W · Punta Gorda, FLBuilt 1970 · S/N 700064
Back to AD 87-10-06 R1