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.

N838SShaw James J · Loranger, LAS/N 18-8203N838SPEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 172S8736N838TStandard Jacob R · Lakeway, TXBuilt 1965 · S/N TD-611N8390CArserio Gregory J · Fairport, NYBuilt 1976 · S/N 28-7690130N8390JPayne William A · Evansville, INS/N 32-8106083N8390LBliss Marketing Communications Inc · Phoenix, AZBuilt 1968 · S/N 17256590N8390PNordwick Thomas J · Uvalde, TXS/N 24-3649N8390WLong Joseph · Mint Hill, NCBuilt 1965 · S/N 28-2595N83914Upstate Aviators LLC · Spartanburg, SCBuilt 1981 · S/N 28-8290036N8391MConner Jason M · Moses Lake, WABuilt 1991 · S/N 118N8391PClare Enterprises LLC · Edina, MNBuilt 1964 · S/N 24-3650N8391QGambel E Anthony · Sewanee, TNBuilt 1981 · S/N 28-8116233N8391SVip Medical Services LLC · Nixa, MOBuilt 1981 · S/N 28-8116234N8391VRoflyco Ltd · Glendale, AZBuilt 1966 · S/N 107N8391WNavara Cole J · Ulster Park, NYS/N 28-2596N8391YSchafer Gary L · Greenwood, DEBuilt 1981 · S/N 28-8116235N83922Archipelago Immobilien LLC · Jacksonville Beach, FLBuilt 1981 · S/N 32-8106069N83924Moseley Barton S · Tomball, TXBuilt 1981 · S/N 32R-8113070N8392PVaughn Charles P · Inverness, FLBuilt 1964 · S/N 24-3652N8392YTwinco Flyers LLC · Powell, OHBuilt 1967 · S/N 30-1547N8393AMyhre Real Estate Management Inc · Rochester, NHBuilt 1981 · S/N 32R-8113071N8393CAndersen Robin L · Cloverdale, CABuilt 1976 · S/N 28-7690131N8393GRegistered aircraftBuilt 1981 · S/N 32R-8113072N8393LJohns Ryan · Sabillasville, MDBuilt 1968 · S/N 17256593N8393PMorrison Brian W · Zanesville, OHBuilt 1964 · S/N 24-3653N8393RFisher B Barton · Bowman, NDBuilt 1966 · S/N 28-22270N8393XAeroforge LLC · Crystal Lake, ILBuilt 1981 · S/N 32R-8129074N83947Iziair LLC · Mclean, VAFirst renewal noticeBuilt 1981 · S/N 28-8190247N8394CThree Rivers Aero LLC · Three Rivers, MIBuilt 1976 · S/N 28-7690132N8394DPray Aviation Inc · Augusta, KSBuilt 1981 · S/N 28-8116238N8394PHilton Keith A · Galesville, WIBuilt 1964 · S/N 24-3654N8394WLockhart Flying Club · Lockhart, TXBuilt 1965 · S/N 28-2602N8394YGadamic LLC · Fresno, CABuilt 1981 · S/N 28-8190246N8395APrecision Drilling Services LLC · Honolulu, HIBuilt 1981 · S/N 28-8190248N8395CN8395c LLC · Peachtree City, GABuilt 1976 · S/N 28-7690133N8395HApple X05 LLC · Spring Hill, FLBuilt 1981 · S/N 28-8190249N8395RRegistration Pending · Dover, DERegistration pendingBuilt 1966 · S/N 28-22272N8395SWall Gerardo · Seminole, TXS/N 28-8111075N83960Paris Air Inc · Vero Beach, FLBuilt 1981 · S/N 28-8116244N8396EFors Warren Hal · Salt Lake City, UTS/N 1616N8396JCurtsinger Joseph C Jr · Nolensville, TNBuilt 1981 · S/N 32R-8129075N8396LEmerald Coast Aircraft LLC · Panama City Beach, FLBuilt 1981 · S/N 28-8190288N8396RPatton Graham S · Chattanooga, TNBuilt 1966 · S/N 28-22273N8396WCarpenter Kenneth G · Dripping Springs, TXS/N 28-2606N8396YPerkins Christopher R · Brackettville, TXBuilt 1967 · S/N 30-1492N8396ZSaflite Pilot Training Inc · Hooksett, NHS/N 28-8116243N83974Otoole Airways LLC · Great Neck, NYBuilt 1981 · S/N 28-8190254N8397CParker Edward M Jr DBA · Griffin, GABuilt 1976 · S/N 28R-7635156N8397LWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 28-8190252N8397RMiller Dean R · Edmond, OKBuilt 1966 · S/N 28-22274
Back to AD 87-10-06 R1