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.

N20204Bellingham James G · Baltimore, MDBuilt 1977 · S/N 17702644N20207Disheroon Donald · Houston, TXS/N 17261095N20208American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261096N2020GLyon John · Santa Barbara, CABuilt 1958 · S/N 51320N2020QKaravan LLC · Gilford, NHBuilt 2020 · S/N 208B5610N2020XCullman Aviation Inc · Cullman, ALBuilt 1965 · S/N 18256120N2020ZAbrahamson Nicholas P II · Grosse Ile, MIBuilt 1963 · S/N 15059820N20211Lee Cas LLC · Macomb, ILBuilt 1972 · S/N 17261098N20213Valiair Limited Company Trustee · Casper, WYBuilt 1972 · S/N 17261099N20214Bingairman LLC · Newville, PABuilt 1977 · S/N 17702645N20215Northeastern Financial LLC · New Gloucester, MEBuilt 1972 · S/N 17261101N20216Manke Derek E · Canton, GABuilt 1972 · S/N 17261102N20217La Valle Jacque D · Lexington Park, MDBuilt 1977 · S/N 17702646N20218Emporia Flying Club Inc · Emporia, KSBuilt 1972 · S/N 17261104N20219Koenitzer Judson B · Chetek, WIS/N 17261105N2021QHamilton Gregory J · Avon Lake, OHBuilt 1973 · S/N 177RG0421N2021ZMclean Jr Rufus C · Rockingham, NCBuilt 1963 · S/N 15059821N20221Ohair Mark O · Lampasas, TXFirst renewal noticeBuilt 1972 · S/N 177RG0273N20222Coe Douglas R · Roswell, GAS/N 17702647N20223Roberts Stephen Wade · Friendswood, TXBuilt 1977 · S/N 17702648N20225N20225 LLC · Pottsboro, TXBuilt 1972 · S/N 17261110N20226Morris Aero Club · Towaco, NJBuilt 1972 · S/N 17261111N20229Sale Reported · Wilmington, DESale reportedS/N 17702649N20230Cessna 20230 LLC · Windsor, CABuilt 1972 · S/N 17261115N20232Lopez Tail Draggers LLC · Lopez Island, WABuilt 1972 · S/N 17261116N20233Jenkins Robert W · Fredericktown, OHBuilt 1972 · S/N 17261117N20236Safety In Motion Flight Center Inc · Puyallup, WAS/N 17261120N20237Shortway Pilots Inc · Clearfield, PABuilt 1977 · S/N 17702650N20238Valenti Jeffery N · Eastport, NYBuilt 1973 · S/N 17261122N2023XZim Sim LLC · Charleston, SCBuilt 1965 · S/N 18256123N2023YCassero Ronald V · Santa Rosa, CABuilt 1962 · S/N 17249523N20241Aviation 241 Inc · North Lima, OHBuilt 1972 · S/N 17261124N20242Gent John F · Wellman, IABuilt 1972 · S/N 17261125N20243Webb John W · Elkins, WVBuilt 1972 · S/N 17261126N20246Olek Brad · New Richmond, WIBuilt 1972 · S/N 17261127N20247Grace Ellen M · Bloomville, NYBuilt 1972 · S/N 17261128N2024SRegistration Pending · Sublette, KSRegistration pendingS/N R18201285N2024XMahaney Nicholas · Tahlequah, OKBuilt 1965 · S/N 18256124N20250Kooistra Samuel R · Honobia, OKBuilt 1972 · S/N 17261131N20251Granahan Eric J · Burlington, WIBuilt 1972 · S/N 17261132N20252Morino William D · Palos Verdes Est, CABuilt 1981 · S/N 18053183N20259Mackin Robert Michael · Castro Valley, CABuilt 1972 · S/N 17261136N2025QNelson Gerald E · Burlington, WABuilt 1973 · S/N 177RG0425N2025YMarine Resources Inc · Gilbert, AZS/N 17249525N2025ZVgh Holdings LLC · Wilmington, DEBuilt 1963 · S/N 15059825N20262Sherman Aviation Inc · Redmond, ORBuilt 1972 · S/N 17261138N20264Moltz Larry D · Seguin, TXBuilt 1972 · S/N 17261140N20267Knot Grounded Aviation LLC · Napanoch, NYBuilt 1972 · S/N 17261143N20268Fox Two LLC · Camino, CABuilt 1972 · S/N 17261144N2026XGonzales Alvin S · Mount Prospect, ILBuilt 1965 · S/N 18256126
Back to AD 97-01-13