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.

N5790DJohnston Jeff · Edgewood, NMBuilt 1956 · S/N 22-4466N5791DBrown Todd G · Corvallis, ORBuilt 1956 · S/N 22-4467N5792PLadet William D · Las Vegas, NVS/N 24-871N5796ZJankow Edward W · Clinton Township, MIBuilt 1963 · S/N 22-9647N5797DSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 22-4473N5797YAce Tomato Co LLC · Daytona Beach, FLBuilt 1965 · S/N 27-2927N5798PCiotta Anton Albert · Wallingford, CTBuilt 1959 · S/N 24-878N5799DBusse Charles U · Oakwood Hills, ILBuilt 1956 · S/N 22-4364N5799PMorgan E Neal · San Diego, CABuilt 1959 · S/N 24-879N57AASouth Texas Weather Modification Association · Pleasanton, TXBuilt 1962 · S/N 24-3303N57APHouston William J · Ellensburg, WABuilt 1957 · S/N 23-1110N57DJPasserby Randal K · Mesa, AZS/N 30-1292N5800PCencula Christopher D · Roseville, CABuilt 1959 · S/N 24-880N5802PHass Morgan E · Lyons, ORBuilt 1959 · S/N 24-882N5804PWitt Aviation LLC · Naperville, ILBuilt 1959 · S/N 24-884N5804ZColyer Gregory W · San Rafael, CABuilt 1963 · S/N 22-9657N5805DEasley Clarence E · Pleasanton, KSS/N 22-4480N5805PGrace Family Fellowship Inc · Oklahoma City, OKBuilt 1959 · S/N 24-885N5806YDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1965 · S/N 27-2939N5807PRichter Dickinson Aviation LLC · Moultrie, GABuilt 1959 · S/N 24-887N5807ZBrown Duane A · Middletown, DES/N 22-9662N5809ZLuckett Dennis G · Upland, CABuilt 1963 · S/N 22-9665N580NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496257N580SPWatag Corp Trustee · Wilmington, DEBuilt 1965 · S/N 27-3046N5811PJpl Flyers LLC · Metairie, LABuilt 1959 · S/N 24-891N5813ZSmith Gregory E · White Lake, MIBuilt 1963 · S/N 22-9670N5814DMessinger Donald C · Wasilla, AKBuilt 1956 · S/N 22-4489N5816DTurner Robert E · Talladega, ALBuilt 1956 · S/N 22-4491N5816ZPerdew Paul T · Mcfarland, WIBuilt 1963 · S/N 22-9674N5817ZLamb Matthew P · Edmond, OKBuilt 1963 · S/N 22-9644N5818DCorral Oscar L · Fort Stockton, TXS/N 22-4493N5818YWells John R · Gonzales, TXBuilt 1965 · S/N 27-2965N5819DMiceli Michael J · Frewsburg, NYBuilt 1956 · S/N 22-4494N5819ZCristando Robert J · Wolfeboro, NHBuilt 1963 · S/N 22-9676N581NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496258N5820ZWilson Jonathon D · Breckenridge, MIBuilt 1963 · S/N 22-9677N5822DFranz Stanley E · Yakima, WABuilt 1956 · S/N 22-4497N5822PJstream Lc · Sheridan, WYBuilt 1959 · S/N 24-903N5822ZHogan Gerard T · Rockford, ILBuilt 1963 · S/N 22-9679N5823AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496260N5824DWitthuhn Johnie B · Callaway, NEBuilt 1956 · S/N 22-4499N5824PClaxton Fred E · La Habra, CABuilt 1959 · S/N 24-905N5824YDonahue Sean M · Fort Lauderdale, FLBuilt 1965 · S/N 27-2972N5825PRobles Carlos J · San Jose, CABuilt 1959 · S/N 24-906N5825YTalmage John R · Kalispell, MTS/N 27-2945N5827DNurge Richard · Gilroy, CAS/N 22-4502N5827PTwo Seven Papa LLC · Pueblo, COBuilt 1959 · S/N 24-908N5828DSchulz Lucas H · New Boston, MIBuilt 1956 · S/N 22-4503N582NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496261N5833DBixler Scott E · Rising Fawn, GABuilt 1956 · S/N 22-4509
Back to AD 85-02-05 R1