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.

N736RGRegistered aircraftBuilt 1978 · S/N R18200762N736RMBagwell Danny A · Arley, ALBuilt 1967 · S/N 28-22876N736RQKisic Michael L · Rector, PABuilt 1978 · S/N R18200764N736SRegistered aircraftRegistration pendingBuilt 2005 · S/N 70105N736TGMagleby Herbert K · Surprise, AZS/N R18200768N736TRLangrell Sterling S · Woodburn, ORBuilt 1998 · S/N 2300N736TSRose Clarence E III · Grove, OKBuilt 1978 · S/N R18200770N736UDSeven Ranges Mfg Corp · Carrollton, OHBuilt 1978 · S/N R18200771N736VFEdgar Warren · Granite Bay, CABuilt 1978 · S/N R18200776N736VKGeneral Aviation LLC · Henderson, NVBuilt 1978 · S/N R18200777N736VTRucker William C Trustee · Sanger, TXBuilt 1978 · S/N R18200778N736WHB&B Island Aviation LLC · Sylvania, OHBuilt 1978 · S/N R18200779N736WPN736wp LLC · Waterford, NYBuilt 1979 · S/N R18200781N736WXStone Aviation LLC · Cusick, WABuilt 1978 · S/N R18200783N736XPsa LLC · Fort Myers, FLBuilt 1973 · S/N 32-7340095N736XGStonecipher Guy Austin III · Beaumont, TXBuilt 1978 · S/N R18200785N736YLFive Star Electric Inc · Lakin, KSBuilt 1978 · S/N R18200789N736YQZupanick Joseph A · Montevallo, ALBuilt 1978 · S/N R18200790N736YWInvestments Property Holdings Aviation LLC · Jonesboro, GAS/N R18200793N736YYYankee Yankee LLC · Bend, ORBuilt 1978 · S/N R18200795N736YZHamilton Rial Pc · Austin, TXBuilt 1978 · S/N R18200796N736ZDEllis Jack E Trustee · Tahoe City, CABuilt 1979 · S/N R18200797N736ZGWhiskey Romeo 1 LLC · Jacksonville, FLS/N R18200800N736ZJO'Connell Patrick J · Henderson, NVS/N R18200802N736ZNTakemori Gil M · San Jose, CABuilt 1978 · S/N R18200805N736ZPPaul Roussell LLC · Delhi, IABuilt 1978 · S/N R18200806N736ZTAircraft Structural Repair Inc · Hamilton, MTBuilt 1978 · S/N R18200810N736ZVBerry Andrew J · Saint Paul, MNBuilt 1979 · S/N R18200812N736ZXRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N R18200813N7370Kittinger Russell P · Birchwood, WIBuilt 2012 · S/N DB-003N73702Shiles Darrel J · Baltimore, MDBuilt 1976 · S/N 17267615N73707Leading Edge Flight Academy LLC · Bend, ORBuilt 1976 · S/N 17267620N7370JBoone Bradford D · Lincoln, MEBuilt 1968 · S/N 28-24725N7370PLeesman Raleigh R · Blunt, SDBuilt 1961 · S/N 24-2550N7370WDonahue Emily Stacy · Dallas, TXBuilt 1963 · S/N 28-1252N7370ZOmaha Soaring Club Inc · Omaha, NEBuilt 1965 · S/N 25-3325N7371Registered aircraftBuilt 1998 · S/N 18280212N73719Purdue Aviation LLC · West Lafayette, INBuilt 1976 · S/N 17267624N7371DLohse Teal K · Cordova, AKBuilt 1957 · S/N 18-5736N7371LMcewen Michael Trustee · Overgaard, AZBuilt 1972 · S/N AA5-0210N7371PJsntg Inc · Wilmington, DEBuilt 1961 · S/N 24-2552N7371TEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2004 · S/N 10563N7371WVista I Inc · Smithville, OHBuilt 1963 · S/N 28-1253N73726Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267630N73728Crowe Robert B · Del Valle, TXBuilt 1976 · S/N 17267632N7372JMccabe Colin · Frisco, TXBuilt 1968 · S/N 28-24727N7372PArnold Matthew C · Alpine, CABuilt 1961 · S/N 24-2553N7372ZLong Island Soaring Assn · Yaphank, NYBuilt 1965 · S/N 25-3328N73732Midway Capital Aviation Inc · Orlando, FLBuilt 1976 · S/N 17267634N7373DKramer William L · Big Lake, AKBuilt 1952 · S/N 18-5738
Back to AD 87-10-06 R1