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.

N29KMDebonair Consulting Inc · Wilmington, DEBuilt 1955 · S/N 31579N29LKGibbons David · Holmen, WIS/N 177RG0736N29MGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0812N29MXPeterson Jim · Bedford, WYBuilt 1975 · S/N 17266309N29NDDamstetter Katherine M · Hudson, FLS/N 15066888N29PCFisher Douglas C · Mountain View, CABuilt 1979 · S/N 18266929N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769N29SRAviation USA LLC · Anchorage, AKBuilt 1978 · S/N 18503582N29XXMustang Aeronautics LLC · Chandler, AZBuilt 1975 · S/N 421C0035N2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeBuilt 1981 · S/N R18201789N2AVRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1985 · S/N 20800057N2AWSpacecrafters Inc · Silver Springs, FLBuilt 1971 · S/N 17701692N2BFMs Aero Inc · Lakeville, OHBuilt 1968 · S/N 15068499N2BPMiami Clipper Aviation LLC · Cutler Bay, FLBuilt 1972 · S/N 17701783N2CFKentucky Aviation Solutions LLC · Frankfort, KYS/N 340A0319N2CNCassel Paul E · Hernando, MSS/N 18052848N2CWMiller Steven D · Mccall, IDS/N 18502486N2EBCampbell Bernard D · Morehouse, MOBuilt 1971 · S/N 18260609N2FNFlying Neutrons LLC · Lebanon, OHBuilt 1977 · S/N 17269910N2GAWilson Frank C · Irondale, OHBuilt 1974 · S/N 18502376N2GHAbel Robert G · Williamstown, MABuilt 1963 · S/N 2050369N2HABrunner Robert L · Jefferson, ORBuilt 1975 · S/N 17265382N2HUN2hu LLC · Parker, COS/N R18200447N2JAJadair International Inc · Port Washington, WIBuilt 1976 · S/N 421C0154N2JHReign Air Charter Corp · New Port Richey, FLBuilt 1964 · S/N 17252443N2JJAerial Surveys International LLC · Watkins, COBuilt 1968 · S/N 401-0235N2JKGoldberg Leonard J · Westbrook, CTBuilt 1977 · S/N 18265546N2KFLivingston H Clark · Akron, ALBuilt 1968 · S/N 17700997N2KGLowe Samuel S III · Mary Esther, FLBuilt 1974 · S/N 17702073N2LYMagnolia Air LLC · Starkville, MSS/N 421C0301N2MBAlfa Foxtrot LLC · Statesville, NCBuilt 1978 · S/N 310R1357N2MSLemmon William Michael · N Richland Hills, TXBuilt 1978 · S/N 152-82011N2PJMorgan Bryan K · Sacramento, CABuilt 1969 · S/N 337-1161N2QDSpectraq · Las Vegas, NVS/N P3370277N2QFAbel Elliot A · Terre Haute, INBuilt 1977 · S/N P3370280N2QKPax Air LLC · Minden, NVS/N P3370283N2QMNorth Casade Air Transport LLC · Manson, WABuilt 1977 · S/N P3370290N2QPNoess Michael A · Shakopee, MNBuilt 1977 · S/N P3370291N2RXJbs Enterprises LLC · Hamilton, MTS/N P21000030N2SKRegistered aircraftBuilt 1980 · S/N 172RG0666N2TAMontgomery Keith L · Florence, ALBuilt 1972 · S/N 15073811N2TGB2c2 Aviation LLC · Piedmont, CABuilt 1969 · S/N 337-1064N2TPHanchett James R · Cheboygan, MIBuilt 1963 · S/N 17250269N2WSeldom Seen Aviation Northwest Inc · Stevensville, MTS/N 185-02982N2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEBuilt 1975 · S/N U20602849N2XCMiller Virgil J · Milton Freewater, ORS/N 17266833N2XNDudebuddy Aviation LLC · Kalispell, MTBuilt 1980 · S/N 18267615N2YEAllied Moulded Products Inc · Bryan, OHBuilt 1975 · S/N 310R0577N2YROverland Missions Inc · Cocoa, FLS/N U20601737N2ZDMelin Lynn Glenn · Scottsdale, AZBuilt 1974 · S/N 18262867
Back to AD 97-01-13