AD 97-01-13

Registered aircraft · 54,837

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

N1764CRyan Michael · Gillette, WYS/N 30464N1764VGross John F · Winthrop, MEBuilt 1974 · S/N 17263743N1764XLeschber Larry · Hutto, TXBuilt 1975 · S/N 21060785N17651Basler Turbo Conversions LLC · Oshkosh, WIS/N R172-0137N1765FKohler Daniel J · Mapleton, ORS/N 17255160N1765MFlying Cow LLC · Syracuse, NYBuilt 1975 · S/N 18264430N1765RPlane Pro Aviation LLC · Shelby, NCBuilt 1978 · S/N R18200553N1766MN1776m LLC · Panama City, FLBuilt 1975 · S/N 18264431N1766VCode4 Ventures Inc DBA · Waynesboro, VABuilt 1974 · S/N 17263744N1767MAnderson Thomas C Trustee · Sun City West, AZBuilt 1975 · S/N 18264432N1767RHamel David A · Klamath Falls, ORBuilt 1974 · S/N 18502487N1768ERoyal Air Freight Inc · Waterford, MIBuilt 1978 · S/N 310R1566N1768MWyoming Valley Air LLC · Old Forge, PAS/N 33701368N1768QHarper John T · Fairfield, OHBuilt 1971 · S/N 15073068N1768VBrown Craig D · Fort Wayne, INBuilt 1974 · S/N 17263745N1768ZMoskowitz Craig B · Sheffield, MABuilt 1963 · S/N 336-0068N1769QPmn Enterprises LLC · Fremont, WIBuilt 1971 · S/N 15073069N1769RCt Aviation LLC · Waverly, NEBuilt 1974 · S/N 18502489N176EAHeath Mark R · Radisson, WIS/N R172-3440N176ERSkywarrior Flight Training LLC · Pensacola, FLS/N 17269507N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135N176TCRedtail Cirrus LLC · Boise, IDBuilt 1979 · S/N 18503814N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383N1770RRegistered aircraftBuilt 1974 · S/N 18502490N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791N1771MGaley Matthew Blake · Greenwood, MSBuilt 1975 · S/N 18264433N1772FTia Aviation LLC · Hot Springs, ARBuilt 1966 · S/N 17255167N1773BBaney Robert P · Philipsburg, PABuilt 1977 · S/N 17702730N1773FRegistration Pending · Jasper, ALRegistration pendingBuilt 1966 · S/N 17255168N1773RAsher Robert P · Oregon City, ORBuilt 1978 · S/N R18200554N1773ZMcclay David H · Lagrande, ORBuilt 1963 · S/N 336-0073N1774CStol LLC · Fort Wayne, INBuilt 1953 · S/N 30474N1774DDj Brandt LLC · Cedar City, UTS/N 17702028N1774FBarnstormers Aero Services Inc · Lompoc, CABuilt 1966 · S/N 17255169N1774HPeacock Bruce M · Mendon, VTBuilt 1980 · S/N 18267507N1774VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263747N1775QBrooks Timothy J · Oshkosh, WIS/N 15073075N1775RAnderson Lenny R · King Salmon, AKBuilt 1974 · S/N 18502494N1777RKnur Ronald Glen · Elizabeth City, NCBuilt 1978 · S/N R18200555N1778FBlake Brian R · Irvine, CABuilt 1966 · S/N 17255173N1778MSeitz David C · Gordonville, TXS/N 21061958N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378N1779MBlagg Kevin · Dumas, ARBuilt 1975 · S/N 18264439N1779ZLewis Lionel · Tacoma, WABuilt 1963 · S/N 336-0079N177AWolter Aviation LLC · Charleston, SCBuilt 1975 · S/N 17702284N177AAKnowles Mark A · Gun Barrel City, TXBuilt 1975 · S/N 177RG0765N177AMAdler A Michael · Bend, ORBuilt 1976 · S/N 177RG0941N177APThunderbird Aviation LLC · Littleton, COBuilt 1972 · S/N 177RG0304N177ARHull Jared Gene · Redondo Beach, CABuilt 1975 · S/N 177RG0782
Back to AD 97-01-13