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.

N80472Simons George Trustee · Bouse, AZBuilt 1976 · S/N 17266606N80475Texas Southern University · Houston, TXS/N 17266608N80476Sky Roamers LLC · Columbus, NEBuilt 1976 · S/N 17266609N8047DMurphy Robert · Kent, WABuilt 1957 · S/N 22-5572N8047LHolmes Frank L · Enterprise, ALBuilt 1967 · S/N 47-0699N8047SRisso Christopher W · Huntington Beach, CABuilt 1981 · S/N 32R-8229025N8047WFlying Fossil LLC · Franklin, TNBuilt 1965 · S/N 28-2119N80483Harrell Matthew J · Grand Haven, MIBuilt 1976 · S/N 17266611N80484Mor Aviation 172m LLC · Gaithersburg, MDBuilt 1976 · S/N 17266612N80486Romoser Carey E · Simpsonville, SCBuilt 1976 · S/N 17266613N80487Williams Fredrick Glen · Auburn, ALS/N 17266614N80489P & K Aviation LLC · Neshkoro, WIBuilt 1976 · S/N 17266615N8048CDegraff Claude Md · Fort Myers, FLBuilt 1975 · S/N 28-7625093N8048DBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1954 · S/N 54-2592N8048PCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1962 · S/N 24-3293N80490American Patrols Inc · Midland, TXS/N 17266616N80491Duffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1976 · S/N 17266617N80495Space Coast Aero LLC · Melbourne, FLBuilt 1976 · S/N 17266619N80496Bickel Gregory A · Mckinleyville, CABuilt 1976 · S/N 17266620N80497Ducksrus LLC · Indianapolis, INBuilt 1976 · S/N 17266621N8049DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-5573N8049NKolbjornsen Arne · Middletown, DES/N 28-25295N8049PFranklin Ricky L · Glade Hill, VAS/N 56-0535N8049WTennis Gayland L · Bath, MIBuilt 1965 · S/N 75-0349N804ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496333N804BD G Leasing LLC · Houston, TXBuilt 1976 · S/N 17266584N804BLFlores Omar Javier · New Braunfels, TXBuilt 1979 · S/N 17273041N804ERDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N 40.311N804GASaber Safa · Newburyport, MABuilt 1977 · S/N AA5A-0460N804JSButler Jack L · Bennington, OKBuilt 2004 · S/N 491-2004N804LGDem Ventures LLC · Wichita, KSBuilt 1976 · S/N 61P-0298-075N804NVMoody Bible Institute Of Chicago · Spokane, WABuilt 2001 · S/N 1065N804QMay Richard U · Soquel, CABuilt 1996 · S/N 25N804SMVogt Gregory A · Broken Arrow, OKBuilt 1975 · S/N 158-75N804VGLewis David S · Port Saint Lucie, FLBuilt 1956 · S/N 23-483N80507High Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266626N8050DSalerno Joseph C Jr · Gettysburg, PAFirst renewal noticeBuilt 1957 · S/N 22-5574N8050EPerun Av LLC · Cliffside Park, NJBuilt 1978 · S/N 17272122N8050JParamus Flying Club Inc · Fairfield, NJBuilt 2005 · S/N 18281633N8050YGmm Records · Big Pine Key, FLBuilt 1962 · S/N 27-2098N80511American Patrols Inc · Midland, TXBuilt 1976 · S/N 17266629N80517Powers Tia Nichole · Griffin, GABuilt 1976 · S/N 17266633N80519Donald Ben B II · Carthage, TXBuilt 1976 · S/N 17266634N8051BBryant James T Jr · Pryor, OKBuilt 1980 · S/N R18201574N8051NSapienza Gregory T · Williamstown, NJBuilt 1969 · S/N 28-25298N8051PReeder Blake · Amarillo, TXS/N 24-3297N8051VAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2021 · S/N 2881106N8051WMcginn Gary P · Elk City, OKBuilt 1965 · S/N 28-2124N80522Mikhael Hanna M · Livonia, MIBuilt 1976 · S/N 17266636N80525Dunkin Aviation LLC · Hensley, ARBuilt 1976 · S/N 17266637
Back to AD 87-10-06 R1