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.

N6667PKinder Billy Dale · Black Rock, ARBuilt 1960 · S/N 24-1791N666KHMks Aviation Of Mt Airy LLC · Mount Airy, NCBuilt 1972 · S/N 24-5026N666KWRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1972 · S/N 27-7304928N6670YJohnson Lerell L · Sunrise, FLS/N 27-3987N6672PWorkman William R · Tipp City, OHS/N 24-1796N6673PHelldorfer Thomas J · Placerville, CABuilt 1960 · S/N 24-1797N6675ZBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1963 · S/N 25-2280N6679PJmj Aviation LLC · Kalispell, MTBuilt 1960 · S/N 24-1803N667ABlaschka Michael T · Medford, ORFirst renewal noticeBuilt 1951 · S/N 22-69N6680PWilliams Aaron J · Addison, TXBuilt 1960 · S/N 24-1783N6681PHouse Charles D · Tunkhannock, PABuilt 1960 · S/N 24-1805N6682YMcdermott James R · Somerton, AZBuilt 1968 · S/N 27-4003N6684PN6684p LLC · Kalispell, MTBuilt 1960 · S/N 24-1808N6687PShuster Kert · Lanai City, HIBuilt 1960 · S/N 24-1811N6687ZCrop Doctor Aviation Inc · Hill City, KSFirst renewal noticeBuilt 1963 · S/N 25-2300N6688PGarner Charlotte Trustee · Sun Lakes, AZS/N 241525N6689PQuintero Noel · Fontana, CABuilt 1960 · S/N 24-1812N6689ZKingsley Kiman J · Miller, MOS/N 25-2302N6692ZCavanaugh Flying Service Inc · Minden, NEBuilt 1963 · S/N 25-2306N6697PTri County Air Courier LLC · Prosper, TXBuilt 1960 · S/N 24-1822N669ALeppert James J · Dickey, NDBuilt 1951 · S/N 22-71N669PBluhm Daniel A · Gold Hill, ORBuilt 1966 · S/N 24-4507N66ALXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 44-7995200N66FUGreen Steven D · Underhill, VTBuilt 1959 · S/N 22-7167N66JWNowell Borders Equipment G P Inc · Edinburg, TXBuilt 1972 · S/N 27-7304967N66TVDodson International Parts Inc · Rantoul, KSBuilt 1959 · S/N 23-1766N6701BHomolka Marilyn J · Ellsworth, KSS/N 22-4037N6701PHammond Craig D · Lawton, OKBuilt 1960 · S/N 24-1827N6701ZOsher Air LLC · Wallingford, IABuilt 1963 · S/N 25-2308N6702PWakefield Robert M · Winnemucca, NVBuilt 1960 · S/N 24-1828N6703ZSchneider Aerial Inc · Rugby, NDBuilt 1963 · S/N 25-2309N6706BZvacek Dennis E Trustee · Tulsa, OKBuilt 1956 · S/N 22-4038N6706PHadley George M · Boston, MABuilt 1960 · S/N 24-1832N6707ZHood River Soaring Inc · Hood River, ORBuilt 1963 · S/N 25-2316N6708BHartman Darrell W · Fish Lake Valley, NVBuilt 1956 · S/N 22-4041N6709PRzewinski Leonard · Wading River, NYBuilt 1960 · S/N 24-1835N670WBCt Cattle Co LLC · Wichita Falls, TXBuilt 1966 · S/N 30-1053N6710POdell Jeffrey S · Roseville, CABuilt 1960 · S/N 24-1836N6711BJohnson Nathaniel D · Attalla, ALBuilt 1956 · S/N 22-4044N6711PPietroburgo Stephen M · Colville, WABuilt 1960 · S/N 24-1837N6711YAero Services Lc · Woods Cross, UTBuilt 1968 · S/N 27-4039N6711ZWoolslayer Joseph Patrick · Tulsa, OKBuilt 1963 · S/N 25-2320N6715APacific Fleet Aviation LLC · Rochester, NYS/N 27-7954082N6715PFrancis Investment Corp · Tulsa, OKBuilt 1960 · S/N 24-1841N6715ZW5 Land Services LLC · Okeechobee, FLBuilt 1963 · S/N 25-2324N6716YGot Wings LLC · Woodbury, NYBuilt 1968 · S/N 27-4046N6717ZSmith Stephen A · Erwinna, PABuilt 1963 · S/N 25-2273N6718POmalley Wendy · Alameda, CABuilt 1960 · S/N 24-1844N6719ZJourneys Aviation Inc · Boulder, COBuilt 1963 · S/N 25-2328N671MCNorthwestern Michigan College · Traverse City, MIBuilt 2025 · S/N 4496601
Back to AD 85-02-05 R1