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.

N83775Mattson Greg L · Alta, IABuilt 1981 · S/N 28-8190220N8377FScott Shawn D · Darrington, WAS/N 480680N8377GKristoferson J S Md Custodian · Denton, TXBuilt 1981 · S/N 32R-8113064N8377PGullett Samuel H · Lafayette, LABuilt 1964 · S/N 24-3636N8377RPerry Eden · Morgan Hill, CABuilt 1966 · S/N 28-22254N8377WRosenberg Adam N · Scottsdale, AZBuilt 1965 · S/N 28-2578N83786Riggin Flight Service Inc · Madison, SDBuilt 1966 · S/N 1217N8378ASoutheast Wings Ltd · Winston, GABuilt 1981 · S/N 28-8116206N8378CCuller Hall Aeronautics LLC · Morrow, OHBuilt 1976 · S/N 28-7615097N8378HDiversified Aeronautical Svcs · Lake Ronkonkoma, NYBuilt 1981 · S/N 28-8116208N8378LLett Brian R · Eden Prairie, MNBuilt 1968 · S/N 17256578N8378PBel-Aire Home Restoration LLC · Platteville, WIBuilt 1964 · S/N 24-3637N8378RNachbar Scott G · Springville, NYBuilt 1966 · S/N 28-22255N8378YEmerald Aircraft LLC · Greenwood, SCBuilt 1967 · S/N 30-1533N8379LSan Fernando Aviation LLC · Van Nuys, CAS/N 17256579N8379WChilds Electric Inc · Dawson, GABuilt 1965 · S/N 28-2580N8379YSpaeth Alexander H · Aurora, ILBuilt 1967 · S/N 30-1534N8379ZHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1985 · S/N 0491N837DSLyons Brent · Saint Cloud, FLBuilt 2004 · S/N 40.437N837ELHewitt Vehicles LLC · Oakford, INBuilt 2026 · S/N 42036N837HBKellum Mark · Belden, MSBuilt 1978 · S/N 27-7954021N837KRouth Gary Lee · Lebanon, TNS/N 98N837KTBeechsun LLC · South Jordan, UTS/N M-2076N837PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843940N837PGG & G Comanche LLC · Magnolia Springs, ALBuilt 1965 · S/N 30-914N837PPIaba LLC · Norfolk, VABuilt 2023 · S/N 70237N837SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881716N83808Jcl Aviation Inc · Palm Harbor, FLBuilt 1981 · S/N 32R-8129065N8380CPittsburgh Pilot Training LLC · Bethel Park, PABuilt 1976 · S/N 28-7690127N8380JMoritz Wagner P · Rochester, NYBuilt 2011 · S/N 91502N8380LTroser Management Inc · Canandiaigua, NYBuilt 1981 · S/N 28-8190222N8380PGoins Eric M · Goldsboro, NCBuilt 1981 · S/N 28-8190223N8380UTrp Enterprises Inc · Mocksville, NCBuilt 1965 · S/N 17252280N8380VMaxwell Frank R · Fairbanks, AKBuilt 1966 · S/N 70N8380WForbes Aviation LLC · Boise, IDS/N 28-2582N83814Wachter Bruce · Maryville, TNBuilt 1981 · S/N 28-8116218N8381CIsley Gaylon B · Cedar Falls, IABuilt 1976 · S/N 28-7690128N8381LShielded Holdings LLC - Series Av 12 · Katy, TXBuilt 1968 · S/N 17256581N8381PIndy Air Sales LLC · Anderson, INS/N 24-3640N8381VAurora Direct LLC · West Linn, ORBuilt 1981 · S/N 32-8124025N8381YLehrer James Rodd · Thief River Falls, MNBuilt 1967 · S/N 30-1536N8382AAtd Pilot Training LLC · Kansas City, MOBuilt 1981 · S/N 28-8190228N8382CSwickert Donald L II · Merritt Island, FLBuilt 1976 · S/N 28R-7635154N8382EEastern Stearman Inc Trustee · Leesburg, VABuilt 1960 · S/N 1560N8382LMedina Solla Edwin O · Trujillo Alto, PRBuilt 1968 · S/N 17256582N8382PKutilek Emil J · Charlottesville, VABuilt 1964 · S/N 24-3641N8382WTrans Western Air Inc · Cullowhee, NCBuilt 1965 · S/N 28-2584N8382ZMueller Charles G · Naples, FLBuilt 1981 · S/N 28-8111064N83831Connelly Christopher J · Lewiston, NYBuilt 1981 · S/N 28-8190233N83833Campbell Anna Lu · Sheridan, ILS/N 28-8190234
Back to AD 87-10-06 R1