OpenAirDocs.org
AD 82-23-01 R1

Registered aircraft · 3,118

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:82-23-01-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:82-23-01-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.

N7402YN5746u LLC · Dover, DES/N 30-460N7404PWhisler Greg A · Lincoln, NEBuilt 1961 · S/N 24-2589N7404YSlowpoke Air LLC · Palm Harbor, FLBuilt 1964 · S/N 30-463N7405PClassic World Holdings LLC · Wilmington, DES/N 24-2590N7406PAviation Collective LLC · Fort Worth, TXBuilt 1961 · S/N 24-2593N7406YTucker Engineering Associates Inc · Locust, NCS/N 30-465N7408PJeffrey Thomas James · Crestwood, KYBuilt 1961 · S/N 24-2595N7409PPeters Gordon J · Salem, ORBuilt 1961 · S/N 24-2596N7410YDuncan Paul J · Bartlett, TNBuilt 1964 · S/N 30-472N7412PEspyess Aviation LLC · Sylvania, OHBuilt 1961 · S/N 24-2600N7413YOutka Air LLC · Aberdeen, SDBuilt 1964 · S/N 30-475N7416PDavenport Jimmy J · Hayesville, NCBuilt 1961 · S/N 24-2604N7417PWhitewater Aviation Inc · Harrison, OHBuilt 1961 · S/N 24-2605N7418YArmbrister Justin R · Blue Ridge, TXBuilt 1964 · S/N 30-482N7419PBollfrass William Henry III · Rhinelander, WIBuilt 1961 · S/N 24-2607N741TJJackson Thomas R Jr · Spearfish, SDBuilt 1964 · S/N 30-477N7420PTurner Bryan R · Corinth, TXBuilt 1961 · S/N 24-2608N7420YLegacy Aviation Inc · Stuart, FLBuilt 1964 · S/N 30-484N7421YHinkle Anthony Gray · Mineola, TXBuilt 1964 · S/N 30-486N7424PHutcheson Raymond E · Lawrence, INBuilt 1961 · S/N 24-2612N7425PRiffle Christopher B · Altus, OKBuilt 1961 · S/N 24-2613N7426PNehus Christopher J · Camarillo, CABuilt 1961 · S/N 24-2614N7429PSwett Frank M · Zebulon, NCBuilt 1961 · S/N 24-2617N7429YDewitt Troy C · Lake Elmo, MNBuilt 1964 · S/N 30-489N7430PSchlosser Nelson L · Tucson, AZBuilt 1961 · S/N 24-2618N7430YLavion LLC DBA · Zeeland, MIBuilt 1964 · S/N 30-491N7431YRegistration Pending · Lynchburg, VARegistration pendingBuilt 1964 · S/N 30-492N7435YStc Aviation LLC · Wilmington, DEBuilt 1964 · S/N 30-498N7437PJohnson Stephen A · Huffman, TXBuilt 1961 · S/N 24-2626N7438PGreene 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-502N7440PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1961 · S/N 24-2629N7441YHatton Leslie A · Chesapeake, VAS/N 30-504N7442PBalske Curt A · Bedford, TXS/N 24-2631N7442YMy Toys Inc · Jacksonville, FLS/N 30-505N7445PN7445p Flying Club LLC · Union City, CAS/N 24-2634N7445YCherish Aviation LLC · Woodbridge, VABuilt 1964 · S/N 30-509N7446YN7446y Aero LLC · Joplin, MOBuilt 1964 · S/N 30-510N7448PBurshem Ben E · Bay City, WIBuilt 1961 · S/N 24-2637N7449PAshcroft James K · Hurricane, UTBuilt 1961 · S/N 24-2638N7449YMiddle Georgia Aviation Inc · Cochran, GABuilt 1964 · S/N 30-513N7452PTimothy A Cox · Coshocton, OHBuilt 1961 · S/N 24-2641N7453YStratus 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-517N7455YTowns Bobby · Nashville, TNBuilt 1964 · S/N 30-518N7456PInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 24-2646N7457YPeter Prince Aviation Center LLC · Milton, FLBuilt 1964 · S/N 30-520
Back to AD 82-23-01 R1