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.

N3099UCotter William P · Elkhart, KSBuilt 1963 · S/N 17250699N3099YPerkins Scott B · Thomas, OKFirst renewal noticeBuilt 1962 · S/N 18254099N309LLSweepyacres LLC · Greenbrier, TNS/N 177RG1346N309MMDavenport James M II · Hollywood, FLBuilt 1975 · S/N 17265518N30AWKnox Tommy J · Lampasas, TXBuilt 1974 · S/N 18502369N30CMBoardman Air Service LLC · Henderson, NEBuilt 1974 · S/N 18502443N30CTLaidley Robert F · Erie, COBuilt 1978 · S/N 182-66446N30DBBouchard Dean · Glendive, MTBuilt 1965 · S/N 17252702N30DTShelton Sharon Shay · Abilene, TXS/N 414-0910N30EEEnterprises Aviation Inc · Piedmont, SDBuilt 1979 · S/N 414A0443N30EWThree Zero Echo Whisky Inc · Wilmington, DEBuilt 1976 · S/N 21061412N30FBBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N 414A0067N30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeBuilt 1982 · S/N R18201913N30GEEagle Air Inc · Schoolcraft, MIBuilt 1976 · S/N 18265130N30GPCedar Mountain Respiratory Inc · Athol, IDBuilt 1975 · S/N P3370212N30GSClausen Robert G · Argyle, MNBuilt 1973 · S/N 17261470N30HBN30hb LLC · North Miami, FLS/N 340-0786N30HCKinetic Concepts LLC · Pensacola, FLS/N 310Q1079N30JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17268043N30LDPartlow David D Jr · Pahoa, HIBuilt 1966 · S/N 15063631N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995N30LTJuans Adios LLC · Newark, DES/N 421C0290N30MSFlying Medical Service · Grosse Pointe, MIBuilt 1974 · S/N U20602620N30MTMcnamara J Kevin · Cascade, IDBuilt 1977 · S/N U20604086N30MUOracle Aviation LLC · Omaha, NEBuilt 1965 · S/N 17253432N30PTGas Aviation LLC · Decatur, TNBuilt 1976 · S/N 421C0157N30RHHalye Roger J · Port Orange, FLBuilt 1977 · S/N 17269998N30RJBrookshire Joseph E · Erie, COBuilt 1961 · S/N 17557073N30RWSaltzy Seas LLC · Loxahatchee, FLBuilt 1976 · S/N 310R0667N30STennessee Technology Center At Morristown · Morristown, TNBuilt 1973 · S/N P3370147N30SSN30ss LLC · Dover, DEBuilt 1973 · S/N 414-0451N30TGCarter Jesse E · Milford, OHBuilt 1958 · S/N 55679N30WEWest Elk Air LLC · Gunnison, COBuilt 1985 · S/N 18504432N30WLSkydive Coolidge Inc · Tempe, AZBuilt 1966 · S/N P206-0275N3100CBannon Daren · Douglass, KSBuilt 1954 · S/N 31156N3100DDiel Mark A · Walnut Creek, CABuilt 1955 · S/N 31898N3100FBurger Todd Richard · Helena, MTS/N 18257200N3100RCentral Oklahoma Aviators Flying Club · Piedmont, OKBuilt 1967 · S/N 18258500N3100SSinnissippi Aviation LLC · Beloit, WIBuilt 1964 · S/N 18255600N3100YWhalen John F · West Ossipee, NHBuilt 1962 · S/N 18254100N3101CFreefall Fever Inc · Edgewater, FLBuilt 1954 · S/N 30900N3101JRobinson David N · Colleyville, TXBuilt 1966 · S/N 15065801N3101TMission Air LLC · Charlotte, NCS/N 310R1877N3101XBlalock Bernnie R · Washington, OKBuilt 1966 · S/N 15064501N3101YJazzminate Inc · La Mesa, CABuilt 1962 · S/N 18254101N3102DOsowski Christopher J · Anchorage, AKBuilt 1955 · S/N 31900N3102FWhitfield Timothy D · Fairfield, NCBuilt 1966 · S/N 18257202N3102XJoshua Aircraft LLC · Georgetown, DEBuilt 1966 · S/N 15064502N3103CBay Kelly M Trustee · Glennallen, AKBuilt 1954 · S/N 30902N3103FJorgensen Bryan K · Kingston, GABuilt 1967 · S/N 18258103
Back to AD 97-01-13