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.

N7211PWhite Jordan H · Gold Beach, ORBuilt 1960 · S/N 24-2381N7211YBeers Jason · Girard, OHS/N 30-237N7216YMerriwether David E · Whitesburg, GABuilt 1963 · S/N 30-242N7217PNewman Samuel M · Taylorsville, UTBuilt 1960 · S/N 24-2389N7220PHench Martin Stewart · La Verne, CABuilt 1960 · S/N 24-2392N7221PBuhrmeister Timothy J · Centereach, NYBuilt 1960 · S/N 24-2393N7224YDistel Harold M · Williamson, GABuilt 1964 · S/N 30-246N7225PSuperior Aviation LLC · Metairie, LABuilt 1960 · S/N 24-2399N7225YTwin Cam Holdings LLC · Union City, TNBuilt 1964 · S/N 30-248N7226YGilbert Douglas A · Weston, FLBuilt 1964 · S/N 30-249N7227YClearview Aerial Solutions LLC · Rogersville, TNS/N 30-250N7230PFranks Orlan H III · Belton, TXBuilt 1960 · S/N 24-2404N7230YVyas Shiven P · Chino Hills, CABuilt 1964 · S/N 30-254N7232POntiveros Vicente III · New Braunfels, TXS/N 24-2406N7233YPacific North Air LLC · Portland, ORBuilt 1964 · S/N 30-257N7234PEagle Ag Services LLC · Lees Summit, MOBuilt 1960 · S/N 24-2408N7239PMccabe Gregory · Melbourne Beach, FLBuilt 1960 · S/N 24-2413N723JSAlbertson James M · Westville, FLBuilt 1967 · S/N 30-1512N7240YHodges David S · Reidsville, GABuilt 1964 · S/N 30-264N72424Magill William J · Moncks Corner, SCS/N 241523N7244PPaden Stanley R · Diamond Bar, CABuilt 1961 · S/N 24-2418N7244YJ Mac Aviation Services LLC · Andalusia, ALBuilt 1964 · S/N 30-269N7245PMontcalm Kevin L · Mansfield, LABuilt 1960 · S/N 24-2419N7246PAlex John R · Turner, MTBuilt 1960 · S/N 24-2420N7246YMoyer Thomas L · Fayetteville, GABuilt 1964 · S/N 30-271N7247PRegistration Pending · Caribou, MERegistration pendingBuilt 1960 · S/N 24-2421N7248PN7248p Ltd · Wallkill, NYBuilt 1960 · S/N 24-2424N7249PDavis Scott · Bingham, NEBuilt 1960 · S/N 24-2425N7249YCt Capital LLC · Austin, TXS/N 30-274N724BMJensen William B Jr · Huntington, NYBuilt 1968 · S/N 24-4802N7250PTrayer Kevin B Trustee · Haslet, TXBuilt 1961 · S/N 24-2426N7252PSchaefer Hugh W · Merrick, NYBuilt 1961 · S/N 24-2428N7252YGuyer James · Billings, MTBuilt 1964 · S/N 30-277N7253YJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1964 · S/N 30-278N7254YSpldkd LLC · New Richmond, WIBuilt 1964 · S/N 30-280N7255PKubik Rodrick D · Waukee, IAFirst renewal noticeS/N 24-2431N7257YRice Clark D · Anaconda, MTFirst renewal noticeBuilt 1964 · S/N 30-290N7258YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-291N7260PPotts Leah Marie · Roanoke, VABuilt 1961 · S/N 24-2436N7260YDeuce Aire LLC · Middletown, DEBuilt 1964 · S/N 30-294N7261YKocak Robert G Jr · Peoria, AZBuilt 1964 · S/N 30-295N7262PParker Dennis Scott · Lubbock, TXBuilt 1961 · S/N 24-2438N7263YRag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1964 · S/N 30-298N7264YYogi Air LLC · Wadsworth, OHBuilt 1964 · S/N 30-299N7265Walker Teresa L · Enid, OKBuilt 1963 · S/N 24-3454N7265PQuinlan John H · Claxton, GABuilt 1961 · S/N 24-2441N7266PGrover Donald G · Canby, ORBuilt 1961 · S/N 24-2442N7269PBoucher Bobbi · Fredericksburg, VABuilt 1961 · S/N 24-2445N7272PMellema Tammo · Dalhart, TXBuilt 1961 · S/N 24-2448N7272YToucan Aviation LLC · Bentonville, ARBuilt 1964 · S/N 30-311
Back to AD 82-23-01 R1