OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N2901ZSmith Roger L · Los Alamos, NMBuilt 1959 · S/N 22-6873N29021Kough Brian R · Plant City, FLBuilt 1979 · S/N 28R-7918133N29028Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1974 · S/N 17264095N2902BSky Angel LLC · Sikeston, MOBuilt 1979 · S/N 28-7990538N2902LIvey Steven L · Graniteville, SCBuilt 1967 · S/N 670065N2902PHentgen Chip · Peru, INBuilt 1955 · S/N 22-3168N2903DBecker Paul J · Spring Hill, FLBuilt 1979 · S/N 28-7990542N2903LSchillinger Bradley Charles · Honeoye Falls, NYBuilt 1967 · S/N 670066N2903XBrowning Mcpherson Aviation LLC · Auburn, KYBuilt 1967 · S/N 17700303N29047State College Pilots Club · Philipsburg, PABuilt 1974 · S/N 17264096N29049Weiman Magnus · Lynchburg, VABuilt 1979 · S/N 28-7990429N2904MLange Keith J · Wasilla, AKBuilt 1946 · S/N 12-1318N2904PRandall Airlines LLC · Wendell, NCBuilt 1965 · S/N 24-4191N29056Land Of Lakes Aviation LLC · Eagle River, WIBuilt 1974 · S/N 17264097N2905BHawley Timothy J · Ashland, OHBuilt 1979 · S/N 32-7940194N2905ECappadona Roy · Iliamna, AKBuilt 1978 · S/N 17271369N2905LSteel Alan P · Odessa, TXBuilt 1967 · S/N 670299N2905PSimpson Danny R · Waunakee, WIBuilt 1955 · S/N 22-3172N2905XRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 17700305N2905ZWmh Aviation LLC · Buckley, WABuilt 1978 · S/N 358-78N29062Jackson Stephen D · Pennsboro, WVBuilt 1979 · S/N 28-8011054N2906LHogue Aviation LLC · Dover, PABuilt 1967 · S/N 670300N2906MFry Steven G · Eagle River, AKBuilt 1946 · S/N 12-1321N2907Cizek Joseph E · Wasilla, AKBuilt 2017 · S/N 2016N29070Buzick Carey B · Fargo, NDBuilt 1978 · S/N R18200639N29076Flight Dynamics LLC · De Leon Springs, FLBuilt 1987 · S/N 1022N2907PWickenheiser John D · Newport, MIBuilt 1955 · S/N 22-3175N2907RFricks Cline Thomas Jr · Toccoa, GABuilt 1969 · S/N 28R-35324N2907ZCabana Robert D · Cocoa, FLBuilt 1978 · S/N 377-78N2908GGraves Sam · Tarkio, MOBuilt 1959 · S/N 263N2908LGurney Stephen E · Niceville, FLBuilt 1967 · S/N 670302N2908PHull Mahlon B · Sedro Woolley, WABuilt 1955 · S/N 22-3176N2908UBarrett H Gould · Myrtle Beach, SCS/N 1023N2908YAnco Air Inc · Weston, FLS/N 32R-8129100N29098Gill Stuart W Jr · Kingsport, TNBuilt 1979 · S/N 28-7990436N2909BIsland Hoppers Inc · Glenridge, NJBuilt 1979 · S/N 32-7940196N2909DPainter Kelly A · Cantwell, AKBuilt 1955 · S/N 26852N2909QHelman Tom · Evanston, WYBuilt 1979 · S/N 28-7916533N290AMWheaton Megan E · Orchard Park, NYS/N 2096N290DSNakel Inc · Elkton, SDBuilt 2003 · S/N 40.290N290DYZumm Thomas Lawrence · Wheaton, ILBuilt 2002 · S/N 2108N290HLynco Air LLC · Venice, FLS/N 27-0290N290HADon'T Call Me Shirley LLC · Fort Myers, FLBuilt 1966 · S/N 28-3624N290KCTsunami Skydivers Inc · Las Vegas, NVBuilt 1990 · S/N 1301N290KZRowland Glen J · Monrovia, INBuilt 2024 · S/N 1220233N290MSurging Skyward Inc · Newtown, PAS/N 27-7554111N290MGGeorgia Aviation Authority · Eastman, GABuilt 2014 · S/N 2843761N290NDChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 4496021N290UOhio University · Albany, OHBuilt 2000 · S/N 172S8551N290VGAlmy David W · Riverside, CAS/N 23-5
Back to AD 87-10-06 R1