OpenAirDocs.org
AD 78-13-08

Registered aircraft · 275

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:78-13-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-13-08')
  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.

N103GSDuce Phillip N · Kotzebue, AKBuilt 1975 · S/N 6079CN10SYBellany Mark A · Freeville, NYS/N 7487CN11101Perin Jeffrey S · Wasilla, AKBuilt 1986 · S/N 7478CN120AGHallmark Ronald D · Spring Hill, TNBuilt 1979 · S/N 7295CN12BEElliott Russell R · Wasilla, AKS/N 7082CN14LMFeuerborn Ethan · Boise, IDBuilt 1976 · S/N 70-40CN19SDMckenney Bret K · Billings, MTBuilt 1977 · S/N 7144CN210BLGraham Mark Allan · Anchorage, AKBuilt 1975 · S/N 6138CN21VWSeelye Eric D · Petoskey, MIBuilt 1984 · S/N 7460CN221XNapflin Erich P · Wasilla, AKBuilt 1977 · S/N 7139CN222ARBrowne Michael · Big Lake, TXS/N 7010CN2245ZFoder Troy E · Sunnyside, WABuilt 1976 · S/N 6172CN235DMDouble W Air LLC · Salt Lake City, UTBuilt 1978 · S/N 7247CN248HRidge Line Aviation LLC · Denver, COBuilt 1975 · S/N 6080CN280XMorgan Travis L · Eagle River, AKBuilt 1975 · S/N 6099CN282XBrekken Chris · Prescott, WIBuilt 1975 · S/N 6112CN283XMunhall Alan V · Lakeview, ORBuilt 1975 · S/N 6102CN286XKelly John Thomas III · Bells, TXBuilt 1975 · S/N 6113CN290XDickson Bernard G · Chiloquin, ORBuilt 1975 · S/N 6114CN291XMccown Bobby E · Soldotna, AKBuilt 1975 · S/N 6117CN292XStairs Richard B · Fountain, FLBuilt 1975 · S/N 6120CN293XEvans Kent L · Mason City, NEBuilt 1975 · S/N 6122CN296XHerrema Scott A · White Cloud, MIBuilt 1975 · S/N 6126CN302CWWarrington James Whittaker O Jr · Zirconia, NCBuilt 1976 · S/N 7057CN304XStone John Brody · Birmingham, ALBuilt 1975 · S/N 6130CN305XWallitner Aviation & Restoration LLC · Bremerton, WAS/N 6132CN309XBernacki David A · Clyo, GABuilt 1975 · S/N 6125CN314XRoss Peter W Trustee · Lufkin, TXBuilt 1975 · S/N 6134CN317XBogner Matthew L · Santa Cruz, CABuilt 1975 · S/N 6127CN318XTriple F Flying Inc · Benton, PABuilt 1975 · S/N 6145CN323XLedgerwood Chris · Anchorage, AKBuilt 1975 · S/N 6131CN32CXSkowbo Rock · Jacksonville, FLBuilt 1976 · S/N 7034CN333BAMartin Nolan T · Anchorage, AKBuilt 1978 · S/N 7182CN336XCowan Lance E · Watonga, OKS/N 6153CN339XPenland Howard W · Amarillo, TXBuilt 1975 · S/N 6151CN343GAN343ga Leasing LLC · Anchorage, AKBuilt 1976 · S/N 7009CN346XSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 6156CN348XJones Chris W · Portland, ORS/N 6162CN349XCoplin Christopher S · Anchorage, AKBuilt 1976 · S/N 6161CN351XSpeer Thomas Edward · Farmington, UTS/N 6169CN352XRuach Ministry · Dover, DEBuilt 1976 · S/N 6158CN355XTressler Kevin L · Bethel, AKBuilt 1976 · S/N 6179CN358XTubbs Randall E · Newfield, NYBuilt 1976 · S/N 6163CN359XDoran James V · Saint John, KSBuilt 1976 · S/N 7002CN365XArmstrong Stefanie M · Anchorage, AKBuilt 1976 · S/N 6173CN366XRomano Stephen Henry Daniel · Seattle, WABuilt 1976 · S/N 7005CN367XBreuer Chad R · Lometa, TXBuilt 1976 · S/N 6165CN369DGHunninghake Brent L · Baileyville, KSS/N 7288CN371XWalker George R · Mableton, GABuilt 1976 · S/N 6167CN373XAmberger Mark E · Wasilla, AKBuilt 1976 · S/N 6176C
Back to AD 78-13-08