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.

N6444PSanderson Grain Inc · Springlake, TXBuilt 1959 · S/N 24-1558N6444RSchool Board Of Nassau County Fl · Fernandina Beach, FLBuilt 1966 · S/N 28-21627N6444TYankee Flying Club Inc · Maple Grove, MNBuilt 1985 · S/N R18202026N6444VPowell William G Jr · Greenville, NCBuilt 1980 · S/N 172RG0705N64450Washington John W · Barrington, NHBuilt 1975 · S/N 17265237N64451Registration Pending · Goodman, MSRegistration pendingBuilt 1975 · S/N 17265238N64453Cofa Operations LLC · Dothan, ALBuilt 1975 · S/N 17265240N64454True Blue Flying LLC · Wilmington, DEBuilt 1975 · S/N 17265241N64455Sales Eric D · Keystone Heights, FLBuilt 1975 · S/N 17265242N64456Registered aircraftBuilt 1975 · S/N 17265243N6445RElmore Charles E · Flowery Branch, GABuilt 1966 · S/N 28-21628N6445TCarver James Kevin · Durango, COBuilt 1985 · S/N R18202027N6445UFerrin Lora J · Rio Rancho, NMBuilt 1962 · S/N 2192N64464Vector Air LLC · Erie, COBuilt 1982 · S/N 17275563N64465N64465 LLC · Fort Lauderdale, FLS/N 17265250N6446DN2893e LLC · Reno, NVBuilt 1979 · S/N 17272805N6446LPradhan Anis · Torrance, CABuilt 1972 · S/N AA1A-0446N6446RChapin Lee · Newburgh, INFirst renewal noticeBuilt 1966 · S/N 28-21629N64477Rico Aviation Services Inc · Miami, FLBuilt 1975 · S/N 17265257N6447964479 LLC · Cortland, OHBuilt 1975 · S/N 17265259N6447JCasper Flair LLC · Wilmington, DEBuilt 1968 · S/N 28-4865N6447MSpring Creek Land & Cattle LLC · Lance Creek, WYBuilt 2001 · S/N 25072CN6447PTuttle Glenn L · Lynnwood, WABuilt 1959 · S/N 24-1562N6447QP&M Enterprises LLC · North Charleston, SCBuilt 1967 · S/N 670526N6447RGensler Orion M · Bloomfield, MOBuilt 1966 · S/N 28-21630N6447UOlathe Spray Ser Inc · Olathe, COBuilt 1962 · S/N 2252N6447WSeverson Eric · Waukesha, WIBuilt 1964 · S/N 28-20519N6447ZH&H Ag Aviation Inc · New Underwood, SDBuilt 1961 · S/N 25-607N64485Registration Pending · La Harpe, ILRegistration pendingBuilt 1975 · S/N 17265262N6448JMurphy Richard F · Hughesville, MDS/N 28-4867N6448PPlowman James C · Upland, CABuilt 1959 · S/N 24-1563N6448QMicheliche Robert B · Federalsburg, MDBuilt 1967 · S/N 670527N6448RShaw Timothy E · Ashtabula, OHBuilt 1966 · S/N 28-21631N6448WSierra Lima Aviation LLC · Riverton, UTS/N 28-20520N64493Neron II LLC · Lewes, DEBuilt 1982 · S/N 17275565N6449JBentley Aviation Services · Lewes, DEBuilt 1980 · S/N 17273874N6449TPelayo Fernando · La Puente, CABuilt 1985 · S/N R18202028N644AKMd Ag Services LLC · Sterling City, TXBuilt 2004 · S/N 10364N644BCRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1976 · S/N 32R-7680229N644CLLeckie Charles W · Rosemount, MNBuilt 1997 · S/N 1834N644CMMckenzie Bradley J · Houston, TXBuilt 2004 · S/N 1376-2004N644DDArfvidsson Emil · Mountain View, CABuilt 1978 · S/N 24-0664N644DFRegent Trust Corp Trustee · Wichita, KSBuilt 2023 · S/N 2881663N644DRNorthwestern Michigan College · Traverse City, MIBuilt 1953 · S/N 18-2867N644EZNorthern Air Spray LLC · Maple Grove, MNBuilt 2007 · S/N 11971N644FLAty Aviation Inc · Watertown, SDBuilt 1971 · S/N 28-7125552N644FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843704N644GRishel Keith D · Prineville, ORBuilt 1970 · S/N 28-26741N644GDDuda W Gregory · Grass Valley, CABuilt 1993 · S/N 644N644JDDougherty Joseph D · Wheaton, ILBuilt 1994 · S/N 832
Back to AD 87-10-06 R1