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.

N6940NPelissier Joseph E Trustee · Cary, NCBuilt 1968 · S/N 680151N6940UNewby Adam M · Anchor Point, AKS/N 310N69419Ninke Justin E · Fond Du Lac, WIBuilt 2001 · S/N 1240N6941DKodysh Peter J · North Ridgeville, OHBuilt 1957 · S/N 22-4869N6941JPalmenteri Louis J · Rhome, TXS/N 28-7615405N6941NCaro Carlos H · Mcallen, TXS/N 680191N6941UBukac Glenn P · Villa Park, ILBuilt 1964 · S/N 311N6942Schwartz Kenneth G · Lincoln, CAS/N JII-76004RN6942JAndromeda Air LLC · Houston, TXBuilt 1976 · S/N 28-7690434N6942KGold Cap LLC · Bremerton, WABuilt 1953 · S/N 18-2471N6942WBobbe Debra M · Paradise Valley, AZBuilt 1965 · S/N 28-21122N6942YVan Fossen Eddie L · Bakersfield, CABuilt 1994 · S/N 1809107N6943AOber John A · Candor, NYBuilt 1979 · S/N 27-7954117N6943BAndrews Joshua T · Lakeview, ORBuilt 1956 · S/N 22-4223N6943NPhoenix Aviation Holdings LLC · Mesa, AZBuilt 1968 · S/N 680192N6943YAce Tomato Co LLC · Daytona Beach, FLBuilt 1969 · S/N 27-4350N6944APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954109N6944CUpdraft Leasing LLC · Tea, SDBuilt 1978 · S/N 28-7816442N6944EHinds Archie L · Claremore, OKBuilt 1978 · S/N 17272076N6944JJhap LLC · Hubbard, OHBuilt 1976 · S/N 28R-7635364N6944NYates Gary Douglas · Rose Hill, KSS/N 680153N6944WWerner Robert T · Blue Grass, IABuilt 2016 · S/N 1550N6944YLg Aztec LLC · Boynton Beach, FLBuilt 1969 · S/N 27-4304N6945JK&B Properties LLC · Lexington, SCBuilt 1976 · S/N 32R-7680391N6945NEveland Benjamin E · Henderson, NVBuilt 1968 · S/N 680193N6945PBerg Alvin L · Overgaard, AZBuilt 1960 · S/N 24-2080N6945QEllis Jordan Barrett · Oklahoma City, OKBuilt 1968 · S/N MA-295N6945UGipe Douglas A · Malvern, IABuilt 1964 · S/N 315N6946CRegistration Pending · Fairbanks, AKRegistration pending, canceledBuilt 1953 · S/N 25522N6946QBlalock James M · Sheridan, ARBuilt 1968 · S/N MA-296N6947BB&R Aerial Crop Care Inc · Connell, WABuilt 1957 · S/N 22-4227N6947NFlyfaraway Partners LLC · Sparta, NJBuilt 1968 · S/N 680194N6947PHudzinski Joel David · Newaygo, MIBuilt 1960 · S/N 24-2082N6947VGutierrez Juan · Sarasota, FLBuilt 1976 · S/N 22-1320N6948NPeck Jeff · Denton, TXS/N 680195N6948PBernard David J · Paris, OHS/N 24-2083N6948WCraig Joshua G · Bonaire, GABuilt 1965 · S/N 28-21134N6949BPool Gene E · Anchorage, AKBuilt 1956 · S/N 22-4229N6949NBanos Peter T · Coalinga, CABuilt 1968 · S/N 680155N6949PDepew Kevin I · Everett, WABuilt 1960 · S/N 24-2084N6949ULambert Donald H · Westwood, MABuilt 1964 · S/N 319N6949VPaul Kevin A · Belgrade, MTS/N 22-1322N6949WSa Fliers LLC · Venice, FLBuilt 1965 · S/N 28-21138N6949ZTide Water Soaring Society Inc · Windsor, VABuilt 1964 · S/N 25-2696N694ABGoldpick Dirtworx LLC · Wasilla, AKBuilt 1957 · S/N 22-5347N694APCook Christopher W · Indian Mound, TNS/N 24-1147N694ARWilliams Robert R · Vernonia, ORBuilt 1947 · S/N 12-1507N694BASlawko Paul A · Elverson, PABuilt 1990 · S/N 694USN694BKBell Bruce · Desert Aire, WABuilt 1969 · S/N 1851582N694BWOtter Creek Aviation LLC · Columbus, GABuilt 2004 · S/N T18208262
Back to AD 87-10-06 R1