OpenAirDocs.org
AD 81-26-01 R1

Registered aircraft · 614

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-26-01-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:81-26-01-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.

N54PDCameron Kenneth D · Montgomery, TXS/N 0180EN550JMNational Aggregates Inc · Malvern, OHBuilt 1982 · S/N 0013EN551CPCity Of Columbus · Columbus, OHBuilt 2006 · S/N 0716FFN553CPCity Of Columbus Division Of Police · Columbus, OHBuilt 2008 · S/N 0715FFN555BHAgricultural Air Services LLC · Jupiter, FLS/N 1200857DN556ACAc Odyssey LLC · Bellevue, WAS/N 870173DN556CPCity Of Columbus · Columbus, OHBuilt 2009 · S/N 713FFN556MHAa Leasing Lp · Kilauea, HIBuilt 1977 · S/N 570143DN557CPCity Of Columbus · Columbus, OHBuilt 2011 · S/N 0717FFN557TSLone Oak Aviation LLC · Stayton, ORBuilt 1976 · S/N 1160037DN569FCFerguson And Sons Constructions LLC · Emmett, IDBuilt 1977 · S/N 570126DN56TWMckee John · Central Point, ORBuilt 1968 · S/N 1180880N571HHHlh Leasing LLC · Wilmington, DEBuilt 1977 · S/N 470125DN572SABank Of Utah Trustee · Salt Lake City, UTBuilt 1987 · S/N 0252EN577BGCactus Construction Inc · Boerne, TXS/N 0176FFN58191Temsco Helicopters Inc · Ketchikan, AKBuilt 1977 · S/N 1070187DN581TGHeliservice LLC · Wilmington, DEBuilt 2012 · S/N 0185FFN58243Aa Leasing Lp · Kilauea, HIS/N 410934DN58251Windward Aviation Inc · Puunene, HIBuilt 1978 · S/N 880317DN58252Windward Aviation Inc · Puunene, HIBuilt 1978 · S/N 1080364DN58337Temsco Helicopters Inc · Ketchikan, AKS/N 1090582DN58341N953xt LLC · Henderson, NVBuilt 1979 · S/N 790544DN58350Siller Helicopters Inc · Yuba City, CABuilt 1979 · S/N 790546DN58415Temsco Helicopters Inc · Ketchikan, AKBuilt 1978 · S/N 480312DN5841ZPuerto Rico Electric Power Authority · San Juan, PRBuilt 1999 · S/N 0135FFN58428Teryjon Aviation Inc · Bluefield, VABuilt 1979 · S/N 1290624DN5842ZLt Aviation LLC · Lexington, KYS/N 0137FFN58431Dodson Larry · Lone Oak, TXBuilt 1979 · S/N 1290647DN58479Usda Aphis Ws Atoc · Cedar City, UTBuilt 1968 · S/N 67-16036N593CK & S Helicopters Inc · Kailua Kona, HIS/N 201EN594DBDeland Air And Sea Brokerage Inc · Deland, FLBuilt 1982 · S/N 1169DN59CPAtomic Eft LLC · Scottsdale, AZBuilt 2008 · S/N 0591EN59SDInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 0019EN5FCSara Helicopters Inc · Wilmington, DEBuilt 1976 · S/N 0787SN600FHFatv LLC · Henderson, NVS/N 0600EN60556Usda Aphis Ws Atoc · Cedar City, UTS/N 0256FFN6062MUsda Aphis Ws Atoc · Cedar City, UTS/N 0262FFN6063PUsda Aphis Ws Atoc · Cedar City, UTS/N 0263FFN6065NUsda Aphis Ws Atoc · Cedar City, UTS/N 0223FFN6068TUsda Aphis Ws Atoc · Cedar City, UTS/N 0215FFN6084UUsda Aphis Ws · Cedar City, UTBuilt 2023 · S/N 0341FFN6100NUsda Aphis Ws Atoc · Cedar City, UTS/N 0216FFN610ESAmarillo Skies LLC · Angleton, TXS/N 1030523SN622PBPope James · Lewiston, IDBuilt 1978 · S/N 880318DN6246WStarfire Aviation LLC · Renton, WABuilt 1968 · S/N 880712N6252FRoxbury John A Jr · Princeton, MNBuilt 1968 · S/N 980735N6295PCaribe Helicopters Inc · Coral Gables, FLBuilt 1972 · S/N 520378SN62UCCbft LLC · Mobile, ALBuilt 1979 · S/N 1090594DN630NBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 0004FN633JHJack Harter Helicopters Inc · Lihue, HIBuilt 1987 · S/N 0230E
Back to AD 81-26-01 R1