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.

N2299CMiller William C · Boise, IDBuilt 1959 · S/N 52334N2299GLewis Frank B · Meeteetse, WYBuilt 1958 · S/N 51599N2299JMclaughlin Edward T · Silverdale, WAS/N 15065499N2299TC And L Outfitters LLC · Everglades City, FLBuilt 1956 · S/N 32520N2299XSturgeon Keith A · Saginaw, TXS/N 337-0199N229ANCalifornia In Nice Inc · San Jose, CABuilt 1982 · S/N 17275587N229BADavila Associates · Dorado, PRBuilt 1975 · S/N 17265585N229CN229c LLC · Holt, MOFirst renewal noticeBuilt 1965 · S/N 18256129N229CSChicostate Aviation LLC · Wilmington, DEBuilt 1960 · S/N 52363N229DKKoerkenmeier James J · Carlyle, ILBuilt 1979 · S/N 15283544N229NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N 17271323N229WWMcgregor Daniel A · Denali Park, AKBuilt 1973 · S/N U20601807N22BZ8k Investments LLC Series Cessna 150 · Perryton, TXBuilt 1968 · S/N 15068198N22CRegistered aircraftBuilt 1958 · S/N 51007N22CBVollstedt Gregory Scott · Anchorage, AKBuilt 1973 · S/N 185-02188N22CFGame Equipment Services LLC · Midland, TXBuilt 1961 · S/N 18253217N22CMDavis Frederich K · Dunbar, PABuilt 1965 · S/N 337-0159N22CVMcginley Donald J · Port Orange, FLBuilt 1973 · S/N 21059974N22DECrawford Edgar A · Locust Grove, GABuilt 1970 · S/N 17259168N22DXHawk Daniel G · Cocoa, FLBuilt 1958 · S/N 51442N22ECDoose Christopher A · Memphis, TNBuilt 1973 · S/N 310Q0732N22FBWilson Travis · Beaver Dam, KYS/N 21060634N22FGState Of California Department Of Fish And Game · Sacramento, CABuilt 1983 · S/N 18504407N22GCSkydive Ky LLC · Cecilia, KYBuilt 1953 · S/N 30532N22GPDunkelburg David L · Milton Freewater, ORBuilt 1963 · S/N 58202N22JNRegistered aircraftBuilt 1979 · S/N 172RG0215N22KWFinn Capital LLC · San Mateo, CABuilt 2015 · S/N 208B5210N22MDewitt Josiah · Renton, WABuilt 1962 · S/N 18253788N22MDHolland Bryan K · Sterling, AKBuilt 1966 · S/N 337-0590N22NEEvmed LLC · Littleton, NCBuilt 1975 · S/N 21060908N22NNInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18263497N22NRJefferson Aviation LLC · Seville, OHBuilt 1974 · S/N 4140497N22PNLingle Gordon D · Gun Barrel City, TXBuilt 1966 · S/N 337-0538N22REStanley Aero Club Inc · Belmont, NCBuilt 1974 · S/N 18263425N22RWDenison Scott E · Gainesville, TXBuilt 1976 · S/N 17267495N22SDGordon Scott K Trustee · Tucson, AZBuilt 1968 · S/N 17700892N22TENv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2007 · S/N 208B1266N22TGChin-Loy Christopher Waynetrustee · Tamarac, FLBuilt 1977 · S/N 21061904N22VFAir Conejos LLC · El Paso, TXBuilt 1978 · S/N P21000106N22W22w LLC · Tacoma, WABuilt 2020 · S/N 208B5614N22WGCorpat Inc · Missoula, MTBuilt 1981 · S/N P21000733N22WREz Enterprises LLC · Montrose, COS/N 18267626N22XXHeath Michael A · Barnet, VTBuilt 1958 · S/N 36982N22ZJSaydun LLC · Richardson, TXS/N F172-0065N23001Henshaw Edward C · Vian, OKBuilt 1968 · S/N 15068672N23009Hopkins Francis · Wilmington, DEBuilt 1968 · S/N 15068675N2300CWasp Air LLC · Hamilton, MTBuilt 1953 · S/N 30600N2300PNess Dana E · Chester, MTS/N 21057746N23012De La Fuente Carlo H · Lompoc, CAS/N 15068676N23015Schalk Rudolph A · Morgan Hill, CABuilt 1968 · S/N 15068678
Back to AD 97-01-13