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.

N7772WWadhwa Anil Jethanand · Clarksville, TNBuilt 2004 · S/N 18281336N7773NDmac Aircraft LLC · Savannah, GABuilt 1968 · S/N 28-5221N7773PJenkins John R · Fairmont, WVBuilt 1962 · S/N 24-2989N7773WVida Kenneth J · Harrison Township, MIBuilt 1964 · S/N 28-1776N7773YBismuth Robert · Seattle, WABuilt 1965 · S/N 30-859N7774DPosson John L Trustee · Petaluma, CABuilt 1957 · S/N 18-5957N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474N7774NRai Jeff · Nazareth, PABuilt 1968 · S/N 28-5222N7774TPanjab Aviation · Las Vegas, NVBuilt 1979 · S/N ME-191N7774VMarshall Soaring Club Inc · Marshall, MIBuilt 1969 · S/N 1528N7774WSanto Chanselor L · Pasco, WABuilt 2008 · S/N 115MN7774YReed John · Seattle, WABuilt 1965 · S/N 30-860N7775ACarbon Cub 5x LLC · Sun Valley, IDBuilt 2025 · S/N CCK-2000-0112N7775BCessna 206 LLC · Sun Valley, IDBuilt 2000 · S/N T20608197N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475N7775MDennis Bruce · Rapid City, MIBuilt 1974 · S/N 20-0021N7775NHarris Mark · Greenville, SCBuilt 1968 · S/N 28-5223N7775SWildes Thomas · Chippewa Falls, WIBuilt 1976 · S/N 227-76N7776DSecond Delaware Corp · Moorestown, NJBuilt 1957 · S/N 18-5961N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476N7776MPinckney Robert L · Elgin, SCFirst renewal noticeBuilt 1974 · S/N 21-0032N7776NSkylark Flight Training LLC · Wilmington, DEBuilt 1968 · S/N 28-5224N7776PHardin Gerald A · Port Clinton, OHFirst renewal noticeBuilt 1962 · S/N 24-2993N7776ZThatcher William Scott · Eau Claire, WIBuilt 1966 · S/N 18-8483N7777CSouthern Sky LLC · Henderson, NVBuilt 1976 · S/N 17267334N7777DMorris Blain E · Delta Junction, AKBuilt 1954 · S/N 18-5962N7777FPlastech Corporation · Atlanta, GABuilt 1989 · S/N 4622016N7777GNittany Flyin LLC · Amarillo, TXBuilt 1991 · S/N 4622118N7777PWeihe Philip D · Cleveland Heights, OHBuilt 1961 · S/N 24-2994N7777WAmmon Roadable Aircraft LLC · Manchester, NHBuilt 1964 · S/N 28-1781N7777YDigati Anthony J · Mentone, CAS/N 30-863N7778BPeters Ben C · Leavenworth, WAS/N 2750N7778MFlorida Best Airlines LLC · North Miami Beach, FLBuilt 2011 · S/N 3RX095N7778NAsari Investments LLC · Knoxville, TNBuilt 1968 · S/N 28-5225N7778YSpiegel Eitan · San Francisco, CABuilt 1965 · S/N 30-864N7778ZIglehart Stephen R · Bismarck, NDBuilt 1966 · S/N 25-3977N7779CDicey Aviation LLC · Somerset, KYBuilt 1975 · S/N 28-7615063N7779DEssman Kenneth R · Burlington, WIS/N 18-5964N7779NPhyxsius Aviation LLC · El Paso, TXBuilt 1968 · S/N 28-5226N7779TDavidson Thad · Whitehouse, TXBuilt 1978 · S/N 32R-7887196N7779WHolowatsch Sergio O · Archer, FLBuilt 1964 · S/N 28-1785N7779YMccool Kenneth W · Olive Branch, MSBuilt 1965 · S/N 30-865N777AHJarhead Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 17261695N777BBMrnak Andy M · Bowman, NDBuilt 1961 · S/N 24-2227N777BSMathison John M · Del Norte, COBuilt 1969 · S/N 61-0043-84N777CCJohnston Steven M · Lyle, WABuilt 1984 · S/N S-300-CC-1N777CMCentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1412-147N777CRRhodes Curt W · Reno, NVBuilt 1973 · S/N 2044N777CYMiller Shawn C · Milaca, MNBuilt 1996 · S/N 24482N777DFOl Hughes LLC · Staplehurst, NEBuilt 1972 · S/N 24-5019
Back to AD 87-10-06 R1