OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,921

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.

N2923PEckelbarger George R · Zanesville, OHBuilt 1955 · S/N 22-3191N2927ZDensmore Jerry L · Rapid City, SDBuilt 1959 · S/N 22-6898N2929TTampa Bay Flying Club Corp · Tampa, FLS/N 22-9630N292NDChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496023N292PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 4496116N292REStructure Inc · Neenah, WIBuilt 1965 · S/N 30-768N2935ZTittle James L · Pembine, WIBuilt 1959 · S/N 22-6907N2936ZSzostak Edward M · San Diego, CABuilt 1959 · S/N 22-6908N2937PSmith Caleb · Wasilla, AKBuilt 1955 · S/N 22-3206N2939ZWozniak Robert Frank Jr · Sparrows Point, MDBuilt 1959 · S/N 22-6911N293NDChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496028N2941PWeddle Curtis Eugene · Iowa Park, TXBuilt 1955 · S/N 22-3210N2942ZHolloway Johnnie M · Laurel Hill, NCBuilt 1959 · S/N 22-6914N2943PDriscoll Patrick J · Caldwell, IDBuilt 1955 · S/N 22-3212N2946PClassic Aircraft LLC · South Bend, INBuilt 1955 · S/N 22-3216N2947Moran M Michael · Chico, CAS/N 24-4681N2947PWhite Hat Repair LLC · Greenleaf, IDBuilt 1955 · S/N 22-3219N2948PMurdock Seth A · Dayton, WAS/N 22-3220N294BTPiper Aircraft Inc · Vero Beach, FLS/N 4496658N2950AInnoutaero LLC · Stockton, CAS/N 44-7995315N2950ZLand Olin Franklin Jr · Baton Rouge, LABuilt 1959 · S/N 22-6923N2951ZToscano Bruce A · Colfax, WABuilt 1959 · S/N 22-6924N2952PTrue Carl B · Avalon, CABuilt 1955 · S/N 22-3224N2953ZEverette John H · Garner, NCBuilt 1959 · S/N 22-6926N2954ZBarkley Terry W · Lakeside, ORBuilt 1959 · S/N 22-6927N2957PArwine James L · Waxahachie, TXBuilt 1955 · S/N 22-3230N2958ZBryce Brad W · Lewis Center, OHBuilt 1959 · S/N 22-6931N295SBChagres Aero LLC · Albuquerque, NMBuilt 1979 · S/N 27-7954091N2960PBrown Daniel A · Gettysburg, PABuilt 1955 · S/N 22-3233N2960ZHuff Justin · Central, SCS/N 22-6934N2961PRegistered aircraftBuilt 1955 · S/N 22-3234N2966ZKieffer William · Chillicothe, MOS/N 22-6940N2967DCalifornia In Nice Inc · San Jose, CABuilt 1979 · S/N 44-7995321N2967ZChance Carl R · Victoria, TXS/N 22-6941N2968PRankin Kevin · Maryville, MOBuilt 1955 · S/N 22-3242N2968ZKuebler Terry T · Gahanna, OHFirst renewal noticeBuilt 1959 · S/N 22-6943N2970PWilson Julie · Prineville, ORBuilt 1955 · S/N 22-3244N2971PRinglein Thomas · Mokelumne Hill, CAS/N 22-3246N2971ZTodorov Krasimir · San Diego, CABuilt 1959 · S/N 22-6946N2973PHauser Nathan S · Newark, DES/N 22-3248N2974PMiller Daniel F · Grain Valley, MOBuilt 1955 · S/N 22-3249N2975ZHesse Paul William · Oxford, NCBuilt 1959 · S/N 22-6949N298NDNational Training 1 LLC · Wilmington, DEBuilt 2001 · S/N 4496085N299NDNational Training 1 LLC · Wilmington, DEBuilt 2001 · S/N 4496077N299RMGulf Atlantic Airways Inc · Gainesville, FLBuilt 1979 · S/N 27-8054024N29AHRiseaero LLC · Florence, SCS/N 27-398N29BJMax Total Time LLC · Lufkin, TXBuilt 1958 · S/N 24-398N29SCBrown Sherrie C · Cushing, OKBuilt 1962 · S/N 24-3125N2ABBailey Richard T · Oregon City, ORBuilt 1960 · S/N 24-1941N2DVLewis Paul A · Spring, TXBuilt 1960 · S/N 24-1679
Back to AD 85-02-05 R1