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.

N64YBRegistration Pending · Wasilla, AKRegistration pendingS/N 30-331N64YUCane Creek Aviation LLC · Asheville, NCBuilt 2004 · S/N 25997N65001Dornak Henry E Jr · Corpus Christi, TXBuilt 1982 · S/N 17275665N65003Major Air LLC · Charleston, SCBuilt 1982 · S/N 17275666N6500DAztec Adventures LLC · Cape Coral, FLBuilt 1960 · S/N 27-181N6500ERegistered aircraftBuilt 2005 · S/N 10246N6500JHorizon Aviation LLC · Brooks, GABuilt 1968 · S/N 28-4933N6500PDennison Ronald Walton Trustee · San Jose, CABuilt 1959 · S/N 24-1621N6500UWhitson Mark A · Houston, TXBuilt 1962 · S/N 2253N6501Ramirez Ricardo M · Camano Island, WAS/N 100-2N6501CGcbc LLC · Norman, OKBuilt 1978 · S/N 28-7816428N6501JAndersen Aviation LLC · Leavenworth, WAS/N 28-4934N6501PGarcia Perez Alberto Carlos · Houston, TXBuilt 1964 · S/N 27-2489N6501RAbove Earth Aerospace LLC · Friendswood, TXBuilt 1974 · S/N M-1537N6501WStewarts Aircraft Service Inc · Waynesville, OHBuilt 1964 · S/N 28-20578N6502Keen Brandon M · Brunswick, MEBuilt 1962 · S/N 28-566N65021Borda Anthony J · West Chester, PABuilt 1982 · S/N 17275670N6502JGanuza Diego J · Okeechobee, FLBuilt 1968 · S/N 28-5114N6502PMelvin Kelly G · Green River, WYBuilt 1959 · S/N 24-1623N6502RSmith Duane · Felt, OKBuilt 1974 · S/N MC-259N6502WMid American Pilot Association Inc · Lawrenceville, ILBuilt 1965 · S/N 28-20579N6503BSmith Gregory E · Manila, ARFirst renewal noticeBuilt 1957 · S/N 1170N6503DManubay John M · Sinking Spring, PABuilt 1979 · S/N 17272834N6503JTischler Keith Louris · Round Rock, TXBuilt 1968 · S/N 28-4938N6503UMooney 6503u LLC · Naples, FLBuilt 1962 · S/N 2257N6503VSt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 172RG0736N6503YShe-Rat Aviation Inc · Wilmington, DEBuilt 1967 · S/N 27-3791N65045Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1982 · S/N 17275674N65048Bartlett Robert E · Cleveland, TXBuilt 1964 · S/N 1722N6504CBraddy James R Jr · Sunnyvale, TXBuilt 1978 · S/N 28-7890377N6504RJohn M Peters · Damascus, MDBuilt 1974 · S/N MB-716N6504SNurmi Forrest Cal · Burlington, WABuilt 1980 · S/N R18201687N6504VYoung Charles Wade · Rogers, ARBuilt 1980 · S/N 172RG0737N6504YLiebig Bryan H · Sacramento, CABuilt 1967 · S/N 27-3792N65057Good Winds LLC · Waterville, MEBuilt 1982 · S/N 17275677N65058Organization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1982 · S/N 17275678N6505JWedel Dan P · Fairmont, MNBuilt 1968 · S/N 28-4941N6505PCaduda & Faulk Aero Ltd · Nederland, COBuilt 1959 · S/N 24-1626N6505UBell Keith O · Navarre, FLBuilt 1962 · S/N 2259N6505WOndracek Jack E · Port Orchard, WABuilt 1964 · S/N 28-20582N65061Tennis Gayland L · Bath, MIBuilt 1977 · S/N 2029N65065Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275681N6506AFallon Timothy R · Ithaca, NYBuilt 2005 · S/N 10247N6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTBuilt 1979 · S/N 17272835N6506ULambert Isabelle O · El Paso, TXBuilt 1962 · S/N 2260N6506WRoehrig Michael A · Fairport, NYBuilt 1965 · S/N 28-20583N65072Jezebel Doghouse LLC · Kalispell, MTBuilt 1980 · S/N 2037N6507CBollum Justin Keith · Chevy Chase, MDS/N 28-7816533N6507FToledo Thiago Amaral · Bonita Springs, FLBuilt 1976 · S/N 32R-7780028N6507JBarnes Brandon M · Metamora, ILS/N 28R-7635331
Back to AD 87-10-06 R1