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.

N8706CMichel Terry L Trustee · Quincy, WAS/N 22-1364N8706DTolle Chuck G · Deer Creek, OKBuilt 1958 · S/N 22-5887N8706YLund James C · Powder Springs, GABuilt 1969 · S/N 30-1855N8707DOrton Aviation LLC · Walker, MNBuilt 1958 · S/N 22-5888N8708DAnderson Thomas E Trustee · Mason, OHBuilt 1958 · S/N 22-5889N8708PGuyer Vince T · Hancock, IABuilt 1965 · S/N 24-4155N8708YBasso Family Ventures LLC · La Mesa, CABuilt 1969 · S/N 30-1857N870CACarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496127N870GSBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2023 · S/N 4496557N8710PNelson Aircraft Sales LLC · Austin, MNBuilt 1965 · S/N 24-4157N8710YSmith Charles W · Savannah, GABuilt 1969 · S/N 30-1859N8711PInternational Academy Of Dance LLC · Santa Cruz, CABuilt 1965 · S/N 24-4158N8712CCopp Perry T · Adin, CABuilt 1953 · S/N 22-1373N8712DRegistered aircraftBuilt 1958 · S/N 22-5893N8712YBurns William Robert · Niceville, FLBuilt 1969 · S/N 30-1861N8713PWix Hershel L · Wilmington, ILBuilt 1965 · S/N 24-4161N8714DAzevedo Miguel · Trion, GABuilt 1958 · S/N 22-5895N8714PBlanchard Paul R · Florissant, MOBuilt 1965 · S/N 24-4162N8715DKline Linda L · Fountain Hills, AZBuilt 1958 · S/N 22-5896N8715LScott Ts Ag Flyin Inc · Colquitt, GABuilt 1969 · S/N 25-5168N8717CBristow Leonard B · Damar, KSBuilt 1953 · S/N 22-1355N8717YParker Meyers And Roth Inc · Morgan Hill, CABuilt 1969 · S/N 30-1868N8718CHogan Erin P · Grapevine, TXS/N 22-1357N8718DSlaughter James M Jr · Houston, TXBuilt 1958 · S/N 22-5899N8719PAndrofski Joseph B · Waunakee, WIBuilt 1965 · S/N 24-4168N8720PBarry Edward P III · Redlands, CABuilt 1965 · S/N 24-4169N8721PLavergne Rusty P · Denham Springs, LABuilt 1965 · S/N 24-4170N8722CMayhew Oliver C Jr · Blairs, VABuilt 1953 · S/N 20-1011N8722DWirthlin Donald K · Sierra Vista, AZBuilt 1958 · S/N 22-5903N8722PMurphy Josiah I · Jarrettsville, MDS/N 24-4171N8723LMid-Georgia Soaring Association Inc · Monroe, GABuilt 1969 · S/N 25-5180N8723PSima Ronald Scott · Glendale, AZBuilt 1965 · S/N 24-4172N8724DMoe Daniel N · Mukilteo, WABuilt 1958 · S/N 22-5905N8725CDavis Byron J · Anchorage, AKBuilt 1953 · S/N 20-1012N8725PAyoub Michael Kamal · Saint Charles, MOS/N 24-4174N8725YPerkins E G Jr · Greenwood, MSBuilt 1969 · S/N 30-1878N8726CRicco Umberto · Chicago, ILS/N 22-1377N8726DWheeler Corey L · Lakeport, CABuilt 1958 · S/N 22-5907N8727DYoung Carl J · Lubbock, TXS/N 22-5908N8727PWright John L III · San Antonio, TXBuilt 1965 · S/N 24-4176N8727YGriffin John C · Apopka, FLBuilt 1969 · S/N 30-1880N8729CQrh LLC · Bartlesville, OKBuilt 1953 · S/N 22-1381N8729DAdams Raymond L · Big Lake, AKBuilt 1958 · S/N 22-5910N8729PBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 24-4179N8730L2 Broke Pilots LLC · Foley, ALBuilt 1969 · S/N 25-5191N8731DMorrell Eric M · Medford, ORBuilt 1958 · S/N 22-5912N8731YGo Tapa Aero LLC · Wilmington, DEBuilt 1969 · S/N 30-1885N8732DMgs Ventures Ltd · Wilmington, DEBuilt 1958 · S/N 22-5913N8732PComanche Aviation Inc · North Bend, OHBuilt 1965 · S/N 24-4182N8733PSpaulding Rachael K · Saint Johns, FLBuilt 1965 · S/N 24-4183
Back to AD 85-02-05 R1