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.

N5243ZJinkins Richard D · Rewey, WIS/N 22-8925N5246PYoyodyne Group Inc · Wilmington, DES/N 24-277N5247ZBard Alexander T · Portland, ORS/N 22-8930N5248PKnox Edward R · Gulfport, MSBuilt 1958 · S/N 24-279N5248ZTurner William J · Twentynine Palms, CABuilt 1961 · S/N 22-8931N5249ZCreger Paul L Jr · Springport, MIBuilt 1961 · S/N 22-8933N5251PTaflinger Bradley P · Clarkdale, AZS/N 24-283N5252PBrannan Andrew · Texarkana, ARBuilt 1958 · S/N 24-284N5252ZLamb Steve E · Big Bear City, CABuilt 1961 · S/N 22-8936N5253ALet Industries LLC · Lewes, DES/N 27-7654058N5253PSale Reported · Greeley, COSale reported, pending cancellationS/N 24-285N5254ZPongracz Lajos Janos · San Antonio, TXBuilt 1961 · S/N 22-8939N5255ZGeorge James C · Lenoir, NCBuilt 1961 · S/N 22-8940N5256ZKirkpatrick Theodore J · Gwinn, MIBuilt 1961 · S/N 22-8941N5257PAero Nautics Inc · Cheyenne, WYS/N 24-289N5258PMosley Hardy · Elko, NVBuilt 1958 · S/N 24-290N5259PPacheco Carlos Antonio · Yuma, AZBuilt 1958 · S/N 24-293N525JFMoray Eel LLC · Vail, AZS/N 24-4905N5260ZBerreman Jeffrey P · Yakima, WABuilt 1961 · S/N 22-8945N5261PMon-Dak Consulting Inc · Plentywood, MTFirst renewal noticeBuilt 1958 · S/N 24-297N5261ZKnight Lynn L · Pineville, LAFirst renewal noticeBuilt 1961 · S/N 22-8948N5263ZWilkins Jerry D · Toledo, WABuilt 1961 · S/N 22-8950N5264PBohmer James F · Tulsa, OKS/N 24-300N5269YFlying K Aviation LLC · Quinlan, TXS/N 27-2334N5271ZElliot Kirk R · Tulsa, OKBuilt 1961 · S/N 22-8963N5272AWelch Kevin R · Hartland, WIBuilt 1961 · S/N 23-2019N5272PBombach James · Katy, TXBuilt 1958 · S/N 24-311N5272ZScheda Mark R · Brockport, NYBuilt 1961 · S/N 22-8965N5273PSouthern View Energy Inc · Lula, GABuilt 1958 · S/N 24-312N5274ZKotek Steven G · Sparta, WIBuilt 1961 · S/N 22-8967N5275ZRobertson James W · Cashmere, WABuilt 1961 · S/N 22-8968N5278PRoebuck David M · Hamilton, GABuilt 1958 · S/N 24-317N527JFBonnell Kenneth M · Ormond Beach, FLS/N 22-5755N5281PNardini Michael A · Dayton, OHS/N 24-320N5283PGomes Andrew Jose · Arlington, TXBuilt 1958 · S/N 24-324N5283ZRegistered aircraftBuilt 1961 · S/N 22-8978N5284ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8980N5287PFogleman Brian L · Stonewall, LABuilt 1958 · S/N 24-326N5288ZSimmons Joshua I · Crescent City, CAS/N 22-8984N5289JHansen Larry G · Alliance, NES/N 22-654N5289PVaughan Michael P · Northbridge, MABuilt 1958 · S/N 24-328N5289ZHenson Robert A · Mcloud, OKS/N 22-8985N5290PRegistered aircraftBuilt 1958 · S/N 24-330N5290ZColeman Kyle M · Sisters, ORBuilt 1961 · S/N 22-8986N5291PBlack Randall D · Goodyear, AZBuilt 1958 · S/N 24-331N5291ZBay Area Recreational Flyers LLC · Midland, MIBuilt 1961 · S/N 22-8989N5292PBrooksby Blake L · Pahrump, NVS/N 24-332N5292ZHayes David A · Steward, ILBuilt 1961 · S/N 22-8992N5294ZMorpeth Dorinda · Fortson, GABuilt 1961 · S/N 22-8994N5295ZFawcett Debra K · Baraboo, WIBuilt 1961 · S/N 22-8995
Back to AD 85-02-05 R1