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.

N722JWMcintosh Kenneth V · Pleasant Plain, OHBuilt 1962 · S/N 27-2040N7230PFranks Orlan H III · Belton, TXBuilt 1960 · S/N 24-2404N7230YVyas Shiven P · Chino Hills, CABuilt 1964 · S/N 30-254N7232DBrayton Herbert E · Littleton, COS/N 22-5058N7232POntiveros 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-2408N7236DGo North Productions LLC · Glennallen, AKBuilt 1957 · S/N 22-5062N7237DBobinchak Richard G · Sheridan, WYBuilt 1957 · S/N 22-5063N7239DHaning Thomas B · Vian, OKBuilt 1957 · S/N 22-5065N7239PMccabe 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-264N7241DFrisby James A · Palmer, AKBuilt 1957 · S/N 22-5262N72424Magill William J · Moncks Corner, SCS/N 241523N7242ZHamilton Randel L · Quitaque, TXBuilt 1965 · S/N 25-3167N7244PPaden 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-271N7247DTodey Mark A · Rathburn, IABuilt 1957 · S/N 22-5073N7247PRegistration Pending · Caribou, MERegistration pendingBuilt 1960 · S/N 24-2421N7248DLeeuw Timothy P · Dillon, MTBuilt 1957 · S/N 22-5074N7248PN7248p Ltd · Wallkill, NYBuilt 1960 · S/N 24-2424N7248ZAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3177N7249DHansen Larry G · Alliance, NEBuilt 1957 · S/N 22-5075N7249PDavis Scott · Bingham, NEBuilt 1960 · S/N 24-2425N7249YCt Capital LLC · Austin, TXS/N 30-274N724BMJensen William B Jr · Huntington, NYBuilt 1968 · S/N 24-4802N724VSTwin Oaks L & A Ltd · Wilmington, DEBuilt 1957 · S/N 23-869N7250DTrump Roger L · Greenville, OHBuilt 1957 · S/N 22-5076N7250PTrayer Kevin B Trustee · Haslet, TXBuilt 1961 · S/N 24-2426N7252DCox Craig A · Spencerville, OHS/N 22-5078N7252PSchaefer Hugh W · Merrick, NYBuilt 1961 · S/N 24-2428N7252YGuyer James · Billings, MTBuilt 1964 · S/N 30-277N7252ZAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3184N7253YJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1964 · S/N 30-278N7254YSpldkd LLC · New Richmond, WIBuilt 1964 · S/N 30-280N72553Whittom Ron W Jr · Wasilla, AKS/N 23-1031N7255PKubik Rodrick D · Waukee, IAFirst renewal noticeS/N 24-2431N7255ZCentral Ms Soaring Society LLC · Brandon, MSS/N 25-3189N7257DArctic Aero LLC · North Pole, AKBuilt 1957 · S/N 22-5084N7257YRice Clark D · Anaconda, MTFirst renewal noticeBuilt 1964 · S/N 30-290N7258DVandemerwe Rilyn Grant · Durango, COBuilt 1957 · S/N 22-5085N7258YJprg 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-2438
Back to AD 85-02-05 R1