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.

N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1964 · S/N 30-298N7263ZAnderson Daniel A · Overly, NDBuilt 1965 · S/N 25-3200N7264YYogi Air LLC · Wadsworth, OHBuilt 1964 · S/N 30-299N7265Walker Teresa L · Enid, OKBuilt 1963 · S/N 24-3454N7265PQuinlan John H · Claxton, GABuilt 1961 · S/N 24-2441N7266PGrover Donald G · Canby, ORBuilt 1961 · S/N 24-2442N7269PBoucher Bobbi · Fredericksburg, VABuilt 1961 · S/N 24-2445N7272PMellema Tammo · Dalhart, TXBuilt 1961 · S/N 24-2448N7272YToucan Aviation LLC · Bentonville, ARBuilt 1964 · S/N 30-311N7273PBrice Brandon Scott · Denver, COBuilt 1961 · S/N 24-2449N7274PKeil Ronald B · Lapeer, MIBuilt 1961 · S/N 24-2450N7275YCross John Benjamin · Lake Charles, LABuilt 1964 · S/N 30-314N7277YDouble A Investments Inc · Rowland, NCBuilt 1964 · S/N 30-315N7279YChormicle James R · Littlerock, CABuilt 1964 · S/N 30-317N727DSYso Noz LLC · Grandville, MIBuilt 1958 · S/N 24-276N727LFLanier Equipment Leasing LLC · Gainesville, GABuilt 1978 · S/N 44-7995197N727RMMarkle Robert L Jr · Cranberry Township, PABuilt 1965 · S/N 30-806N727TCSandpiper Air LLC · Dickinson, TXBuilt 1976 · S/N 27-7654107N7281PGuardian Peaks Airways LLC · Portland, ORBuilt 1961 · S/N 24-2458N7281YGo For Flight LLC · Minneapolis, MNBuilt 1964 · S/N 30-319N7282ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1965 · S/N 25-3222N7286YReagan Scott Lllp · Mount Pleasant, SCBuilt 1964 · S/N 30-324N7287PTwo Dot Aircraft LLC · Kalispell, MTBuilt 1961 · S/N 24-2465N7287ZQuality Aviation Inc · Marana, AZBuilt 1965 · S/N 25-3229N7288YN7288y LLC · Manassas, VABuilt 1964 · S/N 30-326N7289ZWerth John F · Hays, KSBuilt 1965 · S/N 25-3232N728KKWeddle Stephen J · Phillips, WIBuilt 1951 · S/N 20-712N7290PFarmland Investments Inc · Mound City, MOBuilt 1961 · S/N 24-2468N7294PMcnamara Pa · Far Hills, NJBuilt 1978 · S/N 27-7854072N7294YTgaap Inc · Dover, DEBuilt 1964 · S/N 30-333N7296ZKolb Duane L · Bison, SDBuilt 1965 · S/N 25-3241N7298ZShenandoah Valley Soaring Inc · Nellysford, VABuilt 1965 · S/N 25-3111N72999Huntington Roger · Galena, AKS/N 22-6507N72ABGlobe Motorcycles Ltd Inc · Pembroke Pines, FLBuilt 1969 · S/N 25-5088N72CVMccullough Wayne L · Greenfield, INBuilt 1958 · S/N 22-6115N72DNPostiglione Daniel · West Babylon, NYBuilt 1971 · S/N 24-5006N72MWStaggs Austin · Cudjoe Key, FLBuilt 1963 · S/N 30-171N72SB72 Sierra Bravo LLC · Allegany, NYBuilt 1971 · S/N 24-4969N7300DClendaniel Randon · Desert Hot Springs, CAS/N 22-5087N7300YAdriatic Holdings LLC · Cheyenne, WYBuilt 1964 · S/N 30-341N7301DGrant Cary · Cave Creek, AZBuilt 1957 · S/N 22-5088N7302YJohnson Robert Daniel · Seabrook, TXBuilt 1964 · S/N 30-345N7303PWeisend Chad · Peru, INBuilt 1961 · S/N 24-2478N7303ZSeminole Flying Soaring Inc · Clermont, FLS/N 25-3247N7304YN3024d LLC · Reno, NVBuilt 1964 · S/N 30-349N7305YRegistered aircraftBuilt 1964 · S/N 30-350N7306DJ S H Farms Inc · Hermiston, ORBuilt 1957 · S/N 22-5093N7306KKutschera Thomas C · Youngsville, NYBuilt 1950 · S/N 20-216N7307DKnight Todd A · Grimes, IAS/N 22-5095N7307XZimmer Chris P · Upham, NDBuilt 1965 · S/N 253251
Back to AD 85-02-05 R1