OpenAirDocs.org
AD 81-06-08

Registered aircraft · 2,135

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:81-06-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-06-08')
  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.

N101EBKinneen Simon N · Nome, AKS/N 18-7809028N1022BKustatan Leasing LLC · Nikiski, AKBuilt 1955 · S/N 18-4646N1023KBushak Aviation LLC · Frederick, MDBuilt 1954 · S/N 18-3942N102TCMason Brian L · Eagle River, AKS/N 18-7909038N103VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5817N1049PLamal Thomas K · Fairbanks, AKBuilt 1957 · S/N 18-7816N104CCN104cc LLC · Fredericksburg, TXBuilt 2002 · S/N 9947CCN104JDJnk Equipment LLC · Deer Harbor, WABuilt 1979 · S/N 18-7909077N105CCWyoming Wool Growers Association · Casper, WYBuilt 2002 · S/N 9948CCN105JRRobinson Matthew W · Duncan, OKBuilt 1981 · S/N 18-8109070N106WTSchafer Timothy · Soldotna, AKBuilt 1957 · S/N 18-5943N109TWerba Bruce J · Holy Cross, AKBuilt 1952 · S/N 18-2223N10DUOut There Outfitters LLC · Boise, IDBuilt 1974 · S/N 18-7409071N10PCColver Todd B · Bend, ORBuilt 1965 · S/N 18-8217N10YVDrean Gary T · Rancho Santa Fe, CAS/N 18-8185N1104NNorthern Lights Renewables LLC · Condon, MTS/N 18-7579N1113NSkywagon Aero LLC · Wilmington, DEBuilt 1975 · S/N 18-7509033N1118VBenoit Robert W · Hot Springs, ARS/N 187507N111CSMaster Wings LLC · Princeton, KYBuilt 1969 · S/N 18-8860N1120UNistler Matthew J · Three Forks, MTBuilt 1959 · S/N 186723N1121CSupercub LLC · Ormond Beach, FLBuilt 1953 · S/N 182221N1123EVonimhof Rudolph F · Anchorage, AKBuilt 1979 · S/N 18-7909062N112BFRobbins Dale R Trustee · Medicine Bow, WYBuilt 1968 · S/N 18-8692N112JCHammerle Edward A · Schuyler Lake, NYBuilt 1961 · S/N 18-7704N112KFHiggins Timothy T · Seattle, WAS/N 18-7809134N113PJLang Carl · Harper, TXBuilt 2003 · S/N 9957CCN114Cooper Michael D · North Turner, MEBuilt 1954 · S/N 18-3937N114CMCunningham Terence R · Santa Barbara, CABuilt 1977 · S/N 18-7709146N1155WState Of Alaska · Dillingham, AKS/N AC101N115NSMascher Lynn Scott · Chino Valley, AZBuilt 1970 · S/N 18-8910N1169MSnyder Matthew A · Tok, AKS/N STS 001N116AMMolina Monreal Angel Humberto · Sahuarita, AZS/N 183684N116BHBighorn Airways Inc · Sheridan, WYBuilt 1963 · S/N 18-8041N116FLMerdes Gordon B · Corpus Christi, TXBuilt 1974 · S/N 18-7509029N116NJUsda Forest Service Fepp · Trenton, NJBuilt 1964 · S/N 18-8104N118BZL-Bird LLC · Hood River, ORBuilt 1968 · S/N 18-8647N118CCBodah Douglas · Union City, CABuilt 2002 · S/N 9950CCN119CCCranor Clayton L · North Pole, AKBuilt 1974 · S/N 18-7409126N11ENAircraft Handling LLC · Orlando, FLS/N 18-7940N11YCDompe Thomas W · Melba, IDBuilt 1963 · S/N 18-7988N120ZZCumulus Holdings LLC · Wilmington, DES/N 18-8107N121BBFearon Terrence J · Whitehouse Station, NJBuilt 1963 · S/N 18-7908N12381Bowers James E DBA · Galloway, OHBuilt 1961 · S/N 18-7746N123SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1951 · S/N 181372N1257Burns Richard O · Wasilla, AKBuilt 1963 · S/N 18-7907N125KWilson Nancy J · Grand Rapids, MNBuilt 1976 · S/N 18-7709033N125RWallace Flying Service Inc · Wallace, NEBuilt 1976 · S/N 18-7709017N127CCKiser Aviation LLC · Grottoes, VAS/N 9949CCN128KTClaus Logan D · Chitna, AKBuilt 1975 · S/N 18-7509089N129CCChilds David E · Amber, OKBuilt 2002 · S/N 9951CC
Back to AD 81-06-08