AD 97-01-12

Registered aircraft · 489

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-12')
    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-12')
  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.

N313CTAlmar Aviation LLC · Greenville, KYBuilt 1979 · S/N BB-461N316AFAgape Flights Inc · Venice, FLBuilt 1980 · S/N 110.271N316GCMarc Aircraft Holding LLC · Soldotna, AKBuilt 1978 · S/N BB-430N31JVMarc Inc · Bolton, MSBuilt 1981 · S/N TT-453N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49N31WCPro Serve Aviation LLC · Englewood, COBuilt 1979 · S/N BB-465N320MCMcneely Charter Service Inc · West Memphis, ARBuilt 1987 · S/N AC688N322RRNion LLC · New Century, KSBuilt 1995 · S/N 514N326AJVanderloop Equipment Inc · Brillion, WIBuilt 1978 · S/N BB-396N326BACbg LLC · Wilsonville, ORBuilt 1978 · S/N TC 269N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135N326RTPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1979 · S/N BB553N327RBAerial Applicators Of Missouri LLC · Pollard, ARBuilt 1978 · S/N BB-335N328CRDmg Aero LLC · Hickory, NCBuilt 1979 · S/N BB-548N329HSFlying Piggs LLC · Klamath Falls, ORBuilt 1979 · S/N T-323N32SVDoorless Leasing LLC · Lewes, DEBuilt 1981 · S/N BB-865N32TPIal Corp · Lewes, DEBuilt 1979 · S/N BB-456N332CAPhysicians Air Transport LLC · Hot Springs, ARBuilt 1981 · S/N BB-816N335TAN335ta LLC · Anchorage, AKBuilt 1979 · S/N BB-514N336GWWorld Class Aviation Inc · Peachtree City, GABuilt 1994 · S/N DC860MN339GWWorld Class Aviation Inc · Peachtree City, GAS/N DC-791MN339RWMy Shovel LLC · Jackson, MSS/N T339N34ARoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 110.350N3531QNew Mountain Aviation LLC · Englewood, COBuilt 1990 · S/N AC-767BN3532QNew Mountain Aviation LLC · Englewood, COBuilt 1996 · S/N DC-887BN3533QNew Mountain Aviation LLC · Englewood, COBuilt 1999 · S/N DC-900BN354AEAmeriflight LLC · Dallas, TXBuilt 1985 · S/N AC-633N360AEUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N AC-675N360LGN360lg LLC · Helena, MTBuilt 1979 · S/N T322N361KABehrens Investments Of Wisconsin LLC · Waukesha, WIBuilt 1980 · S/N BB-741N366AEBemidji Aviation Services Inc · Bemidji, MNBuilt 1987 · S/N AC-681BN370AEAmeriflight LLC · Dallas, TXBuilt 1982 · S/N AC-506N372JBUltra Property Acquisitions LLC · Edinburg, TXBuilt 1980 · S/N BB-719N377YBMoses International Inc · Bellevue, MIBuilt 1978 · S/N T-289N378SFTrigg David D · Houston, TXBuilt 1978 · S/N BB-378N379JGSmc Ltd · Somerset, WIBuilt 1981 · S/N T-414N381RUc Aviation Holdings LLC · Union City, TNBuilt 1978 · S/N BB-385N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615N38TASnflk Leasing LLC · Andrews, TXBuilt 1980 · S/N T-397N390RHAlpine Aviation Inc · Provo, UTS/N U-39N391GMUua LLC · Scottsdale, AZBuilt 1980 · S/N T-391N393JWGeneration Jets LLC · Denison, TXBuilt 1977 · S/N BB-292N398KLCascade Airways LLC · Jefferson, ORBuilt 1981 · S/N TC-398N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2N3HBSunset Aviation LLC · Port Angeles, WABuilt 1979 · S/N BB-453N400JJEagle Valley Investments LLC · Scottsdale, AZBuilt 1981 · S/N T-400N400RTWagner Air LLC · Kendalia, TXBuilt 1979 · S/N T-311N400SLTurbo Air Charter LLC · Boise, IDBuilt 1980 · S/N BB-697N4047CInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N BB202
Back to AD 97-01-12