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.

N7429PSwett Frank M · Zebulon, NCBuilt 1961 · S/N 24-2617N7429YDewitt Troy C · Lake Elmo, MNBuilt 1964 · S/N 30-489N742LTSomid Resources LLC · Choudrant, LABuilt 2020 · S/N 4496495N7430PSchlosser Nelson L · Tucson, AZBuilt 1961 · S/N 24-2618N7430YLavion LLC DBA · Zeeland, MIBuilt 1964 · S/N 30-491N7430ZMayes Brett R · Williams, CABuilt 1965 · S/N 25-3412N7431DWilcox Darrol A · Nenana, AKBuilt 1957 · S/N 22-5190N7431YRegistration Pending · Lynchburg, VARegistration pendingBuilt 1964 · S/N 30-492N7432DBlack Delwyn Joe · Irving, TXBuilt 1957 · S/N 22-5195N7433DPierce Stephan L · Graham, TXBuilt 1957 · S/N 22-5197N7433KMills Randall J · Monroe, MIBuilt 1950 · S/N 20-343N7433ZDas Air Inc · Wilmington, DEBuilt 1965 · S/N 25-3416N7435KHickey Aero Services LLC · White Hills, AZS/N 20-344N7435YStc Aviation LLC · Wilmington, DEBuilt 1964 · S/N 30-498N7435ZShortridge Randall R · Mesa, AZBuilt 1965 · S/N 25-3420N7436CMatanane Roke C · Barrigada, GUBuilt 1976 · S/N 27-7754017N7437DM And E Ventures LLC · Pingree Grove, ILBuilt 1957 · S/N 22-5201N7437PJohnson Stephen A · Huffman, TXBuilt 1961 · S/N 24-2626N7438DSchofield Wayne D · Polson, MTS/N 22-5202N7438PGreene Mike A · Corryton, TNBuilt 1961 · S/N 24-2627N7438YFranklin Aviation Services LLC · Inverness, FLS/N 30-501N7439PLewis Aaron A · Chino, CABuilt 1961 · S/N 24-2628N7439YGoethals Robert M · Silverdale, WABuilt 1964 · S/N 30-502N7440DHibbitts Josiah B · Hartwell, GABuilt 1957 · S/N 22-5204N7440PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1961 · S/N 24-2629N7441YHatton Leslie A · Chesapeake, VAS/N 30-504N7442KLipper Stephen W · Griffin, GABuilt 1950 · S/N 20-353N7442PBalske Curt A · Bedford, TXS/N 24-2631N7442YMy Toys Inc · Jacksonville, FLS/N 30-505N7444DRups Adventure North LLC · Arbor Vitae, WIBuilt 1957 · S/N 22-5208N7445PN7445p Flying Club LLC · Union City, CAS/N 24-2634N7445YCherish Aviation LLC · Woodbridge, VABuilt 1964 · S/N 30-509N7446DNeufeld Bernie T · Dalhart, TXBuilt 1957 · S/N 22-5210N7446YN7446y Aero LLC · Joplin, MOBuilt 1964 · S/N 30-510N7447KNiemyjski Justin S · Franksville, WIBuilt 1950 · S/N 20-358N7448PBurshem Ben E · Bay City, WIBuilt 1961 · S/N 24-2637N7449KBuehler Andrew · Eatonville, WAS/N 20-360N7449PAshcroft James K · Hurricane, UTBuilt 1961 · S/N 24-2638N7449YMiddle Georgia Aviation Inc · Cochran, GABuilt 1964 · S/N 30-513N744AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496242N7450KMatelski Mark T · New Berlin, WIBuilt 1950 · S/N 20-361N7451KHendry Joshua · Carthage, TNBuilt 1950 · S/N 362N7452PTimothy A Cox · Coshocton, OHBuilt 1961 · S/N 24-2641N7453DRomo Blaine Jeffrey · Dillingham, AKS/N 22-5219N7453YStratus Air Services LLC · Punxsutawney, PABuilt 1964 · S/N 30-516N7454PCreation Industries LLC · Middlefield, OHBuilt 1961 · S/N 24-2644N7454YOrthner Aviation LLC · Chattanooga, TNBuilt 1964 · S/N 30-517N7455DD'Amico Joseph J · Mount Ary, MDBuilt 1957 · S/N 22-5221N7455YTowns Bobby · Nashville, TNBuilt 1964 · S/N 30-518N7456PInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 24-2646
Back to AD 85-02-05 R1