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.

N6507RJoachim Peter · Grafton, WIBuilt 1974 · S/N MB-724N6507UBovey Dominic C · Sandpoint, IDBuilt 1962 · S/N 2261N6508HBkb Inc · Newport, MIBuilt 1975 · S/N 17265469N6508KTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274205N6508RSterling Creek LLC · Brookings, SDBuilt 1974 · S/N M-1583N6509HSale Reported · Benton, KSSale reportedBuilt 1975 · S/N 17265470N6509JRoot Rickey · Nederland, TXBuilt 1968 · S/N 28-4945N6509RHolzhauer Aviation Corp · Middletown, DEBuilt 1974 · S/N M-1584N650FLHarps Thomas B · Vilonia, ARBuilt 1971 · S/N 28-7125559N650FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843710N650MATerra Flight Aerial Imaging Inc · Spring, TXBuilt 1999 · S/N T20608120N650NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881147N650PA-Z Leasing LLC · Kenosha, WIBuilt 1965 · S/N 27-2793N650PKKarmouche Paul · Penngrove, CABuilt 2009 · S/N 001N650SEStone Archer LLC · Hempstead, TXBuilt 2007 · S/N 2843650N650TThompson Matt · Shawnee, KSBuilt 1958 · S/N TD-125N650VVMindy Limited LLC · Muscatine, IABuilt 1969 · S/N 17258561N650VXOneal Timothy James · Vancouver, WABuilt 1967 · S/N MA-194N65107Renforth Michael E · Yorktown, VABuilt 1982 · S/N 17275686N6510JSabin Michael J · Virginia Beach, VABuilt 1968 · S/N 28-4946N6510LPurpose Flight Inc · Wilmington, DES/N AA5-0610N6510TLenkersdorfer John D · Burley, IDS/N MB-350N6511GBuerk James R · Smethport, PABuilt 1979 · S/N 17273603N6511JCalhoun John R · Baton Rouge, LABuilt 1968 · S/N 28-4948N6511PCaplinger James F · Battle Ground, WABuilt 1959 · S/N 24-1633N6511TAgricola Joseph D · Brooksville, FLBuilt 1968 · S/N MB-354N6511VSc Skywalker Aviation LLC · West Sacramento, CABuilt 1980 · S/N 172RG0741N6511WWinkler Frank · Joplin, MOS/N 28-20589N6512DCajun Wings LLC · Bourg, LABuilt 1979 · S/N 17272836N6512HOrganization Of Black Aerospace Professionals Inc · Olive Branch, MSBuilt 1975 · S/N 17265471N6512JDion Nelson · Cromwell, CTBuilt 1968 · S/N 28-4949N6512KLoomis Aviation LLC · Columbus, OHBuilt 1980 · S/N 17274206N6512UWilliams Larry M · Midland, NCBuilt 1962 · S/N 2266N6512WBirrer Urs P · Huntington Beach, CABuilt 1965 · S/N 28-20590N6513CZorn Tony P · Lyons, GAS/N 43-2653N6513DGhia Flying Venture LLC · Scottsdale, AZBuilt 1979 · S/N 17272837N6513JAlexander Sam L · Fair Play, MOBuilt 1968 · S/N 28-4950N6513TReilly Michael G · Somerset, NJBuilt 1968 · S/N MB-355N6513UKendall Keven S · Logan, UTBuilt 1962 · S/N 2267N6513WBuss Dillon W · Pryor, OKBuilt 1965 · S/N 28-20591N6514JJuggernautaviation LLC · Lewes, DEBuilt 1980 · S/N 17273880N6514RParker Scott L · Galatia, ILBuilt 1974 · S/N MB-711N6514WDickey Jacob L · Sandy, UTBuilt 1964 · S/N 28-20592N6515South Dakota Aviation Hall Of Fame · Spearfish, SDBuilt 1968 · S/N HCB-1N6515UFuller Spencer A · Lake Balboa, CABuilt 1962 · S/N 2298N6515WFrank Eric C · Frankfort, INBuilt 1964 · S/N 28-20593N6516JTeresurv Corp · Port Saint Lucie, FLBuilt 1968 · S/N 28-4953N6516PSchneringer Mitchell G DBA · Fremont, NEBuilt 1959 · S/N 24-1638N6516WWalker Clint H · Tyler, TXBuilt 1965 · S/N 28-20594N65173Boucher John C · Lakeside, AZBuilt 1963 · S/N 24-3492
Back to AD 87-10-06 R1