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.

N1910PWesley Gary J · Moorland, IABuilt 1955 · S/N 22-2657N1911PWalker Raymond Lee · Saint Charles, MIBuilt 1955 · S/N 22-2590N1915PParker Joshua J · Hawley, TXBuilt 1955 · S/N 22-2662N1919PBarnett David K · Brock, TXS/N 22-2666N191AMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 31P-7630012N191NDMoore Aviation Inc · Beaver Falls, PABuilt 1989 · S/N 4495003N1922PNey N Marshall · Kapaau, HIS/N 22-2673N1926PHoudek Dennis E · Roseburg, ORBuilt 1955 · S/N 22-2677N192CSDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 31P-7300138N1934PProulx Michael G · Westhampton, MABuilt 1955 · S/N 22-2685N1937PPro West Air LLC · West Point, UTS/N 22-2688N1940PBrown Gerald M · Menan, IDBuilt 1955 · S/N 22-2691N1945PScotia Aero LLC · Fort Myers, FLS/N 22-2696N1946DArctic Barnabas Ministries · Kenai, AKS/N 27-8054015N1947PSpence Ronald J · Germantown, TNBuilt 1955 · S/N 22-2698N194MLGofly Trading LLC · Opa Locka, FLBuilt 1979 · S/N 27-7954081N1952AKirkendall Clinton I · Arlington, WAS/N 22-746N1956RCorrech Jose Pedro · Cape Coral, FLBuilt 1971 · S/N 39-85N1958PRush Brendon · Merritt Island, FLBuilt 1958 · S/N 22-6008N1959PTanner Greg L · Bend, ORBuilt 1959 · S/N 24419N1961AYoung Connie J · Myrtle Point, ORBuilt 1952 · S/N 20-878N196DBBe Right Back Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 27-7405273N1978AMoore Eugene K · Portsmouth, OHBuilt 1952 · S/N 22-545N198TPDonnelly Thomas E · Salome, AZBuilt 1957 · S/N 22-5625N1996ADidisse Robert T · Mccall, IDBuilt 1953 · S/N 22-1092N1999PByler Dennis E · Wasilla, AKBuilt 1955 · S/N 22-2710N199JTPena Rivera Luis A · Zephyrhills, FLBuilt 1960 · S/N 24-2323N19FNFranzen Chase M · San Diego, CABuilt 1959 · S/N 22-6906N19JCCarney Jerald C · Boise, IDBuilt 1958 · S/N 22-6320N19KCGrays Bay LLC · Warrenton, ORBuilt 1970 · S/N 274516N19RDDennison Ronald Walton Trustee · San Jose, CABuilt 1966 · S/N 24-4597N19SJTurner Christian M · Eastsound, WABuilt 1952 · S/N 22-596N19VSGardner James R · League City, TXBuilt 1963 · S/N 30-144N1GLSmith Alfred N D IV · Lake Wylie, SCBuilt 1967 · S/N 27-3826N1JQJacquot Daniel C · Colorado Springs, COBuilt 1965 · S/N 24-4327N1MEHall James C · Redington Beach, FLBuilt 1967 · S/N 30-1439N1NTDmac Aircraft LLC · Savannah, GABuilt 1964 · S/N 30-262N1SRRensberger Scott C · Lake Jackson, TXBuilt 1962 · S/N 27-2050N1SYPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654186N1WUN1wu LLC · Loganville, GABuilt 1966 · S/N 30-1383N1WYBultron Cristina · Ocala, FLBuilt 1964 · S/N 24-4018N1XACowell Aviation Maintenance LLC · Easley, SCBuilt 1964 · S/N 24-3599N2007P2007 Papa LLC · Fayetteville, GABuilt 1956 · S/N 23-579N200DBDelta Bravo Inc · Davie, FLBuilt 1959 · S/N 24-1080N200DFLijack World Enterprises LLC · Winter Haven, FLS/N 27-4080N200PVPrestwick Chase Inc · Saratoga Springs, NYBuilt 1971 · S/N 31P-64N200RARagan William W · North Kansas City, MOBuilt 1974 · S/N 31P7400198N2018PHauer Clifford Joseph Jr · Woodstock, GABuilt 1956 · S/N 23-590N201NKHelms John Broward II · Bartow, FLBuilt 1972 · S/N 27-4816N2024PYounhorsh Sales LLC · Wilmington, DEBuilt 1956 · S/N 24-1
Back to AD 85-02-05 R1