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.

N33272Explorco LLC · Evergreen, COBuilt 1976 · S/N 177RG0938N33273Dahl Neil A · Arlington, TXBuilt 1976 · S/N 177RG0939N33274Cooker Brian M · Gold Hill, NCBuilt 1976 · S/N 177RG0940N33277Niebuhr Bradley A · Morriston, FLS/N U20602708N3327DWelborn Mark G · Boonville, NCFirst renewal noticeS/N 32125N3327GWhitewater Aviation Inc · Harrison, OHBuilt 1972 · S/N 17261224N3327RLyman Gregory A Trustee · Traverse City, MIBuilt 1967 · S/N 18258627N3327SDavis Blake A · Bellevue, TXS/N 21059127N3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAS/N 17700627N3328DAcme Aircraft Leasing Mt LLC · Kalispell, MTBuilt 1955 · S/N 32126N3328ENorthwoods Air LLC · Orono, MES/N 17271505N33291Skyways Aviation Inc · Wilmington, DEBuilt 1976 · S/N 177RG0944N33296Mob Aviation USA LLC · Auburndale, FLBuilt 1976 · S/N 177RG0946N33297Skinner Marvin L · Mansfield, TXBuilt 1976 · S/N 177RG0947N33299Business Jet Services Inc · Apopka, FLBuilt 1976 · S/N 177RG0948N3329DWarren Mark W · Arlington, WABuilt 1955 · S/N 32127N3329ERichards Erick F · Stamford, TXS/N 18268242N3329FFerguson Ryan L · Fort Collins, COBuilt 1966 · S/N 18257329N3329UDirectional Holdings LLC · Missoula, MTBuilt 1963 · S/N 18254729N332DGRaymond Jeffrey R · Fairbanks, AKBuilt 1976 · S/N 18503043N332JCS&S Aircraft Inc · Bennington, VTS/N 17258514N332JRAdair Lawrence L Jr · Fountain Run, KYBuilt 1961 · S/N 18253722N333Grullon Guarocuya · Van Buren Twp, MIBuilt 1980 · S/N A1520963N3330DState Of Alaska · Kodiak, AKBuilt 1955 · S/N 32128N3330EJarco Air LLC · Fitchburg, MABuilt 1978 · S/N 17271507N3330FEmk Trans LLC · The Dalles, ORS/N 18257330N3330JDownwind Three Six LLC · Murfreesboro, TNBuilt 1974 · S/N 18263456N3330UWolford Alyson · Bonney Lake, WABuilt 1963 · S/N 18254730N3330YTighe Joseph E · Kingsland, TXBuilt 1962 · S/N 18254330N3331DKramer Donald J · Buffalo, MNBuilt 1955 · S/N 32129N3332SFluckey Gary T · Homer, AKS/N 18502274N3332TWilliams Darryl L · Medina, OHS/N 17700632N3332UMing Greg A · Guymon, OKBuilt 1963 · S/N 18254732N3333JUrban Aviation Services Inc · Paxton, MABuilt 1966 · S/N 15066033N3333MFun Tickets LLC · Manchester, MEBuilt 1981 · S/N 340A1229N3333YDeville Charles D · Clinton, LABuilt 1962 · S/N 18254333N3334DRedford Daniel A · Wasilla, AKS/N 32132N3334EJarmer Ryan F Trustee · San Diego, CABuilt 1978 · S/N 17271509N3334TBaumann Keith A · Fairfield, ILBuilt 1967 · S/N 17700634N3334YHarless Richard K · Battle Mountain, NVBuilt 1962 · S/N 18254334N3335DWilson Zane D · Fairbanks, AKBuilt 1955 · S/N 32133N3335FSocorro Meraz · El Paso, TXBuilt 1966 · S/N 18257335N3335UFogle Kenneth J · Chagrin Falls, OHBuilt 1963 · S/N 18254735N3336SVancil Todd · Justin, TXBuilt 1969 · S/N 21059136N3336TBirch Point Ventures LLC · Virginia, MNS/N 18051494N3337Chay James M · Kent, WABuilt 1978 · S/N P3370316N3337DSmooth Air LLC · Camas, WABuilt 1955 · S/N 32131N3337EAltitude Aviation LLC · Lenoir, NCBuilt 1978 · S/N 17271510N3337FAerolife Aviation LLC · Knox, INBuilt 1966 · S/N 18257337N3337SBeery Bruce M · Lakeland, FLBuilt 1969 · S/N 21059137
Back to AD 97-01-13