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.

N30546Brady Dennis J Jr · Chesterfield, MOBuilt 1968 · S/N 17701318N30547Wright Thomas L · Clyde, OHBuilt 1968 · S/N 17701319N30549Lad Custom Publishing Inc · Buford, GABuilt 1973 · S/N 21059932N3054EPrinceton Flying Club Inc · Wilmington, DEBuilt 1978 · S/N 17271421N3054FAirlaska LLC · Gustavus, AKS/N 18257154N3054XHeidt Daniel A · Opelika, ALBuilt 1966 · S/N 15064454N30553Jfe LLC · Flossmoor, ILBuilt 1968 · S/N 17701322N30556Amundson Clyde E · Poplar Grove, ILBuilt 1968 · S/N 17701324N30557Wilson Thomas L · Sheboygan, WIBuilt 1968 · S/N 17701325N3055XChickasha Wings Inc · Chickasha, OKBuilt 1966 · S/N 15064455N30565Flowings LLC · Orlando, FLBuilt 1968 · S/N 17701331N30567Sale Reported · West Liberty, KYSale reportedBuilt 1968 · S/N 17701332N3056JRegistration Pending · Jackson, MIRegistration pendingBuilt 1965 · S/N 15061156N3056USchans Richard L Sr · New Bern, NCBuilt 1963 · S/N 17250656N3056XSmith Chelsea R · Louisville, KYBuilt 1966 · S/N 15064456N3056YBardack Barry L Trustee · El Cajon, CABuilt 1962 · S/N 18254056N30570Gallacher Mark A · Salem, UTBuilt 1968 · S/N 17701333N30571Spencer Burton D · Mchenry, ILS/N 17701334N30574Carter Peter M · Elkhorn, WIBuilt 1969 · S/N 17701337N30578Rhodes Michael · Jacksonville, FLBuilt 1969 · S/N 17701339N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145N3057JGaines Von J · Hendersonville, TNBuilt 1965 · S/N 15061157N3057QJoseph C Casey · Lufkin, TXS/N 18258057N3057SMcabee Patrick A · Tampa, FLBuilt 1967 · S/N 15066957N3057UDesousa Raphael · Fremont, CABuilt 1963 · S/N 17250657N3057XSoules William P · Las Cruces, NMFirst renewal noticeS/N 15064457N3057YJjm Aviation LLC · Newport, NCBuilt 1962 · S/N 18254057N30583Roviaro Edward · Schererville, INBuilt 1973 · S/N 21059936N30584New Horizons Aviation LLC · East Helena, MTBuilt 1969 · S/N 17701344N30593Valiair Lc Trustee · Casper, WYBuilt 1973 · S/N 21059938N30597Brewer Aviation LLC · Winslow, ARBuilt 1969 · S/N 17701350N30599Wilson Phillip W Jr · Kailua, HIBuilt 1969 · S/N 17701351N305ACTascosa Trail Inc · Gruver, TXBuilt 1965 · S/N 17253679N305DWPugleasa William Hunter · Lowell, ARBuilt 1982 · S/N 15285502N305FStockdale Aviation LLC · Crawford, COBuilt 1963 · S/N 18254903N305KWPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N U20604213N305MJRegistration Pending · Phoenix, AZRegistration pendingBuilt 1967 · S/N 15067465N305NCNca Aircraft LLC · Opa Locka, FLFirst renewal noticeBuilt 2013 · S/N 208B5052N305PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264131N305PYUfly Vi LLC · St Thomas, VIS/N 207-00156N305SLSealand Airways Miami LLC · Miami, FLBuilt 1968 · S/N 185-1433N305WBCardinal Aviation LLC · Charles City, VABuilt 1967 · S/N P206-0386N305XXDs Group LLC · Miami, FLBuilt 1975 · S/N 17265513N30603Registered aircraftBuilt 1969 · S/N 17701353N3060QYarg Tap LLC · Midland, TXBuilt 1967 · S/N 18258060N3060UWhipple James M · Wadsworth, OHBuilt 1963 · S/N 17250660N30612Wheeler Vincent · Harwinton, CTBuilt 1969 · S/N 17701360N30615Yanichko Robert · Weeki Wachee, FLBuilt 1969 · S/N 17701362N30617Executive Flight Training & Services LLC · Sanford, NCBuilt 1974 · S/N 17264149N3061FTaber Deane W · Weirsdale, FLBuilt 1966 · S/N 18257161
Back to AD 97-01-13