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.

N6125ZSvendsen Jon A · Wasilla, AKBuilt 1960 · S/N 25-145N61260Syracuse Flight School Inc · Syracuse, NYBuilt 1978 · S/N 28R-7837255N6126DNeal Brian C · Monrovia, CABuilt 1957 · S/N 22-4770N6126MBishop Aeronautics LLC · Helena, MTBuilt 1977 · S/N 7161CN6126PDallas Jets Group LLC · Canton, TXBuilt 1959 · S/N 24-1226N6126SWise Joseph · Kilgore, TXBuilt 1965 · S/N 18-32N6126TGuida Associates Consulting Inc · Sandpoint, IDS/N S1496N6126WMatthews James C · Gilbert, SCBuilt 1964 · S/N 28-20142N6127AGilfert Thomas E · Selinsgrove, PABuilt 1979 · S/N 18-8009051N6127HBless Howard P · Pennsburg, PAFirst renewal noticeBuilt 1977 · S/N 28-7816226N6127MOhman Victor N · Glenrock, WYBuilt 1977 · S/N 7162CN6127VSorbi Aviation Inc · El Cajon, CAS/N 172RG0583N6127WLa Aviation Ltd · Wilmington, DES/N 28-20143N6127ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-148N6128PTango Alpha Sierra LLC · Berthoud, COS/N 4057CN6128TStone Mark · Scotts Valley, CABuilt 1982 · S/N R18201912N6128UJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1655N6129CSumner Scott B · Catoosa, OKBuilt 1988 · S/N 11057CN6129HHouk Air LLC · Waverly, OHBuilt 1977 · S/N 28-7890209N6129JBlue Skies Aircraft LLC · Kalispell, MTBuilt 1976 · S/N 28-7625221N6129LDodson David W · Granger, INBuilt 1970 · S/N AA1-0329N6129TTaf Aerial Services LLC · Beeville, TXBuilt 1988 · S/N 4053CN612APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 286-78N612BZDerby City Aviation LLC · Vero Beach, FLBuilt 1979 · S/N 17272084N612EHIsland Flyers Inc · Addison, TXBuilt 1976 · S/N 277654161N612FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816197N612GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881195N612GGMid Missouri Spray Service LLC · Richmond, MOBuilt 2016 · S/N 14016N612GPPlugge Glen A · Tuscaloosa, ALS/N 23920N612HPAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274933N612JLHeartland Aviation Inc · Alliance, NES/N 18-7409151N612JSWings Of Eagle LLC · Leo, INBuilt 1970 · S/N 32-40935N612KSRv Co LLC · Boulder, COBuilt 2010 · S/N 001N612LCGoodman Lawrence A · Granbury, TXBuilt 1969 · S/N 28-26033N612MRFladr LLC · Westfield, NJBuilt 1979 · S/N 27-8054008N612NPBirdpark Aviation LLC · Richmond, TXBuilt 2003 · S/N 2216N612PAJenkins Phillip R Jr · Fuquay Varina, NCBuilt 1977 · S/N 28-7790518N612RTWolding Mylo D · New Town, NDBuilt 2017 · S/N 82822N612TMMcdermott James Timothy · Newell, SDBuilt 2012 · S/N 1001N612WTPlane Leasing LLC · Tempe, AZBuilt 1978 · S/N 28-7816655N612WWEhecatl LLC · Fort Wayne, INBuilt 1977 · S/N 27-7754114N612XMexico Medical Missions · Missouri City, TXBuilt 2003 · S/N T18208202N6130DJones Matthew A · Saluda, NCBuilt 1979 · S/N 17272610N6130JUtley Gary D · Okmulgee, OKFirst renewal noticeBuilt 1976 · S/N 28-7615307N6130PHiga Bertram · Northridge, CAS/N 24-1230N6130XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1989 · S/N 7497CN6131JDotson Tem · Hindsville, ARBuilt 1976 · S/N 28-7615308N6131SClassic Rotors Museum · Ramona, CABuilt 1965 · S/N 18-38N6132GMorcom Aviation Services Inc · Everett, WABuilt 1979 · S/N 17273570N6132JWolf Aviation Network Inc · Westfield, MABuilt 1976 · S/N 28-7615309
Back to AD 87-10-06 R1