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.

N8128PScotts Aviation Services LLC · Kalispell, MTBuilt 1962 · S/N 24-3381N812STAk8 Assets LLC · Talkeetna, AKBuilt 1958 · S/N 22-6408N8130DEmbree Walter G · Harrisonburg, VAS/N 22-5621N8130PBenedict Morris D · Kenly, NCBuilt 1962 · S/N 24-3383N8131DThompson Arthur W · Paris, TXBuilt 1957 · S/N 22-5622N8131PCheak Alan S · Peachtree City, GABuilt 1962 · S/N 24-3384N8132CRitel Copter Service Inc · Hudson, IABuilt 1954 · S/N 22-2278N8132PMiller Lawrence A · Winthrop Harbor, ILBuilt 1963 · S/N 24-3385N8132YJessen Eric Carl · La Luz, NMBuilt 1966 · S/N 30-1244N8133PChristy H Spencer · Wetumpka, ALBuilt 1963 · S/N 24-3386N8133YLeaders Bob O · Clear Lake, MNBuilt 1966 · S/N 30-1245N8134CCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 22-2296N8134DDewolf Logan J · Eagle River, AKS/N 22-4778N8135DDickerson Joseph Ra · Anchorage, AKBuilt 1957 · S/N 22-5626N8136PCragg Gordon E · Georgetown, TXBuilt 1963 · S/N 24-3389N8137YSale Reported · Chisago City, MNSale reportedBuilt 1966 · S/N 30-1248N8138DAir Group Inc · Marietta, GABuilt 1958 · S/N 22-5629N8138PFrank Castillo Dds Inc · San Jose, CABuilt 1963 · S/N 24-3392N8139YBuchanan Jason A · Meridian, IDBuilt 1966 · S/N 30-1250N813CNAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496251N8140CMenier Robert · Milltown, WIS/N 22-2285N8140DMckellar John T · Hamburg, NYBuilt 1957 · S/N 22-5631N8141CHoff Fredrick · Twin Falls, IDBuilt 1954 · S/N 22-2286N8141DCasper Glen · Garden City, KSS/N 22-5632N8142DMontague Mark W · Reno, NVBuilt 1957 · S/N 22-5633N8143CNazelrod Eric V · Washington, OKBuilt 1954 · S/N 22-2288N8143P8143 Leasing LLC · Manassas, VABuilt 1963 · S/N 24-3396N8143YTennave LLC · Dublin, OHBuilt 1966 · S/N 30-1254N8144CMusgrove Stacy J · Cunningham, TXBuilt 1954 · S/N 22-2289N8145COlson Caden · Billings, MTS/N 22-2290N8145DJindra Russell L · Glennallen, AKBuilt 1957 · S/N 22-5636N8145PRegistered aircraftBuilt 1963 · S/N 24-3398N8146CClark David A · Plainfield, INBuilt 1954 · S/N 22-2291N8147PHinson Jerry W · Nederland, TXBuilt 1963 · S/N 24-3400N8147YRietz Douglas W · Walla Walla, WABuilt 1966 · S/N 30-1259N814ATDot Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496493N814RCCamelot Express LLC · Naples, FLBuilt 1966 · S/N 301202N8150DBush Pacer LLC · Watauga, TNBuilt 1957 · S/N 22-5641N8150YBok Hans · North Dartmouth, MAFirst renewal noticeBuilt 1966 · S/N 30-1263N81514Soar Above Flight Solutions LLC · Englewood, TNS/N 30-1264N8151DWoods Brian S · Longview, TXBuilt 1957 · S/N 22-5642N8151P63 Comanche LLC · Las Vegas, NVBuilt 1963 · S/N 24-3406N8154JCarter Flygare Inc · Sacramento, CABuilt 1980 · S/N 44-8095020N8154YRawson Aviation LLC · Collinsville, OKBuilt 1966 · S/N 30-1267N8155PSanders Tyler George · Tehachapi, CABuilt 1963 · S/N 24-3410N8155YTalley John T · Clifton, TXS/N 30-1269N8156DMoyle Matthew L · Soldotna, AKBuilt 1957 · S/N 22-5647N8156PVectors West LLC · Coeur D Alene, IDBuilt 1963 · S/N 24-3411N8157YSchmidt Zachary P · Raleigh, NCBuilt 1966 · S/N 30-1270N8158DBates James H · Lakeview, ORBuilt 1957 · S/N 22-5649
Back to AD 85-02-05 R1