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.

N4310PChimera Air Inc · Maumee, OHBuilt 1959 · S/N 23-1811N4311PRitchie Glenn R · King George, VAS/N 23-1812N4312YWhittom Ron W Jr · Wasilla, AKS/N 23-2036N4313ARikansrud Eric M · Saint Petersburg, FLBuilt 1956 · S/N 22-3665N4316AHvizdak George D · Colliers, WVBuilt 1956 · S/N 22-3668N4316USkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 4496119N431ABAirtrust LLC - 18 - Series 18 Trustee · Sheridan, WYS/N 24-4156N4320AKnutson Daniel T · Lodi, WIS/N 22-3672N4321YSchuermann Chris L · Sand Springs, OKBuilt 1965 · S/N 27-607N4322TKing Kong Broadcasting Inc · Las Vegas, NVBuilt 1964 · S/N 27-2524N4327ACasten Scot R · Vernonia, ORBuilt 1956 · S/N 22-3682N4328AHubert Matthew J · Fremont Center, NYBuilt 1956 · S/N 22-3683N4329FStrathman Aerial Spraying LLC · Axtell, KSBuilt 1980 · S/N 36-8060009N4329YDetert Bradley · Valparaiso, INBuilt 1966 · S/N 27-619N4331YOdonnell Daniel V · Dover, DEBuilt 1968 · S/N 25-4821N4332AButterfield Robert S · Shelbyville, INBuilt 1956 · S/N 22-3687N4333PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1959 · S/N 23-1834N4333YEvergreen Soaring Inc · Lynnwood, WABuilt 1968 · S/N 25-4824N4334ANorrix James J · Elk River, MNBuilt 1956 · S/N 22-3689N4334PWelke Aviation Inc · St James, MIBuilt 1959 · S/N 23-1835N4335YTexas Soaring Association Inc · Midlothian, TXS/N 25-4827N4336APutney Bruce N · Midlothian, TXBuilt 1956 · S/N 22-3691N4337YJourneys Aviation Inc · Boulder, COBuilt 1968 · S/N 25-4830N433DBBarnes Creek Drilling LLC · Columbia, MSBuilt 1974 · S/N 31P-7400228N433PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496063N4344AMccarthy James L · Anchorage, AKBuilt 1956 · S/N 22-3700N4346ADeakyne Carl · Rehoboth Beach, DEBuilt 1956 · S/N 22-3702N434BBElgin Engineering LLC · Arlington, TXBuilt 1966 · S/N 24-4536N434PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496064N4352ABrito Angelo M · Dillingham, AKS/N 22-3708N4353AVinson David L · Mc Alpin, FLBuilt 1956 · S/N 22-3709N4354PApache Twin Rental LLC · Harrisonville, MOBuilt 1960 · S/N 23-1854N4355ABurrows Aviation LLC · Deer Park, WABuilt 1956 · S/N 22-3711N4355PCrew Sourcing Inc · Wilmington, DES/N 23-1855N4357PWatkins Lowry Jr · Louisville, KYBuilt 1959 · S/N 23-1857N4358ACarruthers Steven L · Livingston, TNBuilt 1956 · S/N 22-3714N4358PQualitair LLC Trustee · MichelstadtBuilt 1959 · S/N 23-1858N435PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496070N4362YBarrett Jane T · Tehachapi, CABuilt 1969 · S/N 25-4868N4363ASchulz Florian · Anchorage, AKBuilt 1956 · S/N 22-3715N4364APapp Frank J · Fort Mohave, AZS/N 22-3716N4369AWinston William A · Bremo Bluff, VABuilt 1956 · S/N 22-3722N436PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496079N436SCAb Prop Plane I LLC · Metairie, LABuilt 2014 · S/N 4496362N4373PMartin Vernon W · Peoria Heights, ILBuilt 1960 · S/N 23-1874N4374PDodson International Parts Inc · Rantoul, KSBuilt 1960 · S/N 23-1880N437SCAb Prop Plane I LLC · Metairie, LABuilt 2014 · S/N 4496363N4381PChase 13 LLC · Wilmington, DES/N 23-1889N43838Rodelsperger Robert · Charleston, SCS/N 27-4334N4383PBeard Michael L · Marble Hill, MOS/N 23-1893
Back to AD 85-02-05 R1