OpenAirDocs.org
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.

N5EBN5eb LLC · Medina, OHBuilt 1967 · S/N 30-1474N5EECristal Air Inc · Wilmington, DEBuilt 1993 · S/N 172N5EYOshikoo LLC · Seattle, WABuilt 2004 · S/N 70267N5FMWillis Nelson W · Lebanon, TNBuilt 1994 · S/N 0001N5FNM J S Corp · Howe, INBuilt 2013 · S/N 1468-2012N5FVRegistered aircraftBuilt 1981 · S/N 2254N5GHDowin Robert R · Doylestown, PABuilt 1970 · S/N 700046N5GJNorthampton Lsa LLC · Northampton, MABuilt 1978 · S/N GA7-0006N5GNNeu Lawrence R · Marion, TXBuilt 1977 · S/N XX5N5HMEvans Hayward D · Saint Augustine, FLBuilt 1973 · S/N 27-7305041N5HNBartle Henry P · Independence, ORBuilt 1991 · S/N S 55N5JBucher John R · Rch Palos Vrd, CABuilt 1966 · S/N 300N5JCSink Abram T · Hillsboro, OHBuilt 1982 · S/N 518N5JLRegistered aircraftBuilt 1968 · S/N TD-719N5JNOcchiuzzo Joseph A · Holyoke, MAFirst renewal noticeBuilt 1963 · S/N 28-1528N5JXFive Jx LLC · Tucson, AZBuilt 2012 · S/N 24785N5KDTexas Tailspin LLC · Amarillo, TXBuilt 1974 · S/N 155-74N5KFSneddon Dale R · Carthage, MOBuilt 1986 · S/N 65N5LGStuller Dennis · Fort Denaud, FLBuilt 1966 · S/N 28-22238N5LLInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7812041N5LYLittle Karley Y · Baytown, TXBuilt 1971 · S/N 474N5MAScola Daniel B · Port Orange, FLBuilt 1967 · S/N 30-1622N5MDDunn Vincent K · Salem, ORBuilt 1966 · S/N 3317N5MFFrey Michael L III · Waco, TXBuilt 1973 · S/N 1N5MHGould Ralph Harvey Jr · White Cloud, MIBuilt 1967 · S/N 32-40268N5NSN5ns LLC · Payson, AZBuilt 1995 · S/N NEALN5PTMunson George R · Westhampton, MABuilt 1972 · S/N 17260628N5QABear Canyon LLC · Afton, WYBuilt 1997 · S/N 1369N5QTHusky5qt LLC · Scappoose, ORBuilt 1997 · S/N 1380N5RJPilkington Lawrence O · Portland, ORS/N 739N5RWToms Ronald C · Lena, LABuilt 1970 · S/N 17259649N5SKKershaw Spence M · Hollywood, FLBuilt 1975 · S/N 135-HN5SMBearss Gordon M · Topeka, KSBuilt 1974 · S/N 21-0051N5SPMalley Anthony M · Arlington, TXBuilt 2005 · S/N 70144N5SRRollins Jay A · Muncie, INBuilt 1978 · S/N 73059LFN5SWPrendergast Gene D · Willcox, AZBuilt 1978 · S/N 32R-7887150N5TEBythway William M · Painesville, OHBuilt 1968 · S/N 113N5UASenneker Robert L · Dorr, MIBuilt 2001 · S/N 25103N5UBWynne Brian P · Reston, VABuilt 1996 · S/N 1762N5VTEmaaduddin Mohammed · Yonkers, NYBuilt 1967 · S/N 28-23176N5VYFeatherstone Tony W · Denton, TXBuilt 1973 · S/N AA5-0462N5WDSonoma Valley Aircraft Inc · Vineburg, CABuilt 1980 · S/N 105DN5WKEz Air Inc · Wilmington, DES/N 30-1853N5WPPhagan Loyce W · Waterford, MIBuilt 1973 · S/N 92N5WUDiamond West LLC · Walnut Creek, CABuilt 2004 · S/N 40.400N5WWClark Nikita C · Ontario, ORBuilt 1965 · S/N 30-708N5XA47 Yankee LLC · Bellaire, MIBuilt 1997 · S/N 1371N5XJOmalley Theodore J · Willow, AKBuilt 1998 · S/N 1424N5XWLewis Everett D · Comfort, TXBuilt 2004 · S/N 10242N5YGSethjay LLC · Washington, DCBuilt 1995 · S/N 4636001
Back to AD 87-10-06 R1