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.

N9008DMullally Timothy · Callicoon, NYBuilt 1958 · S/N 22-6143N9008PStarnes William H · Eureka Springs, ARBuilt 1966 · S/N 24-4469N9009DHarper Benjamin J · Talkeetna, AKBuilt 1958 · S/N 22-6144N900APhelps Caden M · Salem, ORBuilt 1951 · S/N 22-200N900AMGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N 27-7954014N900BPelczar Kenneth J · San Antonio, TXS/N 22-3452N900DCRognerud Edward J · Rosemount, MNBuilt 1970 · S/N 39-20N900GPPerkins E G Jr · Greenwood, MSBuilt 1966 · S/N 24-4464N900PTGoblirsch Randy J · Sleepy Eye, MNBuilt 1973 · S/N 31P-7400176N900TSMidwest Flying Service Inc · Sheldon, IABuilt 1974 · S/N 27-7405429N900WWBucher Burton · North Chicago, ILBuilt 1966 · S/N 27-3372N9010DGriffin Roger P · Port Clinton, OHBuilt 1958 · S/N 22-6145N9013DDemmler Brian D · Ocean City, MDBuilt 1958 · S/N 22-6148N9013PRegistered aircraftBuilt 1966 · S/N 24-4474N9014PSherback Michael A · Mountain View, CABuilt 1965 · S/N 24-4475N9016PRegistered aircraftBuilt 1966 · S/N 24-4477N9017DGamertsfelder Joe · Midland, TXBuilt 1958 · S/N 22-6152N9019DSale Reported · Cave Creek, AZSale reportedBuilt 1958 · S/N 22-6154N9019PReeves Robert Lincoln · Charlotte, NCBuilt 1966 · S/N 24-4480N901APEvanson Scot A · Monroe, TNFirst renewal noticeS/N 27-7405416N901VWAviation Business Corp · Saint Louis, MOS/N 27-2101N9020DBaker Donald W · China Spring, TXFirst renewal noticeBuilt 1958 · S/N 22-6169N9020PLindsay Terry M · West Hills, CABuilt 1966 · S/N 24-4482N9021PFontenot Monty Jason · Aiken, SCBuilt 1966 · S/N 24-4483N9022PAcc Air Charter Company · Wilmington, DEBuilt 1966 · S/N 24-4484N9023PHand Joseph Michael · Sheboygan Falls, WIBuilt 1966 · S/N 24-4485N9024PBlue Skies Above LLC · Bogart, GABuilt 1966 · S/N 24-4486N90253Wood Roger Weaver · Sale Creek, TNBuilt 1972 · S/N 27-4779N9025PIdeation Machine LLC · Las Vegas, NVS/N 24-4487N9026DCuthbertson Steven M · Van Alstyne, TXBuilt 1958 · S/N 22-6163N9028PBray Nick R Trustee · China Spring, TXBuilt 1966 · S/N 24-4490N9029PEzzell Stephen Mark · Statesville, NCS/N 24-4491N902MTAircraft Trustee Services Inc Trustee · Dover, DES/N 27-8054038N9030PPaso Rio LLC · Bouse, AZS/N 24-4492N9030UPockrus Pat B · Mineral Wells, TXS/N 22-770N9033PMiddletown LLC · Chandler, AZBuilt 1966 · S/N 24-4495N90346Mittelsted John J · Dickinson, TXBuilt 1967 · S/N 27-3604N9034PNational Test Pilot School · Mojave, CABuilt 1966 · S/N 24-4496N9036DKranz Monte L · Eagle Butte, SDBuilt 1958 · S/N 22-6174N9037PJack Ryan Aviation · Woodcliff Lake, NJS/N 24-4500N9038DJones Michael D · Eagle River, AKBuilt 1958 · S/N 22-6176N903KTGarnier Brent A · Fairbanks, AKBuilt 1961 · S/N 22-8882N9041DHamlin Ryan C · Naples, MEBuilt 1958 · S/N 22-6179N9042DGage Ricky D · Lewiston, IDBuilt 1958 · S/N 22-6180N9042PWt Del Pl LLC · Newark, DEBuilt 1966 · S/N 24-4505N9045DLewis Elijah J · Luthersville, GABuilt 1958 · S/N 22-6183N9047DHansen Bailey · Juneau, AKBuilt 1958 · S/N 22-6186N9050PFrisbee Robert P · Mcminnville, ORBuilt 1966 · S/N 24-4515N9051DWaller Raymond S Trustee · Red Oak, IAS/N 22-6191N9051PFerris Tyler S · Pompano Beach, FLBuilt 1966 · S/N 24-4516
Back to AD 85-02-05 R1