OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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-01-R1')
    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-01-R1')
  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.

N1MEHall James C · Redington Beach, FLBuilt 1967 · S/N 30-1439N1NTDmac Aircraft LLC · Savannah, GABuilt 1964 · S/N 30-262N1QABender Edward C Jr · Lansdale, PABuilt 1973 · S/N 28R-7335303N1UGRegistered aircraftS/N 32R-7780308N1WUN1wu LLC · Loganville, GABuilt 1966 · S/N 30-1383N1WYBultron Cristina · Ocala, FLBuilt 1964 · S/N 24-4018N1XACowell Aviation Maintenance LLC · Easley, SCBuilt 1964 · S/N 24-3599N2007MCritz Sue A · El Paso, TXBuilt 1977 · S/N 28R-7837061N200ACKerstetter Michael S · Hewitt, NJBuilt 1969 · S/N 28R-35656N200DBDelta Bravo Inc · Davie, FLBuilt 1959 · S/N 24-1080N200DWLillian Aviation LLC · Cypress, TXBuilt 2003 · S/N 2844102N200EFLame Deer LLC · Flemington, NJBuilt 1977 · S/N 28R-7703168N200GKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7335287N200HMBill Keck Aviation LLC · Marlow, OKBuilt 1975 · S/N 32R-7680025N200JKRuiz Victor · Roscommon, MIBuilt 1974 · S/N 28R-7435255N200KRDusek Ryan · Cypress, TXBuilt 1976 · S/N 28R-7635176N200NTRichmond Jeremy · Eufaula, OKS/N 28R-35321N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210N200SBSoaring Hawk Aviation LLC · Dexter, MIBuilt 1978 · S/N 34-7870399N200VMBaker Creek Enterprise · Townsend, GABuilt 1976 · S/N 32R-7780073N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363N200WSSierra Juliet Nm LLC · Santa Teresa, NMBuilt 1974 · S/N 34-7450117N2018MSanders Drew C · Cortez, COBuilt 1977 · S/N 28R-7803100N2024PYounhorsh Sales LLC · Wilmington, DEBuilt 1956 · S/N 24-1N202KASkybrothers LLC · Scottsdale, AZBuilt 1974 · S/N 34-7450076N202WFPro Express LLC · Alliance, NEBuilt 1978 · S/N 28R7803325N203BWAlexander Katherine · Fishers, INBuilt 1976 · S/N 28R-7635113N203SCWesley Robert J · Chuckey, TNBuilt 1966 · S/N 30-1118N204NDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2002 · S/N 2844070N204RBRoper Benjamin F · College Station, TXS/N 28R-7703149N204WTRegistered aircraftBuilt 1964 · S/N 30-699N2055MHarding Lawrence · Santa Monica, CABuilt 1977 · S/N 28R-7837063N2056MSteele Shelly Sam · Spicewood, TXBuilt 1977 · S/N 28R-7803102N2057MSeintec Corp · Aventura, FLBuilt 1977 · S/N 28R-7803103N205SF242 Skies LLC · Troutman, NCBuilt 1977 · S/N 32R-7780311N2062MJadma LLC · Helena, MTBuilt 1977 · S/N 32R-7880051N2064TClarke Bruce B · Port Angeles, WABuilt 1970 · S/N 28R-7135001N206RGVne LLC · Dowagiac, MIBuilt 1967 · S/N 30-1427N2071MBudd Aircraft Enterprises Inc · Chesterfield, MOBuilt 1977 · S/N 28R-7837064N2072TAshby Darrell · Elko, MNBuilt 1970 · S/N 28R-7135016N2073MHanel David Matthew · Suwanee, GAS/N 28R-7837065N2073TMcguire Guy D · Stevensville, MDBuilt 1970 · S/N 28R-7135017N2076MScherf Chrisman · Phoenix, AZBuilt 1977 · S/N 28R-7803105N2076TKaplan Ross H · Pompano Beach, FLBuilt 1970 · S/N 28R-7135020N2077TThoendel Joshua R · O' Neill, NEBuilt 1970 · S/N 28R-7135021N2078ARyan John T · Salina, KSBuilt 1978 · S/N 28R-7837315N2078TMavity Michael D · Phoenix, AZBuilt 1970 · S/N 28R-7135022N2079MMg Aircraft Ltd · Sidney, OHBuilt 1977 · S/N 28R-7803106N2079TCraig James A · Salt Lake City, UTBuilt 1970 · S/N 28R-7135023N207HVEuroaviation Inc Trustee · KematenBuilt 1978 · S/N 28R7803303
Back to AD 97-01-01 R1