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.

N4811YSale Reported · Dover, DESale reportedBuilt 1968 · S/N 25-4592N4811ZClark Ronald L · Marysville, WABuilt 1961 · S/N 22-8380N4812YRc Ag Air LLC · Cairo, MOS/N 25-4594N4813AVon Etten Robert P · Ravena, NYBuilt 1956 · S/N 22-3965N4813ZStanley Daniel P · Kiowa, KSS/N 22-8383N4814YKnerr Joshua D DBA · Tehachapi, CAS/N 25-4597N4815YAdrian Soaring Club Inc · Ypsilanti, MIBuilt 1968 · S/N 25-4567N4815ZRoberson James · Stephenville, TXS/N 22-8385N4816ASullivan Phillip M · Louisville, KYS/N 22-3969N4817YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4601N4818ACampbell Allen G · Sault Sainte Marie, MIBuilt 1956 · S/N 22-3971N4818ZCornell Robert C · Lock Haven, PABuilt 1961 · S/N 22-8389N4819ZWest Coast Air Design LLC · Granada Hills, CAS/N 22-8390N4820ZPumford Thomas E Jr · Bannister, MIBuilt 1961 · S/N 22-8391N4821AMeyer James D · Cheney, KSBuilt 1956 · S/N 22-3974N4822ALybarger Michael L · Hot Springs, ARBuilt 1956 · S/N 22-3975N4823PWilliams Charles S · Pearland, TXS/N 27-389N4825ATodd Gary W · Rogers, OHBuilt 1956 · S/N 22-3978N4825YHall William B · Vincentown, NJBuilt 1968 · S/N 25-4614N4827YThief River Aviation Inc · Thief River Falls, MNBuilt 1968 · S/N 25-4618N4827ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8399N4828ZWidman Ralph W Jr · Lynchburg, OHBuilt 1961 · S/N 22-8400N482EJDavis Douglas L · Everson, WABuilt 1953 · S/N 20-1052N4830ARenick Tyler Cain · Wichita Falls, TXS/N 22-3983N4830ZClements Steven D · Boise, IDBuilt 1961 · S/N 22-8404N4832YStohr Beuford G · Woden, IABuilt 1968 · S/N 25-4626N4833PPacifica LLC · Grand Junction, COS/N 27-401N4834ARegistration Pending · Eagle River, WIRegistration pendingBuilt 1956 · S/N 22-3987N4834ZRoesner David A · Salina, KSBuilt 1961 · S/N 22-8408N4836ASales Joe Haney · Seminole, TXS/N 22-3989N4836ZDewolfe III Everett C · Cumby, TXBuilt 1961 · S/N 22-8410N4838YWagner Nathan D · Dane, WIBuilt 1968 · S/N 25-4634N4839ZMacias-Flores Guadalupe · Garden City, KSBuilt 1961 · S/N 22-8413N4840YDmc Aircraft LLC · Naples, FLBuilt 1968 · S/N 25-4637N4841APiercy Ronald S · Moses Lake, WAS/N 22-3994N4841YBlack Forest Soaring Society · Monument, COS/N 25-4639N4842AHill Steven Douglas · Stoneville, NCBuilt 1956 · S/N 22-3995N4843ANous Air LLC · Yukon, OKBuilt 1956 · S/N 22-3996N4843PSherrill L H · Tucson, AZBuilt 1961 · S/N 27-414N4844ZRegistered aircraftBuilt 1961 · S/N 22-8418N4845AParenteau William · Maple Grove, MNBuilt 1910 · S/N 22-3998N4849AVeblen Raak · Auburn, CABuilt 1956 · S/N 22-4002N4849ZSwope William T · Georgetown, OHS/N 22-8424N4851PTwin Air Assets LLC · Casper, WYBuilt 1961 · S/N 27-424N4851ZNorris Randal E · Cambridge, KSBuilt 1961 · S/N 22-8426N4852AHanrahan Andrew D · Soldotna, AKBuilt 1956 · S/N 22-4005N4853PSwan Aviation Ministries Inc · Baker, FLS/N 27-426N4853ZPileggi James B · Berkeley, CABuilt 1961 · S/N 22-8428N4856AManning Travis J · Reno, NVBuilt 1956 · S/N 22-4012N4856YAgland Air Inc · Beaver Dam, WIBuilt 1968 · S/N 25-4657
Back to AD 85-02-05 R1