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.

N210EFDespain Aviation LLC · Pendleton, ORBuilt 1979 · S/N P21000391N210EGCenturion Aviation LLC · Nokesville, VAS/N 21059133N210ETVroom Consulting Inc · Ithaca, NYFirst renewal noticeBuilt 1968 · S/N 21059079N210FBBongard Frederic S · Torrance, CABuilt 1974 · S/N 21060441N210FCBaked Industries Inc · Yuba City, CABuilt 1975 · S/N 421B0908N210FGGlover Properties LLC · Mount Pleasant, TXBuilt 1977 · S/N 21062096N210FMAero M Inc · Key West, FLBuilt 1979 · S/N P21000259N210FVAvoyelles Rental Corp · Bunkie, LABuilt 1980 · S/N P21000572N210GATwin D LLC · Lake City, FLBuilt 1974 · S/N 21060480N210GELeimbach Keith · Evergreen, COS/N P21000655N210GGWiegler Michael · Austin, TXBuilt 1966 · S/N 21058790N210GMStipe Leslie Wayne · Mcalester, OKBuilt 1976 · S/N 21061393N210GNJackson Flying LLC · Siloam Springs, ARBuilt 1961 · S/N 21057803N210GSRetail Online Solutions Inc · Columbus, OHBuilt 1976 · S/N 21061283N210GTTeufel Gregory W · Lake Stevens, WABuilt 1961 · S/N 21057590N210GUTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1978 · S/N P21000067N210HGBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000569N210HKConway Jenna Marie Wells · Camarillo, CABuilt 1977 · S/N R1722481N210JRowdy Mcbride Hunting Services LLC · Alpine, TXBuilt 1968 · S/N 21059076N210JPCsa Aviation LLC · Leonardtown, MDBuilt 1980 · S/N P21000630N210JRSouthard Robert W · Elk City, OKBuilt 1959 · S/N 57017N210JTToddair Inc · Jonesboro, GAS/N P21000589N210JVCenturia LLC · Fort Lupton, COBuilt 1973 · S/N 21059850N210JZD & B Innovations LLC · Amarillo, TXBuilt 1979 · S/N 21063793N210KHitchcock Mark James · Scottsdale, AZBuilt 1970 · S/N 21059401N210KCFluid Media Inc · Moscow, IDS/N 21061595N210KEKampel Thomas E · Wellsville, PAS/N 21058505N210KKKunkel David L · Boulder, COBuilt 1980 · S/N P210-00586N210LAWright Gilbert G IV · San Antonio, TXBuilt 1985 · S/N P21000838N210LDPurcell Darrell Ray · Yuma, AZBuilt 1968 · S/N 21059094N210LFGolden West Flyers Inc · Turpin, OKBuilt 1978 · S/N P21000137N210LXColeman Daniel N · Phoenix, AZBuilt 1972 · S/N 21059720N210MRegistered aircraftBuilt 1976 · S/N 21061600N210MFCollins Caryl A · Westcliffe, COBuilt 1978 · S/N P21000105N210MMMarble Aviation LLC · Ball Ground, GABuilt 1971 · S/N 21059491N210MYIts Always Something LLC · Winter Haven, FLBuilt 1977 · S/N 21061763N210NBurton Stone LLC · Durango, COBuilt 1969 · S/N 21059102N210NHMoore John R · Acworth, GABuilt 1972 · S/N 21059565N210NLSsd2 LLC · Napa, CABuilt 1981 · S/N P21000674N210NMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 21059255N210NSNovember Sierra Aviation LLC · Oneill, NEBuilt 1960 · S/N 21057595N210PEVan Dyke Gary D · Pleasant Grove, CABuilt 1969 · S/N 21059180N210PPPapaco LLC · Green Cove Springs, FLBuilt 1978 · S/N P21000100N210PRShaw Ronald V · Edmond, OKS/N 64883N210PZKmz Centurion LLC · San Mateo, CABuilt 1976 · S/N 21061268N210RDPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000772N210REValiair Lc Trustee · Casper, WYS/N P21000846N210RPRegistration Pending · Charlestown, INRegistration pendingBuilt 1978 · S/N P21000014N210RRBeasley Emmett C · Bixby, OKBuilt 1960 · S/N 57503N210RSInternational Air Services Inc Trustee · Carson City, NVS/N P21000147
Back to AD 97-01-13