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.

N6915VReindollar William Paul Jr · Derwood, MDBuilt 1975 · S/N 22-1295N6915WOso Air LLC · Missoula, MTBuilt 1965 · S/N 28-21086N69165Locaero Services Inc Trustee · Wilmington, DEBuilt 1985 · S/N 28-8516060N6916HFms Air LLC · Leesville, LABuilt 1975 · S/N 17265641N6916KBrown Daniel A · Gettysburg, PABuilt 1950 · S/N 20-18N6916NGray Wesley K · Sandia, TXBuilt 1968 · S/N 680140N6916QShawn James R · Pattison, TXS/N MB-287N6916YDk1 Aviation LLC · Fayetteville, NCBuilt 1969 · S/N 27-4272N6917APiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 27-7954111N6917DOlds Forge Flyers Inc · Lansing, MIBuilt 1985 · S/N 28-8590061N6917GMarvell Aviation LLC · Marvell, ARBuilt 1985 · S/N 28-8590062N6917NBonak Steven · Punta Gorda, FLBuilt 1968 · S/N 680178N6917VCamper Daniel P II · Port Angeles, WABuilt 1975 · S/N 22-1297N6917WCloutier Michael C · Waddell, AZBuilt 1965 · S/N 28-21088N6918DTucker Christopher W · Johnstown, COBuilt 1962 · S/N 23-2038N6918HWright Flight Inc · Tucson, AZBuilt 1975 · S/N 17265642N6918NBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 680141N6918WTopping Warren J · Sagaponack, NYBuilt 1965 · S/N 28-21089N6919BPolyclinics.Net LLC · Hixson, TNS/N 22-4194N6919HTimmester Terry W · Little River, SCBuilt 1975 · S/N 17265643N6919JFlying Is Fun LLC · Atlanta, GABuilt 1976 · S/N 28-7615397N6919MWest Byron Chad · Blue Grass, IABuilt 1985 · S/N 28-8511013N6919NNicholas Dagmar H · Uniontown, OHBuilt 1968 · S/N 680179N6919PMunroe Consulting · Ocala, FLBuilt 1962 · S/N 24-3143N6919VKimzey Robert R · Cypress, TXBuilt 1975 · S/N 22-1299N6919WN6919w LLC · Key West, FLBuilt 1965 · S/N 28-21090N691BARotor Ops 269 LLC · Wilmington, DEBuilt 2006 · S/N 11168N691BEWester Joshua · Emmett, IDS/N 1309N691DLJohnson Boyd D · Preston, IDBuilt 1992 · S/N 20192N691DSNelson Travis K · Hamilton, MTS/N 20199N691FLKelley Keith B · Forney, TXS/N 28-7125628N691KWHoegg Thomas K · Mountain Home, IDS/N 20985N691LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881197N691MAMitchell Martin · Alpine, CABuilt 2002 · S/N 3257291N691RPRegistration Pending · Mount Holly, VTRegistration pending, canceledBuilt 1969 · S/N 28R-35019N691SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLS/N 1552N691SPGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1999 · S/N 172S8100N691TCSpartan National Holdings LLC · Missoula, MTBuilt 1999 · S/N 172S8225N691WEagle Simulator LLC · Lake Oswego, ORBuilt 1982 · S/N 17275576N6920CKiesel James L · Hanford, CABuilt 1969 · S/N 690065N6920GValley Boys LLC · Lakeville, MNBuilt 1985 · S/N 28-8590065N6920NHodgman Gary W · Greenville, TXBuilt 1968 · S/N 680142N6920PStanley Travis Navar · Dundee, OHBuilt 1960 · S/N 24-2054N6920QNeff Marcus J · Tigard, ORBuilt 1967 · S/N MA-273N6920VPjs Enterprises · Havre, MTBuilt 1975 · S/N 22-1300N69211Nelson John · Lusby, MDBuilt 2012 · S/N 81632N6921BKnepp Gerald L · Milroy, INBuilt 1956 · S/N 22-4197N6921NBower Edwin M · Norco, CABuilt 1968 · S/N 680180N6921PNormark Ronald L · Weirsdale, FLBuilt 1960 · S/N 24-2055N6921VLebow Kirk · Clovis, NMBuilt 1975 · S/N 22-1301
Back to AD 87-10-06 R1