OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,003

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.

N1202JAldrich Curtiss · Aguila, AZBuilt 1974 · S/N 202N1202LDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 707N1202YBergstedt Jon P · Anchorage, AKBuilt 2024 · S/N 2N12033Echeverri Otto · Gilbert, AZFirst renewal noticeBuilt 1995 · S/N 1N12038Dyer Dion G · Dallas, TXS/N 982N1203FRawson Aviation LLC · Collinsville, OKBuilt 1979 · S/N 17272968N1203LHolt Arlin J · Waterford, MEBuilt 1975 · S/N 708N1203TProfessional Locators & Acquisition Specialists Ll · Severance, COBuilt 1972 · S/N 28-7225420N1203XMcelwain Russell D · Lancaster, KSBuilt 1963 · S/N 2606N12045Robinson Claudius E · Woodway, TXBuilt 2019 · S/N 21256N1204CCarvilles Auto Mart · Grand Junction, COBuilt 2001 · S/N T18208026N1204JLucas Rici · Columbus, GABuilt 1974 · S/N 204N1204LDiehl Matthew J · Kingston, WAS/N 709N1204PDoyle Connor G · North Adams, MABuilt 1955 · S/N 23-220N1204THigh Sky LLC · Ellensburg, WABuilt 1972 · S/N 28-7225421N1204XMcdonald Monroe · Aguila, AZBuilt 1963 · S/N 2607N1205TAmerican Aircraft Management LLC · Irving, TXBuilt 1972 · S/N 28-7225422N1205UBordeaux Marvin · Willcox, AZBuilt 1976 · S/N 17266904N1205XOsborn Aviation LLC · Claude, TXBuilt 1963 · S/N 183N12066Grey Kenneth P · Snowflake, AZS/N 2066N1206APelham Aircraft LLC · Dallas, TXBuilt 1966 · S/N 301206N1206EStrassburg Wayne W · Galena, AKFirst renewal noticeS/N 990-77N1206TCps 1 LLC · Pelham, ALBuilt 1972 · S/N 28-7205266N1206XNlw 1 LLC · Washington, UTS/N 184N1207PN73481 LLC · Ault, COBuilt 1955 · S/N 23-223N1207UKasakoff Lloyd · Diamond Bar, CAS/N 17266906N1207XPbc LLC · Missoula, MTS/N 001N1208MMitchell John V · Tega Cay, SCBuilt 2000 · S/N 3RX040N1208XCartaya Lazaro C · Miami, FLBuilt 1963 · S/N 2611N12090Diaz Aviation LLC · Mount Upton, NYBuilt 1973 · S/N 17261800N12091K D Farms Inc · Cosmos, MNBuilt 1973 · S/N 17261801N12095Ciddio Mark S · Sebastopol, CABuilt 1975 · S/N 17702385N12097Aerolease Aviation Rental LLC · Cartersville, GABuilt 1973 · S/N 17261807N12098Traywick James D · Cope, SCBuilt 1973 · S/N 17261808N1209LHarrist Robert K · Fort Worth, TXBuilt 1975 · S/N 714N120AFAir First LLC · Kalispell, MTBuilt 1994 · S/N 2055N120AGHallmark Ronald D · Spring Hill, TNBuilt 1979 · S/N 7295CN120BSShain Bill R · Coal City, ILBuilt 2003 · S/N 004N120CDJackson Farms Callahan Division LLC · Callahan, FLBuilt 1974 · S/N 28R-7435315N120CFMatts Cats LLC · Osceola, WIBuilt 2007 · S/N TC0707018N120CPPorter Charles J · Camas, WABuilt 2012 · S/N 001N120DUnited States Air Force Owner · Hanscom Afb, MABuilt 1972 · S/N 27-4799N120DFFormsma Douglas A · Floral City, FLBuilt 2011 · S/N 70535N120DGBluesail LLC · Las Vegas, NVBuilt 1981 · S/N 32R-8129077N120DMWestfall Aviation LLC · Reno, OHBuilt 1973 · S/N 32-7340122N120DSElement Aero LLC · Chicago, ILBuilt 2002 · S/N 40.220N120FWRaabe Travel LLC Series 1 · Whitehouse, TXBuilt 1998 · S/N 4636134N120GBug Air LLC · Anchorage, AKBuilt 1996 · S/N 23027CN120GRStarlight Flight Aerial Tours LLC · Coppell, TXBuilt 1999 · S/N 18280430N120JRainbow Sports Inc · Enid, OKBuilt 1988 · S/N 60
Back to AD 87-10-06 R1