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.

N8387YN8387y LLC · Huntsville, ALBuilt 1967 · S/N 30-1542N83896Clifford Aviation LLC · Delta, COS/N 44-8107059N8389PPower Joe D · Seguin, TXS/N 24-3648N838PCGadamic LLC · Fresno, CABuilt 1981 · S/N 448107056N8390KWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 44-8107061N8390PNordwick Thomas J · Uvalde, TXS/N 24-3649N8391PClare Enterprises LLC · Edina, MNBuilt 1964 · S/N 24-3650N8392PVaughn Charles P · Inverness, FLBuilt 1964 · S/N 24-3652N8392YTwinco Flyers LLC · Powell, OHBuilt 1967 · S/N 30-1547N8393PMorrison Brian W · Zanesville, OHBuilt 1964 · S/N 24-3653N8394PHilton Keith A · Galesville, WIBuilt 1964 · S/N 24-3654N8396YPerkins Christopher R · Brackettville, TXBuilt 1967 · S/N 30-1492N8398PBaca Andre · Albuquerque, NMBuilt 1964 · S/N 24-3657N8399YHirschler Andre N · Goshen, INBuilt 1966 · S/N 30-1137N839ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496565N83BFHayssen Arthur H · Sebastopol, CABuilt 1976 · S/N 27-7654171N83BWJohnson Nathan D · Pacheco, CABuilt 1965 · S/N 30-888N83JWCarpe Diem Aviation LLC · Cleveland Heights, OHBuilt 1979 · S/N 27-7954034N83MHStich Michael A · Malvern, OHBuilt 1969 · S/N 27-4302N83WCRegistered aircraftBuilt 1966 · S/N 27-3281N8400PPiper Aviation Museum Foundation Inc · Lock Haven, PABuilt 1963 · S/N 26-3N8401PPrecision Design Inc · Weatherford, OKBuilt 1963 · S/N 26-4N8403PNewell Douglas Bryon · Sedalia, MOBuilt 1964 · S/N 24-3659N8403YBlair Robert A · Red Bluff, CABuilt 1967 · S/N 301552N8404PRegistration Pending · Pittsburgh, PARegistration pending, pending cancellationBuilt 1964 · S/N 24-3660N8405PCarlin Chad P · San Juan Capistron, CAS/N 24-3661N8405YBjorkman Marvin S · Richardson, TXBuilt 1967 · S/N 30-1554N8406YPilgrim Robert C · Cape Coral, FLBuilt 1967 · S/N 30-1556N8407DRegistration Pending · Manassa, CORegistration pendingBuilt 1957 · S/N 22-5660N8407YAwad Aviation LLC · Pooler, GABuilt 1967 · S/N 30-1557N8408DAeromarine Consulting Inc · Brandon, FLS/N 22-5661N8408PBeavers Jeffrey · Metairie, LABuilt 1964 · S/N 24-3664N8409DWinters David W · Gustine, TXBuilt 1957 · S/N 22-5662N8409PStevenson Gregory J · Sutter Creek, CABuilt 1964 · S/N 24-3665N840ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496566N8411DElliott Frank F · Mojave, CABuilt 1957 · S/N 22-5664N8414PRudd Wayne · Basalt, COBuilt 1965 · S/N 26-8N8416YHenze Charles R · Waukee, IABuilt 1967 · S/N 30-1567N8417P250 Dash 4 Associates Ltd · Yellow Springs, OHBuilt 1964 · S/N 24-3669N8418DWright Cecil A · Sanford, FLS/N 22-5668N8418YHefner Joseph C · Mount Pleasant, TXS/N 30-1570N8419YMorrone Richard W · Westerly, RIS/N 30-1572N841ACooper Jerry A · Kennewick, WABuilt 1951 · S/N 22-141N841PSLivin The Dream Aviation LLC · Jupiter, FLBuilt 1967 · S/N 24-4684N8420DAlsworth Glen R Sr · Port Alsworth, AKBuilt 1958 · S/N 22-5675N8421DPutman Bruce C · Leonard, MIBuilt 1957 · S/N 22-5676N8421PWills Terry W · Cedar Park, TXBuilt 1964 · S/N 26-12N8421YKesser Gilbert M · Culpeper, VABuilt 1967 · S/N 30-1575N8422PAnderson William · Creve Coeur, ILBuilt 1964 · S/N 24-3672N8423DKearney Rick G · Amity, PABuilt 1957 · S/N 22-5678
Back to AD 85-02-05 R1