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.

N13817Conroy Philip L DBA · Colleyville, TXBuilt 1969 · S/N 27-4462N1381PObermueller Frederick J · Milford, NJBuilt 1956 · S/N 23-431N13832Davey Spencer J · Spokane, WAS/N 27-4474N13839Tyler Petroleum Inc · Tyler, TXBuilt 1970 · S/N 27-4480N1384PHanson Roddy L · Butterfield, MNBuilt 1956 · S/N 23-434N13862Reliance Island Inc · Wilmington, DEBuilt 1970 · S/N 27-4500N13865Enzed Aviation Services LLC · Anchorage, AKS/N 27-4503N13882Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1970 · S/N 27-4517N138ABAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3915N13901Masscotte Michael · Mansfield, MABuilt 1970 · S/N 27-4533N1391CSale Reported · Beech Creek, PASale reportedBuilt 1953 · S/N 22-1143N1393CHayden Daniel · North Pole, AKS/N 20-980N1393PSeymour Lori L · Woodstock, GAS/N 23-445N13950Bml Aviation LLC · Arvada, COBuilt 1970 · S/N 27-4567N13966Chesapeake Aviation LLC · Lewes, DEBuilt 1970 · S/N 27-4581N1397CDerr Rodney W · Frackville, PAS/N 22-1154N13980Aileron Buzz LLC · Daytona Beach, FLBuilt 1970 · S/N 27-4598N13982Bray Aviation LLC · Calera, OKBuilt 1970 · S/N 27-4600N13984Smith Aircraft Holdings Inc · Wilmington, DEBuilt 1970 · S/N 27-4602N13987Island Birds Inc · St Thomas, VIBuilt 1971 · S/N 27-4605N13998Granger Vic · Union Grove, ALS/N 27-4616N1399CShankster Thomas G · Aurora, COBuilt 1953 · S/N 22-1150N139CASquires Gregory K · Cedar Park, TXBuilt 1966 · S/N 24-4570N139DBWolfe LLC · Rogers, TXS/N 27-4611N139MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496541N13BRC-140 Co LLC · Pensacola, FLBuilt 1963 · S/N 27-532N13GPWeidner Kevin G · Bunker Hill, ILBuilt 1967 · S/N 30-1535N13TTKlcc Holdings LLC · Boca Raton, FLS/N 27-7554069N14005Delaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-4623N14009Livingston Aviation Inc · Waterloo, IABuilt 1971 · S/N 27-4627N14012Rock Valley College · Rockford, ILBuilt 1971 · S/N 27-4629N14028Stoks Derek R · Canby, MNS/N 27-4689N14036Booth Donald V · Denison, TXBuilt 1971 · S/N 27-4648N14040Island Aviation Inc Trustee · Wilmington, DEBuilt 1971 · S/N 27-4654N1404ALindinger John I · Auburn, NEBuilt 1951 · S/N 22-318N14051Sams Way · Eagle Mountain, UTBuilt 1971 · S/N 27-4663N1405CGbq LLC · New Prague, MNBuilt 1953 · S/N 22-1162N14078Tundra Aviation Inc · Casselton, NDS/N 27-4679N1407CLafreniere Joseph A · Harmony, MNBuilt 1953 · S/N 22-1157N14089Szymanski Tadeusz · Fort Myers, FLS/N 27-4687N1411APetz Matthew M · Sandpoint, IDBuilt 1951 · S/N 22-323N1411CBraden James L · Hillsboro, KSS/N 22-1165N1412CStanley Gregory S · Glasgow, MTBuilt 1953 · S/N 22-1173N14133C I Holdings Ltd Inc · Lewes, DES/N 27-4701N14135Olympiakh LLC · Louisville, KYBuilt 1971 · S/N 27-4702N14138Island Bound LLC · Dunedin, FLS/N 27-4704N14149Ninja Turtle LLC · Orlando, FLBuilt 1971 · S/N 27-4712N1415AHock Wesley S · Holbrook, NEBuilt 1951 · S/N 22-326N14175Box Aviation Inc · Montgomery, ALBuilt 1971 · S/N 27-4739N14183Osborne Donald R · Fairbury, NEBuilt 1971 · S/N 27-4747
Back to AD 85-02-05 R1