OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,003

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.

N11643Henderson George L · Fresno, CABuilt 1975 · S/N 549-75N11645Tango Bravo Air LLC · Nederland, COBuilt 1972 · S/N 344-72N11646Hough Howard A · Paris, TNBuilt 1972 · S/N 311-72N11647Ronsman Harry · Talkeetna, AKBuilt 1972 · S/N 345-72N1164XRegistered aircraftBuilt 1975 · S/N 28R-7535263N11650Dupuis Charles Jr · Breaux Bridge, LABuilt 1972 · S/N 839-72N11657Morgan Jacob R · Salem, INBuilt 1972 · S/N 347-72N11658Lorenz William D · Benson, MNBuilt 1972 · S/N 234-72N11659Villa Holdings LLC · Commerce, CABuilt 1972 · S/N 304-72N1165UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17266872N1165XLechtenberg Lance · El Dorado, KSBuilt 1975 · S/N 32-7540150N1165ZRegistration Pending · Las Cruces, NMRegistration pendingBuilt 1965 · S/N 1555-198N11660Gottschalk Brian D · Moscow, IDS/N 305-72N11668Cummings Arthur J · Delta Junction, AKS/N 349-72N1166ELake Jeffrey W · Steamboat Springs, COBuilt 1977 · S/N 251-77N1166LNovack Edward A · Cairo, NYBuilt 1965 · S/N 328N1166PDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1955 · S/N 23-180N1167Miller Timothy · Norfolk, NEBuilt 1971 · S/N 178N11673Clobes Warren J · Evansville, WIBuilt 1972 · S/N 356-72N11676Stone Air LLC · Carrollton, GABuilt 1972 · S/N 236-72N11677Irby Darrell · Keller, TXBuilt 1972 · S/N 306-72N11679King Nathan A · Dunkirk, MDBuilt 1972 · S/N 307-72N1167PCascadia Air Ventures Inc · Winlock, WABuilt 1955 · S/N 23-181N1167XHoover Adam A · Sugarloaf, PABuilt 1975 · S/N 28-7525295N11680Adams Jonathan · Columbia, MOBuilt 1972 · S/N 21-72N11681Amelia Reid Aviation LLC · San Jose, CABuilt 1972 · S/N 308-72N11684Pepper Richard V · Henderson, TXBuilt 1972 · S/N 309-72N11686Hopewell Jeffrey D · Temple, TXS/N 310-72N11687Young William A · Delta Junction, AKBuilt 1972 · S/N 313-72N1168LDepaul Thomas J · Juneau, AKBuilt 1966 · S/N 330N1168PLangford Michael J · Middletown, MDS/N 3703N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219N11690Evers William J · Sussex, WIBuilt 1972 · S/N 355-72N1169AK-Air Service LLC · Gakona, AKBuilt 1951 · S/N 18-767N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063N1169RClayton Alfred T Jr · Anchorage, AKBuilt 2007 · S/N 004N116AJJewett Chris E · Lexington, SCBuilt 2004 · S/N DC03N116ARLower Timothy C · Biglerville, PABuilt 1997 · S/N 24850N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094N116BBretana Charles Jr · Prescott, AZS/N E006N116BKDacy Roy W · Rockport, TXS/N 32-782N116BWButler Ross W · Jackson, CABuilt 2001 · S/N 24986N116CCCrawford E Clarke · Flagstaff, AZBuilt 1992 · S/N 824N116CRConti Christine M · Plantation, FLBuilt 1976 · S/N 17266985N116DHHoover David · Foster City, CAFirst renewal noticeBuilt 1990 · S/N 0001N116DPPaup Dennis C · Carroll, IABuilt 2006 · S/N 70194N116DWWalters Douglas B · Templeton, CABuilt 2020 · S/N 21807N116FLMerdes Gordon B · Corpus Christi, TXBuilt 1974 · S/N 18-7509029N116FPRandall David J · Balsam Lake, WIBuilt 1978 · S/N 17271241N116GRegistration Pending · Sheridan, WYRegistration pendingBuilt 1995 · S/N 23019C
Back to AD 87-10-06 R1