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.

N207GHBridgeview Aviation LLC · Southfield, MIS/N 20700709N207GMWaters Aero Marine Inc · South Thomaston, MEBuilt 1973 · S/N 20700217N207GRBlue Sky Telluride LLC · Telluride, COBuilt 1979 · S/N 20700563N207HAP & C Leasing LLC · Jupiter, FLS/N 20700742N207HPCampbell James W · Geneva, ALBuilt 1982 · S/N 17275543N207JPWaters Aero-Marine Inc · Owls Head, MEBuilt 1974 · S/N 20700255N207JVSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0121N207MRVanderpool Robert W Sr · Red Devil, AKBuilt 1996 · S/N 20700424N207NEHylton Kyler E · Palmer, AKBuilt 1954 · S/N 31030N207NNCasaccio Paul E · Beesleys Point, NJBuilt 1969 · S/N 20700040N207PAMcnutt Ross T · Xenia, OHBuilt 1970 · S/N 20700162N207RADelta Investment Group LLC · Memphis, TNBuilt 2014 · S/N 208B5098N207RBSutton Aircraft Salvage LLC · Palmer, AKBuilt 1980 · S/N 20700606N207RS5m Consulting LLC · Uvalde, TXBuilt 1984 · S/N 4250195N207SRJaars Inc · Waxhaw, NCS/N 20700623N207TFPhotos Unlimited Inc · Rancho Cordova, CABuilt 1978 · S/N 20700492N207VWVanderwel Mark E · Monroe, WABuilt 1975 · S/N 20700311N207WWalters William L · Boise, IDBuilt 1963 · S/N 18254647N207YHGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700637N208Jmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 2002 · S/N 20800363N20801Loveland Christopher K · Meridian, IDBuilt 1973 · S/N 18261216N20803Goad Jimmy L · Bradford, ARBuilt 1972 · S/N 18261217N20804Ceddia Stephen J · Framingham, MABuilt 1974 · S/N 17263841N20805Welzenbach Craig L · Fair Oaks Ranch, TXBuilt 1972 · S/N 18261219N20806Young Todd Frederick · Pensacola, FLBuilt 1972 · S/N 18261220N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370TN2080RTigert Tommy Ray · Ovilla, TXBuilt 1964 · S/N 18255280N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843N2081ZMcfarland Ryan E · Jacksonville, FLBuilt 1963 · S/N 15059881N20820Maugeri Thomas V · Frankfort, NYBuilt 1972 · S/N 18261232N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848N20824Seven Hills Skydivers Inc · Madison, WIFirst renewal noticeBuilt 1972 · S/N 18261236N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849N20828Merrow R Loring · Beverly, MABuilt 1972 · S/N 18261238N2082GKennedy Daniel M · Boise, IDBuilt 1958 · S/N 51382N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372TN2082ZRamirez Frank Torres · Santa Rosa, CABuilt 1963 · S/N 15059882N20831Olg Air LLC · Miami Gardens, FLS/N 18261239N20832Wallace Fred · Ada, OKBuilt 1972 · S/N 18261240N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850N20836Morar Radu · Sutton, MABuilt 1972 · S/N 18261243N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851N20838Madden John D · Bellenue, WABuilt 1972 · S/N 18261245N2083QCardinal N2083q LLC · Churchville, PABuilt 1974 · S/N 177RG0483N2083RSchutze Eric D Trustee · Ojai, CABuilt 1964 · S/N 18255283N2083YJackson David W · Prescott Valley, AZBuilt 1962 · S/N 17249583N2083Z343 Aero Club · Bossier City, LAS/N 15059883N20841Fox Creek Aviation LLC · Jackson, WYBuilt 1972 · S/N 18261248N20842Warner Kenneth G · Granbury, TXBuilt 1972 · S/N 18261249
Back to AD 97-01-13