OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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.

N6933PGeorghiou Sophia B · San Diego, CABuilt 1960 · S/N 24-2067N6934BBrownlee Chase J · Billings, MTBuilt 1956 · S/N 22-4213N6934DJohnson Steven D · Pardeeville, WIBuilt 1957 · S/N 22-4862N6934PChapman William R · Monroe, GABuilt 1960 · S/N 24-2068N6936KVan Bergeyk Ronald J · Trapper Creek, AKBuilt 1950 · S/N 20-38N6936ZKingsley Kiman J · Miller, MOBuilt 1964 · S/N 25-2680N6937KInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 20-34N6937ZStewarts Aircraft Service Inc · Waynesville, OHBuilt 1964 · S/N 25-2681N6938DVanaman Robbie M · Wheeling, WVBuilt 1957 · S/N 22-4866N6938PSpero Robert C · Kent, WABuilt 1960 · S/N 24-2072N6938ZWerth Lance C · Johnson Lake, NEBuilt 1964 · S/N 25-2682N6940BRegistered aircraftBuilt 1956 · S/N 22-4219N6941DKodysh Peter J · North Ridgeville, OHBuilt 1957 · S/N 22-4869N6941KWinter Gary L · Ocala, FLBuilt 1950 · S/N 20-45N6942PPikes Peak Fliers At Meadowlake Airport LLC · Colorado Springs, COFirst renewal noticeBuilt 1960 · S/N 24-2077N6943AOber John A · Candor, NYBuilt 1979 · S/N 27-7954117N6943BAndrews Joshua T · Lakeview, ORBuilt 1956 · S/N 22-4223N6943KLow And Slow Aviation LLC · Williston, FLS/N 20-52N6943YAce Tomato Co LLC · Daytona Beach, FLBuilt 1969 · S/N 27-4350N6944APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954109N6944YLg Aztec LLC · Boynton Beach, FLBuilt 1969 · S/N 27-4304N6947BB&R Aerial Crop Care Inc · Connell, WABuilt 1957 · S/N 22-4227N6947PHudzinski Joel David · Newaygo, MIBuilt 1960 · S/N 24-2082N6948KTerch Lawrence P Jr · North Pole, AKBuilt 1950 · S/N 20-53N6948PBernard David J · Paris, OHS/N 24-2083N6949BPool Gene E · Anchorage, AKBuilt 1956 · S/N 22-4229N6949KSaverio Gambassi · Bealeton, VABuilt 1950 · S/N 20-54N6949PDepew Kevin I · Everett, WABuilt 1960 · S/N 24-2084N6949ZTide Water Soaring Society Inc · Windsor, VABuilt 1964 · S/N 25-2696N694ABGoldpick Dirtworx LLC · Wasilla, AKBuilt 1957 · S/N 22-5347N694APCook Christopher W · Indian Mound, TNS/N 24-1147N694CRBravo Zulu Aviation Services LLC · Jacksonville, FLBuilt 1978 · S/N 27-7954011N694JSHowell Renny P · Whitehouse, TXS/N 23-1571N694PSSteger Paul M · Locust Grove, GAS/N 23-1732N6950BLudwig Henry H · Fort Worth, TXBuilt 1956 · S/N 22-4238N6950DFaught Jeffrey R · Bismarck, NDS/N 22-4879N6950KGerhold Jeremy R · Rosharon, TXBuilt 1950 · S/N 20-55N6950PRegistered aircraftBuilt 1960 · S/N 24-2085N6951PRossback Jason M · Denver, COBuilt 1960 · S/N 24-2086N6952BWesley Jerry A · Moorland, IAS/N 22-4232N6952KPoor Jeffrey L · Bettles, AKS/N 20-57N6952PBretts Flying Service LLC · Mount Pleasant, MIS/N 24-2087N6952YPorterfield Brian B · Wasilla, AKBuilt 1969 · S/N 27-4316N6953DLambert Hubert D Sr · Lincolnton, NCBuilt 1957 · S/N 22-4882N6953KJessup Robert L · Carson City, NVS/N 20-46N6953PCianciolo Philip H · Yakima, WABuilt 1961 · S/N 24-2088N6954PJcav8 LLC · Cartersville, GABuilt 1960 · S/N 24-2090N6955DGlover Thomas B · Marana, AZFirst renewal noticeBuilt 1957 · S/N 22-4884N6955YN6955y LLC · Knoxville, IABuilt 1969 · S/N 27-4320N6956BBushplane Lab LLC · Wilderville, ORBuilt 1956 · S/N 22-4237P
Back to AD 85-02-05 R1