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.

N605MAAir Assets LLC · Orlando, FLBuilt 2000 · S/N 172S8605N605MNSale Reported · Boise, IDSale reported, pending cancellationBuilt 2022 · S/N 5368N605RSMegerdoomian Eric · Fort Riley, KSS/N 2258N605RVMalocsay Michael M · Golden, COBuilt 2002 · S/N 2179N605TCOhtonen Thomas R · Chassell, MIBuilt 2019 · S/N 91526N605WCGyger Keith J · Granbury, TXBuilt 2018 · S/N 004N60605Croft Stanton W · Glenwood, NMBuilt 2001 · S/N 25379N6060DHughes Truman C · Delta Junction, AKBuilt 1956 · S/N 22-4713N6060FKeller Matthew Charles · Wasilla, AKBuilt 1985 · S/N 4023CN6060WNilsen Daniel P · Holmes, NYS/N 28-20072N6061QThurston David H · Cincinnati, OHBuilt 1965 · S/N 894N6062ANelson Stephen H · Apple Valley, MNS/N 18-8009046N6062LFoo Flyers LLC · Charlotte, NCBuilt 1972 · S/N AA5-0162N6062PYoung Tracy K · Newcomerstown, OHS/N 24-1158N6062YJahba LLC · Coral Springs, FLBuilt 1966 · S/N 27-3257N6063ELawrence Aviation LLC · Overland Park, KSS/N 17271987N6063HHagerstown Flying Club · Williamsburg, INBuilt 1977 · S/N 28-7890203N6063QTaylor Alan M · Nekoosa, WIBuilt 1965 · S/N 896N6064DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1956 · S/N 22-4717N6064LBohannon Jessica · Tomball, TXBuilt 1972 · S/N AA5-0164N6064QWilliams Rodney K · Stacy, MNBuilt 1965 · S/N 3249N60658Euroaviation Inc · KematenBuilt 1981 · S/N V57N6065HNoble Mark · Memphis, TNBuilt 1977 · S/N 28-7890204N6065QShick Douglas Todd · Chester, VAS/N 3250N6065WBeyond Aviation LLC · Jacksonville, FLBuilt 1964 · S/N 28-20077N6066DDaily John F · Chugiak, AKBuilt 1957 · S/N 22-4719N6066HFlaps Inc · Cincinnati, OHBuilt 1977 · S/N 28-7890205N6066LBrown Andy · Cypress, TXBuilt 1972 · S/N AA5-0166N6066NPacific Union College · Angwin, CABuilt 1968 · S/N MB-398N6066QArmagost James C · Belton, TXBuilt 1965 · S/N 897N6066WAshpaugh Larry D · Hilltop Lakes, TXBuilt 1964 · S/N 28-20078N6067NGustavson Allan R Jr · Tonopah, AZBuilt 1968 · S/N MB-391N6067PRoark William B · Silverdale, WABuilt 1959 · S/N 24-1163N6067QFrantz Joseph M · Gill, COBuilt 1965 · S/N 898N6068DThorn Blake A · Coupeville, WAS/N 22-4721N6068NVan Steenburgh Owen Christopher · Manitowoc, WIBuilt 1968 · S/N MB-392N6068PGear Down Hangar LLC · Phoenix, AZBuilt 1959 · S/N 24-1164N6068QPressley Jerry · Morristown, TNBuilt 1965 · S/N 899N6068RPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 6006647961210N6068WRivera Jose · Spencer, WVFirst renewal noticeS/N 28-20080N6069FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020151N6069NAurand Bradley · Selinsgrove, PABuilt 1979 · S/N 61P06717963314N6069YAngelman Aviation LLC · Prosper, TXBuilt 1966 · S/N 27-3267N606AGWhipple Marvin G · Pawnee Rock, KSBuilt 2003 · S/N 80433N606BHWhite Montie Eugene Trustee · Hartsville, TNBuilt 2000 · S/N 002BHN606BJHickman Smith Dean John · Wilton, CABuilt 2007 · S/N 23992N606CACv Wings LLC · Canby, MNBuilt 1972 · S/N 27-4853N606DBBode Aviation Inc · Albuquerque, NMBuilt 2002 · S/N 17281141N606DCWhiteside John M · Sandy Valley, NVBuilt 2024 · S/N L2K-154N606DPRegistered aircraftBuilt 2006 · S/N 40387
Back to AD 87-10-06 R1