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.

N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593N220TCLanger Brent A · Owatonna, MNBuilt 1973 · S/N 18502153N220WSClark Alan R · Tucson, AZBuilt 1978 · S/N R18200260N220XWMartinaire Aviation LLC · Addison, TXBuilt 2000 · S/N 208B0822N22101Propwash Aviation LLC · Midland, MIBuilt 1974 · S/N 17264055N22102Registration Pending · Metairie, LARegistration pendingS/N 15068063N22106Andreu Kenneth J · Valhalla, NYS/N 15068064N2210JAmes Stephen A · Scottsdale, AZBuilt 1966 · S/N 15065410N22110Schmitt Rudy · Brookshire, TXS/N 15068066N22115Cummins Michael P · University Park, MDBuilt 1967 · S/N 15068069N2211GKoepplin Ricky G · Missoula, MTBuilt 1958 · S/N 51511N2211QHill Jeffrey A · Bridgeport, WVBuilt 1968 · S/N 421A0011N2211YGayle Randall K · Houston, TXBuilt 1967 · S/N 17700011N22123Hughes James H · Northlake, TXBuilt 1967 · S/N 15068074N22128Sale Reported · Royal, ARSale reported, pending cancellationBuilt 1967 · S/N 15068077N22129Morrison Dwayne L · Columbia, SCBuilt 1967 · S/N 15068078N2212WCleveland Frank W · Quinhagak, AKBuilt 1978 · S/N 17271516N2212YSteffy Richard L · Annville, PABuilt 1967 · S/N 17700012N22130Kall Joseph F · Bozeman, MTBuilt 1967 · S/N 15068079N22131Kraxberger Rick R · Kasilof, AKBuilt 1976 · S/N 18503074N22135Rosales Ruano Irving A · Plantation, FLS/N 15068084N22138Obert Robert V · Dunnellon, FLBuilt 1967 · S/N 15068086N2213CTruffer Martin · Fairbanks, AKBuilt 1953 · S/N 30513N2213GAnzion Susan K · Nerstrand, MNBuilt 1958 · S/N 51513N2213JKlemp Darrel D · Bonduel, WIBuilt 1966 · S/N 15065413N22142Cummings Ezekiel · San Antonio, TXBuilt 1967 · S/N 15068090N22145Mcdowell Jhonathon P · Lake Alfred, FLBuilt 1967 · S/N 15068093N22146Star Voyages LLC · Kissimmee, FLBuilt 1967 · S/N 15068094N22147Morris Gregory A · Arlington, TXFirst renewal noticeBuilt 1967 · S/N 15068095N2214CMarks Richard J IV · Norway, MEBuilt 1953 · S/N 30514N2214GGanfield Roger A · Guernsey, WYBuilt 1958 · S/N 51514N2214Q421 Partners · Delphi, INBuilt 1968 · S/N 421A0014N2214YRegistration Pending · Tampa, FLRegistration pendingBuilt 1967 · S/N 17700014N22150Cody Edward H · Benton City, WABuilt 1967 · S/N 15068098N22151Soren Sky LLC · Riverside, CAS/N 15068099N22153Carter Gary J · Manlius, NYBuilt 1967 · S/N 15068101N22155Anady Aviation LLC · Hemet, CABuilt 1967 · S/N 15068103N22157Potter Colin J · Piedmont, SDBuilt 1967 · S/N 15068104N22158Million John B · Westminster, MDBuilt 1967 · S/N 15068105N22159Registration Pending · Phoenix, AZRegistration pending, canceledBuilt 1967 · S/N 15068106N2215JRogers Gary A · Novi, MIBuilt 1966 · S/N 15065415N2215TBackcountry Wagons LLC · Kalispell, MTBuilt 1968 · S/N 185-1367N22160Evert Linda L · Golden Valley, MNBuilt 1967 · S/N 15068107N22162Red Oak Commuter LLC · Red Oak, IABuilt 1967 · S/N 15068108N2216CAero Mark Inc · Idaho Falls, IDBuilt 1953 · S/N 30516N2216FSummit North LLC · Anchorage, AKBuilt 1982 · S/N U20606504N2216URegistered aircraftBuilt 1974 · S/N U20602355N2216XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 337-0116N22170Taylor Warren D · Las Vegas, NVBuilt 1967 · S/N 15068114N22172Soerens Thomas D · Saint Charles, ILBuilt 1967 · S/N 15068115
Back to AD 97-01-13