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.

N222PXRegistered aircraftBuilt 1976 · S/N 18265157N222QLindeen Karen D · Anchorage, AKS/N 18257622N222QAKlopotek Jerome P · Orangevale, CABuilt 1969 · S/N 15070543N222RDAviation Consultants Inc · San Luis Obispo, CABuilt 1977 · S/N 340A-0366N222RMKelco LLC · Helena, MTBuilt 1971 · S/N 414-0168N222SADenny Robert C · Fort Myers, FLS/N 15078576N222SBFuglestad Jon T · Anchorage, AKBuilt 1953 · S/N 30360N222SJTriple Deuce LLC · Harrisonville, MOBuilt 1972 · S/N 21059732N222SVEllsworth Jason W · Hamilton, MTS/N 414-0164N222TADeschene Michael R · Westminster, CABuilt 1968 · S/N 15069729N222TKMachowicz Mark M · Eastpointe, MIBuilt 1967 · S/N 18257973N222TXJ M Williams LLC · Stockton, CABuilt 1957 · S/N 29976N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491N222WAWiseman Aviation Inc · Flagstaff, AZS/N R18201443N222WFBailey Steve · Chehalis, WABuilt 1963 · S/N 205-0220N222WKSchellhorn Friedrick · Harxheim/MainzS/N 337-0696N222XLFox Jeffery R · Spooner, WIBuilt 1981 · S/N 18504278N22304Berry Dewey R · Lexington, SCBuilt 1968 · S/N 15068204N22305Arend James E · Mesa, AZS/N 15068205N22307Martin David O · West Mifflin, PABuilt 1968 · S/N 15068207N2230898x LLC · Caddo Mills, TXBuilt 1968 · S/N 15068208N2230CHendricks Construction LLC · Phoenix, AZS/N 30530N2230DHendricks Construction LLC · Phoenix, AZBuilt 1976 · S/N 18503053N2230JCragg Gordon E · Georgetown, TXS/N 15065430N2230WJac & Phill Corp · San Ysidro, CAS/N 17250077N22310Tackett Eric · Huntington, INBuilt 1968 · S/N 15068210N22318Reggie Denis A Jr · Marietta, GABuilt 1968 · S/N 15068214N2231GKelly Richard · Ogdensburg, NYS/N 51531N2231THewitt David E · Newcastle, MEBuilt 1968 · S/N 185-1383N22325Marlee B Thomas · Tolar, TXBuilt 1968 · S/N 15068216N22329Guernsey G R · Belen, NMBuilt 1968 · S/N 15068219N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195N2232GBigler Mark · Topeka, KSS/N 51532N22335Johnson Marissa N · Avon, INBuilt 1968 · S/N 15068222N2233GA F Flyers LLC · American Falls, IDBuilt 1958 · S/N 51533N2233JPalmer Kim W · Lockport, NYBuilt 1966 · S/N 15065433N2233RDorman William James Trustee · Anchorage, AKBuilt 1975 · S/N 18502859N2233SRichardson Robert O · Spring Grove, ILBuilt 1976 · S/N 21061178N2233TSeward Air Taxi LLC · Seward, AKS/N 185-1386N2234GBaldwin Trevor K · Owasso, OKBuilt 1958 · S/N 51534N22351Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 15068229N22354Franks Cory · Idalou, TXS/N 15068232N22355Quinones Steven · Forney, TXBuilt 1968 · S/N 15068233N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198N2235JKnutson Wayne R · Thompson, NDS/N 150-65435N2235QSparx Logistics USA Ltd · Charlotte, NCBuilt 1968 · S/N 421A0035N22360Levy Peter F · Augusta, KSBuilt 1968 · S/N 15068236N22361Youngblood Steve R · Young Harris, GABuilt 1968 · S/N 15068237N2236QWoods Leland W · Klamath Falls, ORBuilt 1968 · S/N 421A0036N2236TParks Walter G · Chugiak, AKBuilt 1968 · S/N 185-1390
Back to AD 97-01-13