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.

N8159PRegistration Pending · Tucson, AZRegistration pendingBuilt 1963 · S/N 24-3414N815ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496533N8160PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1963 · S/N 24-3415N81615Heyl Holdings LLC · Orlando, FLBuilt 1953 · S/N 27-2322N8164PHobbs Phillip E · Matthews, NCBuilt 1963 · S/N 24-3419N8164YBrewer Steven G · Laconia, NHBuilt 1966 · S/N 30-1277N8165PJohnson Warford B II · Ozark, MOBuilt 1963 · S/N 24-3420N8167PDiehl Matthew · Elk River, MNBuilt 1963 · S/N 24-3423N8168PSchrump Donald R · Putnam, CTBuilt 1963 · S/N 24-3424N8169PLudlow Brent G · Murray, UTBuilt 1963 · S/N 24-3425N816ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496535N8170PLock Haven Aircraft Sales · Lock Haven, PABuilt 1963 · S/N 24-3426N8172YKline John C · Wolcottville, INBuilt 1966 · S/N 30-1286N8173YAltitude Aviation Group LLC · Kissimmee, FLS/N 30-1287N8174PIglewski Rudolph Daniel II · Apache Junction, AZBuilt 1963 · S/N 24-3430N8174YStansbury Todd V · Centennial, COS/N 30-1289N8175PCunningham James L · Tucson, AZBuilt 1963 · S/N 24-3431N8176PHundley Jeffrey S · Parker, COBuilt 1963 · S/N 24-3432N817AAnderson Jennifer M · Biggs, CAS/N 22-121N817ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496536N817JBBenham James M · College Station, TXS/N 27-4561N817KBaquero Eric P · New Castle, COBuilt 1963 · S/N 24-3445N8180PGriffin Robert · Middletown, DES/N 24-3436N8180YG2g Aviation LLC · Wray, COBuilt 1966 · S/N 30-1296N8181PTascosa Trail Inc · Gruver, TXBuilt 1963 · S/N 24-3437N8182PFaulkner Ronnie L · Mount Ida, ARBuilt 1963 · S/N 24-3439N8186KBlack Hills Soaring Club Inc · Rapid City, SDBuilt 1960 · S/N 25163N8186YHeiter Aviation Services LLC · Leesburg, INS/N 30-1303N8187HStover James L · Fredericksburg, VABuilt 1980 · S/N 44-8107002N8187PKlein Dale A · Mandan, NDBuilt 1963 · S/N 24-3443N8187YWhite Jack S · Boone, NCFirst renewal noticeBuilt 1966 · S/N 30-1304N8188PPurdy Bryan T · Bryant, ARBuilt 1963 · S/N 24-3444N8188SN156sl LLC · Oldsmar, FLBuilt 1982 · S/N 44-8207012N8188YFly Anytime LLC · Kankakee, ILBuilt 1966 · S/N 30-1305N818CCFlyit LLC · Camas, WAS/N 27-2977N818MJPika Design Inc · Spring Hill, KSS/N 27-2486N818VMReitz Brian C · Tehachapi, CABuilt 1955 · S/N 22-3357N818YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1458N8190CBent James L Jr DBA · Palatine Bridge, NYS/N 22-2295N8191CLee Gerald R · Glennallen, AKBuilt 1953 · S/N 20-1106N8191PN8191p LLC · Snowflake, AZS/N 24-3447N8192YPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 30-1309N8193PFlying Crooner LLC · Orlando, FLBuilt 1963 · S/N 24-3449N8194CWilliams Mark S · Lisbon, OHBuilt 1954 · S/N 22-2299N8194PMarrs Walter Scott · Chino, CAS/N 24-3450N8195PBoddington Aviation LLC · Portland, TXBuilt 1963 · S/N 24-3451N8196CStrout Carl D · Centerburg, OHBuilt 1954 · S/N 22-2301N8196PWorkman Randy · Tipp City, OHBuilt 1963 · S/N 24-3270N8197YTyer Larry E Jr · Newnan, GABuilt 1966 · S/N 30-1316N8198CLee Jesse D · Pierre, SDBuilt 1954 · S/N 22-2303
Back to AD 85-02-05 R1