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.

N8578CRiver Valley Flyers LLC · West Hartford, CTBuilt 1976 · S/N 28-7690152N8578DCoy Shane A · Nenana, AKBuilt 1958 · S/N 18-6236N8578PGibbs Gregory Curtis · Engelhard, NCBuilt 1964 · S/N 24-4035N8578VNelson Timothy E · Fairbanks, AKBuilt 1974 · S/N 143-75N8578ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842413N8579Ralls Eddie · Evergreen, ALBuilt 1973 · S/N 457-73N8579CSolberg John W · Bismarck, NDBuilt 1953 · S/N 18-2732N8579NWillaero LLC · Union City, TNBuilt 1971 · S/N 28-7105133N8579PWor LLC · Jamaica Beach, TXBuilt 1964 · S/N 24-4036N8579VWalsh Leo A Jr · Anchorage, AKBuilt 1974 · S/N 797-75N8579WWessler George H · Dunedin, FLBuilt 1963 · S/N 28-10091N857AKOld City Helicopter Sales LLC · St Augustine, FLS/N 1145N857DKKnight Kevin · Dallas, TXBuilt 1983 · S/N R18201935N857GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881068N857JWWarren Joseph A · Milford, DEBuilt 1963 · S/N 2435N857MMVigilante Helicopters LLC · Lewistown, MTBuilt 1982 · S/N 723N857PDFelter John Vincent Jr · Lago Vista, TXFirst renewal noticeBuilt 2000 · S/N 18280857N857RDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 30109N857SSjs Aviation Co · Casper, WYBuilt 1981 · S/N 28-8190224N857SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881741N857SPSoutheastern Oklahoma State University · Durant, OKS/N 172S8115N857WAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 3257355N8580DKedrowski James L · Wasilla, AKBuilt 1958 · S/N 18-6238N8580ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842414N8580NA1 Aviation LLC · Lewis, DEBuilt 1969 · S/N 28-11317N8581ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020159N8581DDutch Air LLC · Kalispell, MTBuilt 1957 · S/N 18-6239N8581JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842415N8581VObx Airplanes LLC · Manteo, NCBuilt 1975 · S/N 805-75N8582CCurran Aviation Services LLC · Yorba Linda, CABuilt 1976 · S/N 28R-7635166N8582ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020160N8582JMarchione Laverne R · Diamondville, WYBuilt 1967 · S/N 15066482N8582PSchwalbach Russell R · Bondurant, IABuilt 1964 · S/N 24-4039N8583BSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020201N8583PLl Aviation LLC · Kansas City, MOBuilt 1964 · S/N 24-4040N8583VMorten John E DBA · Larimore, NDBuilt 1975 · S/N 145-75N8583YGray Michael W · Cheyenne, WYBuilt 1968 · S/N 30-1736N8584DSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020202N8584PHackens Donald G · New Underwood, SDBuilt 1964 · S/N 24-4041N8584WSawyer Clissie M · North Platte, NEBuilt 1963 · S/N 28-10096N8585DMadsen Travis E · New Underwood, SDBuilt 1957 · S/N 18-6244N8585HSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020232N8585PNelson Christopher A · Silver Spring, MDBuilt 1964 · S/N 24-4042N8585YGospel Ministeries International Inc · Mc Donald, TNBuilt 1968 · S/N 30-1738N8586JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020233N8586YTrue Glenn C Jr · Phoenix, AZBuilt 1968 · S/N 30-1739N8587BDorsey Tony A · Anchorage, AKBuilt 1958 · S/N 36287N8587DSouthard Bryan O · Moneta, VABuilt 1957 · S/N 22-5766N8587LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020234N8587TJet Winds LLC · Gulf Shores, ALBuilt 1972 · S/N 32-7340022
Back to AD 87-10-06 R1