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.

N9911WCategory One Aviation LLC · Atascadero, CABuilt 1967 · S/N 28-23433N9911YTyrrell Luke L · Fairbanks, AKS/N 120N9912DAssociated Property And Business Services LLC · Myrtle Beach, SCS/N 16001CN9912LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276648N9912QKd Aviation LLC · Sheridan, WYBuilt 1975 · S/N 17265856N9913RBridges James · Chico, TXBuilt 1965 · S/N 24-4255N9913UThomason David F · Poplar Grove, ILBuilt 1977 · S/N AA5A0313N9913WJcl Equipment Rental · Coleta, ILBuilt 1967 · S/N 28-23434N9913XReinhardt Brent · Collierville, TNS/N 3RX117N99141Airgo Inc · Centralia, ILBuilt 1985 · S/N 17276409N9914ESimica Charles A · Marietta, GABuilt 1979 · S/N 17272288N9914LFlex Air Holdings Inc · Manhattan, KSBuilt 1986 · S/N 17276649N9914QVictor Aviators Inc · Kernersville, NCBuilt 1975 · S/N 17265858N9914SSheffield Robert A · Mooresville, NCBuilt 1967 · S/N 28-23672N9914UBroderick James Edward · Baltimore, MDBuilt 1977 · S/N AA5A0314N9914WYellow Bird Flying Club · Toledo, OHBuilt 1967 · S/N 28-23435N9914YKnapper Jack A · Hibbing, MNBuilt 1961 · S/N 7GCB-112N99157Hess Garrett J · Fullerton, CABuilt 1985 · S/N 17276412N9915BTaro Investment LLC · Doral, FLBuilt 1982 · S/N 172RG1078N9915UBest Oren · Sunfield, MIBuilt 1977 · S/N AA5A0315N9915WAlimardani Shahrakh · Aguanga, CABuilt 1967 · S/N 28-23436N9916DUeeck Brett · Anchorage, AKBuilt 1959 · S/N 18-6958N9916WCulp Mason J · Bonney Lake, WABuilt 1967 · S/N 28-23438N99171Airlake Aero Inc · Lakeville, MNBuilt 1985 · S/N 17276414N9917QStill Flying LLC · Gibsland, LABuilt 1975 · S/N 17265861N9917WFlydunn.Com Inc · Jacksonville, FLBuilt 1967 · S/N 28-23439N9918DSnow Peter T Jr · Mcgrath, AKBuilt 1959 · S/N 18-6960N9918EByrne Evan A · Mountain Lake Park, MDBuilt 1979 · S/N 17272289N9918FChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280194N9918QCerqueira Luiz Fernando · Orem, UTBuilt 1975 · S/N 17265862N9918TBertrand Jeff J Trustee · Willow, AKBuilt 1987 · S/N 7491CN9918USpencer Robert E · Independence, ORBuilt 1977 · S/N AA5A0318N9919BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 172RG1080N9919QBlomstrom Andrew R · Oregon, WIBuilt 1975 · S/N 17265863N9919TFour M Aviation LLC · Saint Petersburg, FLBuilt 1994 · S/N 3213075N9919UFuller Michael D · Columbia, MDBuilt 1977 · S/N AA5A0319N991AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843807N991ACXin Han Aviation LLC · Randolph, MABuilt 1979 · S/N 44-8095011N991ASAero Training Services Inc · Lake City, FLBuilt 1982 · S/N 32R8229019N991BJSilver Express Co · Miami, FLBuilt 1986 · S/N 28-16008N991CBBorg Derek F · Dallas, TXBuilt 1969 · S/N 28-11173N991DCFigueroa Lionel Xavier · Sacramento, CAFirst renewal noticeBuilt 2004 · S/N 96-0363N991EMelson William · Palm City, FLBuilt 1964 · S/N 24-4083N991FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881869N991GBTempleton Robert P · La Jolla, CAS/N D286N991KLutkus Gerald A · Medina, OHBuilt 1964 · S/N 24-4055N991KCSalt Lake Community College · Salt Lake City, UTBuilt 1999 · S/N 2898N991KERaper Sandra K · Mesa, AZBuilt 2000 · S/N 3040N991RRSale Reported · Inman, SCSale reported, canceledBuilt 2000 · S/N 5637N991TPeterson Air LLC · Chisago City, MNBuilt 1999 · S/N T20608065
Back to AD 87-10-06 R1