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.

N3184RGardner Daniel J · Alvord, TXBuilt 1967 · S/N 18258584N3184SThrash Farms Inc · Pelahatchie, MSBuilt 1964 · S/N 18255684N3184XSandlapper Aviation Of De · Bennington, VTBuilt 1966 · S/N 15064584N3184YFunkhouser David E · Weatherford, OKBuilt 1962 · S/N 18254184N3185DMorgan Douglas C · Anchorage, AKBuilt 1955 · S/N 31983N3185F85 Foxtrot LLC · Redmond, ORS/N 18257285N3185QPara Tactics LLC · Shelton, WABuilt 1967 · S/N 18258185N3185XSanders John L · Sikeston, MOS/N 15064585N3185YGochenour Air Inc · Fort Wayne, INBuilt 1962 · S/N 18254185N3186DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 31984N3186JHowenstein John G · Roseville, CABuilt 1966 · S/N 15065886N3186QKimbril Steve · Hartselle, ALBuilt 1967 · S/N 18258186N3186RHuey Gale R · Celeste, TXBuilt 1967 · S/N 18258586N3186XPanus Mark V · Hinsdale, NYBuilt 1966 · S/N 15064586N3186YJram Air Parts LLC · Henderson, NVBuilt 1962 · S/N 18254186N3187CHemm Colby L · Newcastle, CABuilt 1954 · S/N 30986N3187FVolatile Aero Ventures LLC · Boulder City, NVBuilt 1966 · S/N 18257287N3187JBrar Amuldeep S · Austin, TXBuilt 1966 · S/N 15065887N3187UMillikan Kimball S · Honolulu, HIBuilt 1963 · S/N 18254587N3187YMiller Richard G · Anson, TXS/N 18254187N3188JFlight Time Builders Inc · Memphis, TNBuilt 1966 · S/N 15065888N3188QLutz Paul A Trustee · Seville, OHBuilt 1967 · S/N 18258188N3188SCrossman Charles · Rusk, TXBuilt 1964 · S/N 18255688N3188TRucinski Edward A · Climax, NCS/N 17700488N3188UAsb Avionics LLC · Mojave, CABuilt 1963 · S/N 18254588N3188YIngram Patrick Joseph · Pinedale, WYS/N 18254188N3189CSmith David J · Duluth, MNBuilt 1954 · S/N 30988N3189SMarvin Franz Interests Inc · Victoria, TXS/N 18255689N3189ULaney Donald R · Inkster, MIS/N 18254589N3189VMunn Julian · Spring, TXS/N 15076413N318CCVan Schoonhoven Nicholas R · Kent, WABuilt 1966 · S/N 18257289N318DMDelta Kilo Mike LLC · Rayville, LABuilt 1977 · S/N 18266215N318NRNorthern Arizona Investment Group LLC · Prescott, AZBuilt 1982 · S/N 18504382N318PPK&A Consulting Of Montana Inc · Billings, MTBuilt 1974 · S/N 421B0843N318PWN318pw LLC · New Canaan, CTBuilt 1973 · S/N 17262171N318RAllen Timothy J · East Kingston, NHBuilt 1958 · S/N 36999N318RCLafrance Lon H · Rocky Mount, MOBuilt 1977 · S/N 17269183N318SCMooney Frank X · Friendswood, TXBuilt 1957 · S/N 36261N318TWFlg Air Transport LLC · Miramar, FLS/N 421-0170N318UTraffic Law LLC · Tampa, FLBuilt 1977 · S/N 310R0994N318VFShramek Troy A · Bossier City, LABuilt 1973 · S/N 17702008N3190DDooyema Eric · Spokane, WABuilt 1955 · S/N 31988N3190FTimbol Julius J · Fair Oaks, CABuilt 1966 · S/N 18257290N3190JSimon Mitchell B · Edison, NJBuilt 1966 · S/N 15065890N3190QHilton John C · Glastonbury, CTBuilt 1967 · S/N 18258190N3190RPace Richard · Leighton, ALBuilt 1967 · S/N 18258590N3190UTo Brand · Stanton, TXBuilt 1963 · S/N 18254590N3190XOso Air LLC · Missoula, MTBuilt 1966 · S/N 15064590N3190YSpencer Thomas D · Brentwood, TNBuilt 1962 · S/N 18254190N3191CVaneau Phillip M · Wasilla, AKBuilt 1954 · S/N 30990
Back to AD 97-01-13