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.

N74725Oran Jamie A · Apple Valley, CAS/N 1725N74729Registration Pending · Weston, IDRegistration pending, pending cancellationBuilt 1961 · S/N 1729N7472RSouthern Jeffrey · Rayville, LABuilt 1966 · S/N 28-22021N7472WTait Ronald M · Fort Worth, TXBuilt 1963 · S/N 28-1377N74730Twin Rivers Wildlife Inc · Elko, NVBuilt 2005 · S/N 10888N74731Registration Pending · Bella Vista, ARRegistration pendingS/N 1731N74733Maxwell Stephen R · Dodge City, KSBuilt 1976 · S/N AA5B0357N74735Tipton Michael · Florissant, COBuilt 1961 · S/N 1735N74736Russell Robert C · Decatur, ALBuilt 1961 · S/N 1736N7473DRezzonico John · Round Hill, VABuilt 1957 · S/N 18-5808N7473RSonntag Donald · Marengo, ILFirst renewal noticeBuilt 1966 · S/N 28-22022N7473YSale Reported · Palmer, AKSale reportedBuilt 1964 · S/N 30-538N74740Woodyatt Michael A · Byron, ILBuilt 1976 · S/N AA5B0358N74745Renfroe Daniel P · Eagleville, TNBuilt 1961 · S/N 1745N74747Dubois Alan P · Jamestown, RIBuilt 1961 · S/N 1747N74748Moore David · Amarillo, TXBuilt 1961 · S/N 1748N7474DRogue Aero LLC · Grants Pass, ORS/N 18-5809N7474GBarnett Kevin · Simi Valley, CABuilt 1970 · S/N 17259174N7474JHorton James D · Las Vegas, NVS/N 28R-30827N7474LNelson Travis E · Richland, MTBuilt 1975 · S/N 18-7509069N7474RGregorski Thomas E · Kenly, NCBuilt 1966 · S/N 28-22023N7474TWorks James K · Avalon, CABuilt 1967 · S/N 28-23432N7474WZimmerman Sandra · Henderson, NVBuilt 1963 · S/N 28-1379N74750Anderson Jonathan R · Corpus Christi, TXS/N 1750N74752Brundige Mark S · Mount Pleasant, TXBuilt 1961 · S/N 1752N74758Robins Stephen B · Hutchinson Island, FLS/N 1758N74759Page Casey P · Abilene, TXBuilt 1961 · S/N 1759N7475RTolsma Garrett J · Kirkland, WABuilt 1966 · S/N 28-22024N7475YOverseas Aviaton Inc · Wilmington, DEBuilt 1964 · S/N 30-540N74760Boyle Fred Sr · Cape May, NJBuilt 1961 · S/N 1760N74762Bulldog Aviation LLC · Kalispell, MTBuilt 1961 · S/N 1762N74763Crouse Stanley G · Greenwood, MOS/N 1763N74764Carter Dejuan Jermaine · Little Rock, ARBuilt 1961 · S/N 1764N74765Lister Thomas L · Wynnewood, OKS/N 1765N74766Reiner Henry A · Hutchinson, MNBuilt 1961 · S/N 1766N74767Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10915N74768Delissa Leighton A · Meade, KSS/N 1805N74769Bulut LLC · Los Angeles, CAS/N 1769N7476DHincke Cedar F · Kalispell, MTBuilt 2012 · S/N 001N7476JHernandez Miguel A · Brownsville, TXBuilt 1968 · S/N 28R-30831N7476LGrabofsky Livestock & Grain Inc · Hogeland, MTBuilt 1975 · S/N 18-7509072N7476RCarrillo Jeremiah · Shelton, WABuilt 1966 · S/N 28-22026N7476WAddison Robert M · Fort Sumner, NMBuilt 1963 · S/N 28-1385N7476YWilliam L Stewart Code Supplies Inc · Rossville, TNBuilt 1964 · S/N 30-541N7477Lochinger Dale · Everson, PABuilt 2020 · S/N 22205N74770Dubois Aviation Inc · Chino, CABuilt 1961 · S/N 1770N74774Alyeska Helicopters LLC · Girdwood, AKBuilt 2005 · S/N 3967N74775Morriss Robert W · Amarillo, TXS/N 1775N74777N74777 LLC · Key West, FLBuilt 1961 · S/N 1777N7477LWika Gregory B · Anchorage, AKS/N 18-7509060
Back to AD 87-10-06 R1