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.

N699DSNimer David K · Malad City, IDBuilt 1953 · S/N 20-951N69AJKolea Leasing LLC · Honolulu, HIBuilt 1966 · S/N 27-3112N69FABeaumont James F · Caldwell, IDS/N 20-139N69FLFlx Holding Co LLC · Boca Raton, FLS/N 27-7654162N69PDDemray William S · Northville, MIBuilt 1960 · S/N 24-1377N69RDKrens Janet E · Purcellville, VABuilt 1963 · S/N 30-183N6DSSmith Dwight K · Canby, ORBuilt 1961 · S/N 22-8898N6UCZborowski Ronald W · Eighty-Four, PABuilt 1975 · S/N 27-7554079N6YLHolman Leasing LLC · Anchorage, AKS/N 301162N6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 30-572N6ZGTta Logistics LLC · Christiansted, VIBuilt 1968 · S/N 27-3872N7000YSlowpoke Air LLC · Palm Harbor, FLBuilt 1966 · S/N 30-1188N7001DOwens Eldon J · Arimo, IDS/N 22-4894N7001KJersey Devil Dusters LLC · Southampton, NJBuilt 1950 · S/N 20-108N7001PPavlusik Tibor · Fort Mill, SCS/N 24-2146N7002KHeinze Gregory L · Little Rock, ARBuilt 1950 · S/N 20-107N7002PMonterey Bay Aviation Inc · Watsonville, CABuilt 1960 · S/N 24-2147N7003BByrd Kyle E · Unionville, MOBuilt 1956 · S/N 22-4253N7003PAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 24-2148N7007KJackson Gary Lynn · Simms, TXBuilt 1950 · S/N 20-112N7007PAden Charles L · Hudson, COBuilt 1960 · S/N 24-2151N7008BMayes Russell F · Farmersville, ILBuilt 1956 · S/N 22-4258N7008YHeather Jordan Flying Services LLC · Port Saint Lucie, FLBuilt 1963 · S/N 30-9N7009DRegistration Pending · Waupaca, WIRegistration pending, pending cancellationBuilt 1957 · S/N 22-4902N7009KRay Tyler D · Wasilla, AKBuilt 1950 · S/N 20-115N700KRStrange Jim · Tyler, TXBuilt 1963 · S/N 30-52N700YAlpha 678 LLC · Newark, DES/N 27-7754076N7010BDurfee Tristan O · Duluth, MNBuilt 1956 · S/N 22-4260N7010KWiechmann Caleb · Prairie City, SDBuilt 1950 · S/N 20-116N7010PJuliett Tango LLC · West Rutland, VTBuilt 1960 · S/N 24-2154N7010YBrown William C Jr · Northville, MIBuilt 1963 · S/N 30-11N7011BFuller Eddy A · Madras, ORBuilt 1956 · S/N 22-4262N7011DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1957 · S/N 22-4904N7011KYoung Carl Jason · Lubbock, TXBuilt 1950 · S/N 20-117N7011PJapikse Bert · Pawleys Island, SCBuilt 1960 · S/N 24-2156N7012DBarlow Jason P · Brighton, COBuilt 1957 · S/N 22-4905N7012KBoggasch Marie Sophie · Anchorage, AKS/N 20-118N7012YBooher Greg F · Livingston, TNBuilt 1963 · S/N 30-13N7013PShumock Craig A · Moss Point, MSS/N 24-2159N7013YHubbard James E · Dover, OHS/N 30-14N7014PRyan John David · Fort Rucker, ALBuilt 1960 · S/N 24-2162N7014ZBarrett Jane T · Tehachapi, CABuilt 1964 · S/N 25-2768N7016BUnable Direct LLC · Kalispell, MTS/N 22-4267N7016PSgroi Eric A · Wentzville, MOS/N 24-2163N7017PDewey J Levie P C · Chino Valley, AZBuilt 1960 · S/N 24-2164N7017YMccormick Royce DBA · Seminole, TXBuilt 1963 · S/N 30-18N7017ZZimmer Chris P · Upham, NDBuilt 1964 · S/N 25-2772N7018DHoeksel Michael J · Poplar Grove, ILBuilt 1957 · S/N 22-4911N7018KWilliams Kiplin S · Midland, NCS/N 20-123N7019BRed Baron LLC · Middletown, DES/N 22-4270
Back to AD 85-02-05 R1