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.

N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424N200NMOrr Leroy A · Tonasket, WABuilt 1960 · S/N 57271N200PFPrimary Flight Control LLC · Fleming Island, FLBuilt 1984 · S/N 17276085N200PSMerren R Todd DBA · Montgomery, ALBuilt 1967 · S/N 67-15030N200QRPdq Flight Inc · Garden City, NYS/N U20606092N200RXAndrews Laral B · Portland, ORS/N 15067073N200SDKing Dwayne W · Sutton, AKBuilt 1969 · S/N 15070651N200SHHoward Steve · Jefferson City, MOBuilt 1979 · S/N 310R1601N200TWeishaar Walt E · Livingston, TXBuilt 1964 · S/N 15060991N200TLHusnik Brad M · Forest Lake, MNBuilt 1966 · S/N U206-0559N200TNI & V Aviation LLC · Missoula, MTBuilt 1978 · S/N 421C0444N200VVN200vv LLC · Pontiac, MIS/N 18267363N200YCShady Aero LLC · Anchorage, KYS/N 340A0285N200ZKInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 17255678N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014N2010GFox Stephen A · Wasilla, AKBuilt 1958 · S/N 51310N2010QShadow Blade Technologies LLC · Palm Bay, FLBuilt 1973 · S/N 177RG0410N2010XHutchinson Darrold K Trustee · Hingham, MTBuilt 1965 · S/N 18256110N20111Westcott Emily E · Sequim, WABuilt 1972 · S/N 17261019N20115Alpha Zulu Aviation LLC · San Diego, CABuilt 1972 · S/N 17261021N20116Paxton Roger D · Norman, NCFirst renewal noticeS/N 17702630N2011QManzo Mario A · Sacramento, CAS/N 177RG0411N2011XSalem Ricky L · Burnet, TXBuilt 1965 · S/N 18256111N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631N20127Lewallen David H · Alexander, ARBuilt 1977 · S/N 17702633N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117N2012GMchugh Michael J Trustee · Hailey, IDBuilt 1958 · S/N 51312N2012QOwens Joseph L · Fort Mohave, AZBuilt 1973 · S/N 177RG0412N2012RPhysical Therapy And Sports Solutions LLC · Santa Fe, NMBuilt 1964 · S/N 18255212N20132J & L Aviation LLC · Malta, NYBuilt 1972 · S/N 17261035N20133Creative Strategies Inc · Proctorville, OHBuilt 1972 · S/N 17261036N20136Crate Inc · Humboldt, NEBuilt 1972 · S/N 17261038N2013RZinsmeyer Charles D · Llano, TXBuilt 1964 · S/N 18255213N2013XEec Group LLC · Kalispell, MTBuilt 1965 · S/N 18256113N2013YRoberts Michael R · Plano, TXBuilt 1962 · S/N 17249513N2014Blue Skies Trading Company LLC · Toledo, OHS/N 18052338N20141Bbrrjd Inc · Wilmington, DEBuilt 1972 · S/N 17261042N20142Johnson Lindley N · Kingstowne, VAS/N 17702635N20143Loomis Aviation LLC · Gahanna, OHBuilt 1972 · S/N 17261044N20145Avco Patrol LLC · Lyndon, KSS/N 17702636N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118N2014QRegistration Pending · Glennville, GARegistration pendingBuilt 1973 · S/N 177RG0414N2014RDaedalus Wings Inc · Malvern, OHBuilt 1964 · S/N 18255214N2014XTashjian Kirk G · Stanwood, WABuilt 1965 · S/N 18256114N20151Binder Andrew S · Santa Barbara, CAS/N 17702637N20154Jones 170a LLC · Bridgman, MIBuilt 1972 · S/N 17261051N20155Wild Wingdom LLC · Greenville, SCBuilt 1972 · S/N 17261052
Back to AD 97-01-13