OpenAirDocs.org
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.

N143AKLipinski Glen E · Chandler, AZS/N 15074168N143BBN62689 Inc · Middletown, DES/N 17249516N143CAHaugland Group Aviation LLC · Melville, NYBuilt 2019 · S/N 208B5516N143CPPonzo Christopher A · North Reading, MABuilt 1980 · S/N 18267699N143DBBernard Daniel · GrillyBuilt 1965 · S/N 18256678N143DKReynolds Terry J · Phoenix, AZS/N 15073020N143DROroca Flying Club LLC · Weehawken, NJBuilt 1972 · S/N 17261119N143ELPremiere Aviation Inc · Concord, CABuilt 1979 · S/N 421C0646N143HJHurlburt Ward B IV · Anchorage, AKBuilt 1976 · S/N 18503032N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102N143KMBc Aircraft LLC · Edmonds, WABuilt 1977 · S/N 18265435N143LWMurphy Law Office Pc · Rapid City, SDBuilt 1979 · S/N R18201265N143RMOft7 LLC · Ponca, ARBuilt 1975 · S/N 18263650N143SWBb&D Airways LLC · N Redngtn Bch, FLS/N 310R1856N143TCHarris William D · Topeka, KSBuilt 1962 · S/N 205-0064N143WAWright Air Service Inc · Fairbanks, AKBuilt 2012 · S/N 208B5002N14407Hanson Rod D · Wasilla, AKBuilt 1964 · S/N 185-0676N1440ECreighton Mark · Port Aransas, TXBuilt 1982 · S/N 18268179N1440GSierra-Mike LLC · Springdale, ARS/N 15072955N1440QN1440q LLC · Maybee, MIS/N 15072740N1440SPolkowske Leroy A · La Jara, COBuilt 1976 · S/N 18264988N1441FMartin Michal R · Alva, OKBuilt 1966 · S/N 17254936N1441PN1441p LLC · Pompano Beach, FLBuilt 1973 · S/N 17260993N1441QSale Reported · Franklin, INSale reportedBuilt 1971 · S/N 15072741N1441SHustad Kenneth H · Spokane, WABuilt 1976 · S/N 18264989N1441VYegge David J · Hartland, MIBuilt 1974 · S/N 17263579N1442Viotto Stephen J · Anchorage, AKS/N 52072N1442CMakelbust Michael J · Ames, IABuilt 1977 · S/N 17702728N1442DBiggs James R · Piney Flats, TNBuilt 1973 · S/N 18262106N1442MLorenzo Blake D · Wynne, ARBuilt 1975 · S/N 18264332N1442QDelaware Aviation LLC · Sidney, NYFirst renewal noticeBuilt 1971 · S/N 15072742N1442STodd Philip A · Wendell, NCBuilt 1976 · S/N 18264990N1442UEastern Idaho Flying Club · Idaho Falls, IDBuilt 1976 · S/N 17267109N1443FNelson Harold G · Pendleton, ORBuilt 1966 · S/N 17254938N1443MBahnmiller Dennis D · Highwood, MTBuilt 1975 · S/N 18264333N1443VSchovanec David L · Stuart, FLBuilt 1974 · S/N 17263580N1444ASocha-Leialoha John B · Bellevue, WAS/N P3370308N1444FStrope Byron P · Upland, CABuilt 1966 · S/N 17254939N1444QPelco Aviation Inc · Hampton Bays, NYBuilt 1971 · S/N 15072744N1444SEagle Forestry Services Inc · Monticello, ARBuilt 1976 · S/N 18264992N1444YHiggins Derrick G · Arbyrd, MOBuilt 1962 · S/N 17249144N14455Pinkerton Matthew L · Milton, FLS/N R-172-0143N14457Stone Kenneth R · Cedar Springs, MIBuilt 1966 · S/N R172-0120N1445ESouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 17271004N1445FMorris Loyd Albert · Alvarado, TXBuilt 1966 · S/N 17254940N1445SHagemann Karl B · Santa Clarita, CABuilt 1976 · S/N 18264993N1445YSwartz Steven L · Nashville, TNBuilt 1962 · S/N 17249145N14460Ajkj Aviation LLC · Erie, COS/N R1720121N1446QBeek Dudley Ernest · Miami, FLFirst renewal noticeS/N 15072746N1446YWise Ron · Napoleon, OHBuilt 1962 · S/N 17249146
Back to AD 97-01-13