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.

N863PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881477N863SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881799N863VLVieques Air Link · Vieques, PRBuilt 1979 · S/N 2019N863WLStadjuhar Eric J · Omaha, NES/N 863N8640VFlannery John J · Atkinson, NES/N 816-75N8641PN8641p LLC · Gainesville, GABuilt 1964 · S/N 24-4082N8641VRusyniak Anthony J · Syracuse, NYBuilt 1975 · S/N 163-75N8642DAmerican Aviation Inc · Tracy, CABuilt 1979 · S/N 172RG0061N8642LTexas Soaring Assn · Midlothian, TXBuilt 1969 · S/N 25-5079N8642WKruckeberg Lloyd E · Amarillo, TXBuilt 1963 · S/N 28-10159N8643Gillespie Warren H · Hamilton, MTBuilt 1973 · S/N 354-73N8643DBurns Roni R · Bolivar, MOBuilt 1958 · S/N 22-5851N8643PCheatwood Owen Larry · Granbury, TXBuilt 1964 · S/N 24-4086N8643VLuvara Christopher J · Santa Clara, CABuilt 1975 · S/N 817-75N8643WJull Pamela · Bellingham, WABuilt 1963 · S/N 28-10150N8644FBemer Aviation Inc · Glastonbury, CTBuilt 1977 · S/N 770619N8644PFord Bernard C · Sidney, NYBuilt 1964 · S/N 24-4087N8644VSale Reported · Humboldt, IASale reportedBuilt 1975 · S/N 520-75N8644WMatos Noel · Newport Beach, CABuilt 1963 · S/N 28-10057N8645ECichocki Matthew R · Oviedo, FLBuilt 1976 · S/N 28-7690183N8646DAdams James F · Flagstaff, AZBuilt 1958 · S/N 22-5854N8647Ober John A · Candor, NYBuilt 1973 · S/N 355-73N86472Leopold Seth S · Bellevue, WABuilt 2008 · S/N 80957N8647ESkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843374N8647NVossberg Carl A · Umatilla, FLBuilt 1971 · S/N 28R-7135128N8647VSpratling Boyd M · Deeth, NVS/N 818-75N8647WChase Dan · Reno, NVS/N 28-10163N86483Eaa Aviation Foundation Inc · Oshkosh, WIBuilt 1957 · S/N 22-5777N8648PSelinger Richard · Seal Beach, CABuilt 1964 · S/N 24-4091N8648VBeachy Phil R · Bonners Ferry, IDS/N 16575N8648YChuss Edward · Metamora, MIBuilt 1969 · S/N 30-1791N8649Dudley Benjamin H · Wasilla, AKS/N 462-73N8649DGho Michael M · Fairbanks, AKBuilt 1958 · S/N 22-5857N8649NManchester Thomas P · Wilmington, DEBuilt 1971 · S/N 28-7125460N8649PMelodia Sean M · Cranberry Township, PABuilt 1964 · S/N 24-4092N8649WHigh Desert Flyers LLC · New London, NCBuilt 1963 · S/N 28-10165N864AFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2002 · S/N 85004N864EBudner Jeffrey B · Rio Vista, CABuilt 2002 · S/N 099N864GBenson Brad · Mamou, LABuilt 2016 · S/N CC19-0008N864JBouchard Cary T · Washburn, WIBuilt 1975 · S/N 864-75N864MSwingle Howard D · Blacksburg, VABuilt 1995 · S/N 822N864PAs6 Aero LLC · Kalispell, MTBuilt 2002 · S/N 07-02N864PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881498N864TWTailwinds Academy Of Aviation · Philadelphia, PABuilt 1972 · S/N 17261013N864VLVieques Air Link Inc · San Juan, PRBuilt 1974 · S/N 712N865Birge Stuart M · Charlotte, NCBuilt 2003 · S/N 3781N8650EGotta Fly LLC · Manitou Springs, COBuilt 1976 · S/N 28-7690184N8650NAllen Flight Service LLC · Laredo, TXBuilt 1971 · S/N 28R-7135106N8651CDoby Julian · Graham, NCBuilt 1976 · S/N 28R-7635170N8651ESchoen Michael · Lakeville, MNBuilt 1976 · S/N 28R-7635193
Back to AD 87-10-06 R1