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.

N8911CKing Michael A · Eddyville, IABuilt 1953 · S/N 22-1520N8911DPunt Eric · Wasilla, AKBuilt 1958 · S/N 22-6067N8911PVarga Craig S · Chino Valley, AZBuilt 1966 · S/N 24-4366N8912DParris Michael D · Rockport, TXFirst renewal noticeS/N 22-6068N8912PPotts John L · Enterprise, ALBuilt 1966 · S/N 24-4367N8913CGuess Gerald B · Hernando, FLBuilt 1953 · S/N 22-1512N8913DBrick H Paul · Pomerene, AZBuilt 1958 · S/N 22-6069N8914DPieper Michael D · Chandler, OKBuilt 1958 · S/N 22-6097N8914YHarris William M · Christiansburg, VABuilt 1970 · S/N 39-71N8915PLegacy Aviation Mid-Michigan LLC · Kalamazoo, MIBuilt 1966 · S/N 24-4370N8917PLogsdon James C · Hanford, CABuilt 1966 · S/N 24-4372N8917YHigh Flyers Inc · Jackson, TNBuilt 1970 · S/N 39-76N8918DPapalote Ranches LLC · Missoula, MTBuilt 1958 · S/N 22-6075N8919CMissionary Flight Training Inc · Hobe Sound, FLS/N 22-1517N8919DLuallin Randy D · Hot Springs, SDBuilt 1958 · S/N 22-6076N8919PHealey Patrick T · Tucson, AZBuilt 1966 · S/N 24-4374N891MDCharbonneau John E · Manhattan, KSBuilt 1960 · S/N 24-2045N891NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 4496555N8920DReese Larry H · Raytown, MOS/N 22-6077N8921DPetterson Jason G · Albert Lea, MNBuilt 1958 · S/N 22-6078N8921POwens Gregory E · Kendallville, INBuilt 1966 · S/N 24-4377N8922DHassell Clark R · Ketchikan, AKBuilt 1958 · S/N 22-6079N8923DWood Rhonda R · Livermore, CABuilt 1958 · S/N 22-6080N8924CHaines Delmar W · Rolla, MOBuilt 1953 · S/N 22-1519N8924DHickey Aero Services LLC · White Hills, AZS/N 22-6081N8924YPrestininzi Robert Anthony · Fort Mill, SCBuilt 1969 · S/N 30-1997N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381N8925YBlue Sky Adventures LLC · Hanover, PAS/N 39-81N8926DPlanes & Things Inc · Collinsville, OKBuilt 1958 · S/N 22-6083N8926PGallagher Derek P · O Fallon, ILS/N 24-4382N8928CGiber Kristofor D · Manvel, TXBuilt 1953 · S/N 22-1521N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384N892NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 4496556N892RCSmw-Cjh Corp · Wilmington, DEBuilt 1966 · S/N 24-4379N8930DBeverly Lester E · Shepherd, TXS/N 22-6088N8931PDuncan Michael J · Cordova, TNBuilt 1966 · S/N 24-4387N8932DRegistration Pending · Caldwell, IDRegistration pendingBuilt 1958 · S/N 22-6090N8932P260b LLC · San Diego, CABuilt 1966 · S/N 24-4388N8933DGrandy Leland P · Rock Springs, WYS/N 22-6091N8934CHandel Patrick A · Wautoma, WIBuilt 1953 · S/N 22-1532N8934PNermernuh LLC · Chester, CTBuilt 1966 · S/N 24-4390N8934YFuller John M · Minden, NVBuilt 1971 · S/N 39-95N8936PGesenhues Bernard J · Canton, OHBuilt 1966 · S/N 24-4392N8937DBrunner Steve W · Mission Viejo, CABuilt 1958 · S/N 22-6099N8937LHood River Soaring · Hood River, ORBuilt 1971 · S/N 25-5402N8938YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1971 · S/N 39-99N8939LWestern Carolina Ag Air Inc · Catawba, NCBuilt 1971 · S/N 25-5404N893NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 4496505N8940CDyda Wendy · Cassopolis, MIS/N 22-1539N8940PDavie Andrew S · Stony Point, NYBuilt 1966 · S/N 24-4396
Back to AD 85-02-05 R1