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.

N6486JSpredemann Carl A · Emmett, IDBuilt 1980 · S/N 17273877N6486PBerg Alvin L · Overgaard, AZBuilt 1959 · S/N 24-1604N6486QHilhorst Kenneth E · Rocky Mount, NCBuilt 1967 · S/N 680028N6486UDof Aviation Inc · Schertz, TXBuilt 1962 · S/N 2233N6486WSommerfeld Jordan Maxwell · Kittanning, PABuilt 1964 · S/N 28-20561N6486ZSouthern Eagles Soaring Inc · Butler, GABuilt 1962 · S/N 25-2005N64875Air America Flight Center LLC · Daytona Beach, FLBuilt 1982 · S/N 17275642N6487DWayne County Airport Board · Monticello, KYBuilt 1979 · S/N 17272831N6487QGordon Jeff · Cleveland, OHFirst renewal noticeBuilt 1967 · S/N 680029N6487RNurney Steven P · Fountain Hills, AZBuilt 1966 · S/N 28-21678N6487UScheifele Gay F · Derwood, MDBuilt 1962 · S/N 2234N64882Blue Sky Flyers Inc · Greeley, COBuilt 1982 · S/N 17275643N6488JWccrt LLC · Enterprise, KSS/N 28-4918N6488PSooner Answer Service Inc · Edmond, OKS/N 24-1607N6488QClark Thomas L · Kingman, AZBuilt 1967 · S/N 680030N6488R6 Aerospace LLC · Albuquerque, NMS/N 28-21679N6488UWings Leman F · Richmond, CAS/N 2235N6488WKendall Ralph L Jr · Cape Coral, FLBuilt 1965 · S/N 28-20563N64892Montgomery Flying Club Inc · Montgomery, ALBuilt 1982 · S/N 17275644N6489JPatten Jeffery D · Rapid City, SDBuilt 1968 · S/N 28-4920N6489QMccurry Aviation Company LLC · Weatherford, TXBuilt 1967 · S/N 680031N648FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843708N648NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881164N648RHill Martin J III · Yorktown, VABuilt 1992 · S/N 20823N648SAFour Delta Tango LLC · Wilmington, DEBuilt 2005 · S/N S-0010N648SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1998 · S/N 172S8055N648TStefaniak Paul B · Richmond, TXBuilt 1995 · S/N 4636002N648VKuitems Philip P · Mt Juliet, TNBuilt 1960 · S/N TD-340N648WBHunt Billy Dean · Rowland, NCS/N 22021CN6490DCampbell James W · Joshua, TXBuilt 1979 · S/N 17272832N6490QSuchting Carl J · Little Egg Harbor, NJS/N 680032N6490RDunn Christopher E · Amana, IAS/N 28-21681N64915Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275649N64918Loeser Harold · Boca Raton, FLBuilt 1982 · S/N 17275651N64919Hawk III Flyers Club · Republic, PABuilt 1973 · S/N 17262850N6491JEleven X Club Inc · Jeffersonville, INBuilt 1968 · S/N 28-4922N6491RGonzales Christian J · Dallas, TXBuilt 1966 · S/N 28-21683N6491UAllen Todd C · Abingdon, VABuilt 1962 · S/N 2238N6491WHuddleston Ronnie L · North Vernon, INBuilt 1965 · S/N 28-20567N6492ELeadmon Lorren Dale Jr · Mechanicsville, MDBuilt 1978 · S/N 17272024N6492GState Of North Carolina · Raleigh, NCBuilt 2004 · S/N 18281411N6492RFagerhaug Jeffrey · Orangevale, CABuilt 1966 · S/N 28-21684N6493JReischmann Jonathan · Palm Bay, FLS/N 28-4924N6493RReifschneider Jay S · Patterson, CABuilt 1966 · S/N 28-21685N64943Tipton Donald Jeffrey Sr · Maryville, TNBuilt 1982 · S/N 17275657N6494JKennedy Quincy A IV · Florence, SCBuilt 1968 · S/N 28-4925N6494PPiehl Deborah C · Saint Petersburg, FLS/N 24-1614N6494RTurner Manley W Jr · Fredericksburg, VABuilt 1966 · S/N 28-21686N6494ZSoaring Club Of Houston · Waller, TXBuilt 1962 · S/N 25-2015N6495JStp Flight LLC · Saint Paul, MNBuilt 1968 · S/N 28-4926
Back to AD 87-10-06 R1