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.

N8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 30-1964N8808DDwight Thomas W · Castalia, OHBuilt 1958 · S/N 22-5977N8808YAukes Brian E · Huxley, IABuilt 1969 · S/N 30-1965N8809PPa24 LLC · Painesville, OHBuilt 1965 · S/N 24-4265N880FTFlorida Institute Of Technology · Melbourne, FLBuilt 2000 · S/N 4496033N8810CGroenwegen Bruce C · Snohomish, WABuilt 1953 · S/N 22-1423N8810DNorman Timothy J · Tofte, MNBuilt 1958 · S/N 22-5979N8811YHutchinson Douglas E · Cle Elum, WABuilt 1969 · S/N 30-1968N8812DSowders Darwin G · Robinson, TXBuilt 1958 · S/N 22-5981N8812PRegistered aircraftBuilt 1965 · S/N 24-4267N8812YSpain Air LLC · Dadeville, ALBuilt 1969 · S/N 30-1969N8813PWolcott Kent E · Colorado Springs, COBuilt 1965 · S/N 24-4268N8814YTwin C 14y LLC · Cape Coral, FLBuilt 1969 · S/N 30-1972N8815YBauer Andrew J · Concord, NCBuilt 1969 · S/N 30-1973N8816CNye Brian M · Independence, ORS/N 22-1427N8816LWindy City Soaring Association · Hinckley, ILBuilt 1971 · S/N 25-5321N8817PTei Corp · Kalispell, MTBuilt 1965 · S/N 24-4273N8817YWiehl Thomas K III · Earlysville, VABuilt 1969 · S/N 30-1975N8818CHalligan Austin C · Sidney, NES/N 22-1433N8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 30-1976N8819PN8819p LLC · Boca Raton, FLBuilt 1965 · S/N 24-4275N881FTFlorida Institute Of Technology · Melbourne, FLBuilt 2006 · S/N 4496235N8820CPfaff Kirk J · Jamul, CAS/N 22-1435N8820DMayo Jesse J · Fairbanks, AKBuilt 1958 · S/N 22-5989N8821LSouthern California Soaring Academy Inc · Valencia, CABuilt 1971 · S/N 25-5326N8822DWhite Glen A · Timber, ORS/N 22-5991N8822PCornwell Charles E · Tucson, AZBuilt 1965 · S/N 24-4278N8823YFerrara John M · Newtown, PABuilt 1969 · S/N 30-1981N8824PAzimi Matthew H · Navarre, FLBuilt 1965 · S/N 24-4280N8826DSongster Kevin M · Friend, NEBuilt 1958 · S/N 22-5995N8826PIngalls Equipment LLC · Redlands, CABuilt 1965 · S/N 24-4282N8829CJohnson Steven D · Pardeeville, WIS/N 20-1021N8829DSchwenninger Ronald L · Allison Park, PABuilt 1958 · S/N 22-5999N8829LPotter Everett A · Lansford, NDS/N 255339N8829PInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 24-4285N882ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496317N882FTFlorida Institute Of Technology · Melbourne, FLS/N 4496248N8830LKolb Austin · Phoenixville, PABuilt 1971 · S/N 25-5341N8830PCanon Daniel H · Fruit Cove, FLBuilt 1965 · S/N 24-4286N8831CWright Michael · Hurricane, UTBuilt 1953 · S/N 22-1446N8832CSale Reported · Coulterville, ILSale reported, canceledBuilt 1953 · S/N 22-1444N8832LMid Continent Aircraft Corp · Hayti, MOBuilt 1971 · S/N 25-5343N8832PRoundtree Benjamin · Cass City, MIBuilt 1965 · S/N 24-4288N8833CBall Gerald C · Wasilla, AKS/N 20-1022N8833PRegistered aircraftBuilt 1965 · S/N 24-4289N8833YGagan Samrat LLC · Charlotte, NCBuilt 1969 · S/N 30-1991N8834CSindelar David C · Franklin, KYBuilt 1953 · S/N 22-1453N8835DBrocke Rodney A · Bay City, MIBuilt 1958 · S/N 22-6005N8835PFeller James P · Granite Bay, CABuilt 1965 · S/N 24-4291N8836YLodge Aviation LLC · Lewes, DEBuilt 1969 · S/N 30-1994
Back to AD 85-02-05 R1