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.

N74535Rodgers Doyle W · Longview, TXBuilt 1961 · S/N 1846N7453DRomo Blaine Jeffrey · Dillingham, AKS/N 22-5219N7453GNorthwoods Flyer LLC · Jacksonville, FLBuilt 1970 · S/N 17259153N7453YStratus Air Services LLC · Punxsutawney, PABuilt 1964 · S/N 30-516N74541Premier Helicopters LLC · Carson City, NVFirst renewal noticeBuilt 2005 · S/N 3865N74542Bauerle Lucas W · Albuquerque, NMBuilt 1961 · S/N 1853N74543Sky Solutions LLC · Detroit, MIBuilt 2006 · S/N 11214N74545Hopkins Tim W · Cincinnati, OHBuilt 1961 · S/N 1911N74547Travierso Alan S · Farmington, UTBuilt 1961 · S/N 1913N74549Woodyard Tory · Mcloud, OKBuilt 1961 · S/N 1914N7454GDaniel Dewey R · Okeechobee, FLBuilt 1970 · S/N 17259154N7454PCreation Industries LLC · Middlefield, OHBuilt 1961 · S/N 24-2644N7454WPorter Robert D · Manchester, TNBuilt 1963 · S/N 28-1343N7454YOrthner Aviation LLC · Chattanooga, TNBuilt 1964 · S/N 30-517N74553Young John H · Sheridan, WYBuilt 1961 · S/N 1945N74555Pieszala John W · Larksville, PABuilt 1961 · S/N 1947N74556Gutierrez Juan · Sarasota, FLBuilt 1961 · S/N 1948N74557N74557 LLC · Kissimmee, FLBuilt 2005 · S/N 3900N7455DD'Amico Joseph J · Mount Ary, MDBuilt 1957 · S/N 22-5221N7455PEagles Aviation LLC · Rocklin, CABuilt 1961 · S/N 24-2645N7455RMcanelly Anthony J · Maricopa, AZBuilt 1966 · S/N 28-22000N7455SSharp Penny E · Ocala, FLBuilt 1991 · S/N 10043N7455WNicolai Tim A · Brandon, SDBuilt 1963 · S/N 28-1365N7455YTowns Bobby · Nashville, TNBuilt 1964 · S/N 30-518N74560Willett Lynn B · Wooster, OHBuilt 1976 · S/N AA5B-0251N74561George James H · Punta Gorda, FLBuilt 1976 · S/N AA5B-0252N74562Hamm Donald S · Carrollton, TXFirst renewal noticeS/N 1873N74563Black Bird Holdings LLC · Gilbert, AZBuilt 2006 · S/N 11045N74564November Alpha LLC · Dover, DEBuilt 2005 · S/N 3908N74565Shai Evan · Oak Bluffs, MABuilt 1961 · S/N 1876N74566Kerns Stanley M · Berryville, VABuilt 1961 · S/N 1877N74568Willis Charles D · Katy, TXBuilt 1961 · S/N 1879N7456GGregory Larry C Trustee · Farmington, MOS/N 129N7456JSchwier Ronald G Jr · Bloomfield, NJBuilt 1968 · S/N 28R-30954N7456PInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 24-2646N74571Mccurry Richard H · El Dorado, CABuilt 1961 · S/N 1882N74573Strout Adam Geoffrey · Manchester, MABuilt 1961 · S/N 1884N74574Burrell Helicopters LLC · D Hanis, TXBuilt 2005 · S/N 3913N74576Varnes Mark R · Westminster, CAS/N 1887N74579Bethell A Ray · Heavener, OKFirst renewal noticeBuilt 1961 · S/N 1890N7457JMoretti Stephen B · Cranston, RIBuilt 1968 · S/N 28R-30808N7457LPiper Lover LLC · Centennial, COBuilt 1975 · S/N 18-7509051N7457RFoster Adam W · Midland, TXBuilt 1966 · S/N 28-22002N7457WNilsson Tim E · Yreka, CABuilt 1963 · S/N 28-1346N7457YPeter Prince Aviation Center LLC · Milton, FLBuilt 1964 · S/N 30-520N74581Lane Tyler R · Berthoud, COS/N 1892N74582Moo Nee LLC · Vero Beach, FLBuilt 1962 · S/N 1893N74583Mile High Carpet Rides LLC · Dover, DEBuilt 2005 · S/N 3923N74586Rainwater Farms LLC · Dover, DES/N 1897N74587Curtis David W · Watertown, NYBuilt 1961 · S/N 1898
Back to AD 87-10-06 R1