OpenAirDocs.org
AD 81-25-01

Registered aircraft · 181

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

N10SYBellany 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 7144CN21VWSeelye Eric D · Petoskey, MIBuilt 1984 · S/N 7460CN221XNapflin Erich P · Wasilla, AKBuilt 1977 · S/N 7139CN222ARBrowne Michael · Big Lake, TXS/N 7010CN235DMDouble W Air LLC · Salt Lake City, UTBuilt 1978 · S/N 7247CN302CWWarrington James Whittaker O Jr · Zirconia, NCBuilt 1976 · S/N 7057CN317XBogner Matthew L · Santa Cruz, CABuilt 1975 · S/N 6127CN32CXSkowbo Rock · Jacksonville, FLBuilt 1976 · S/N 7034CN333BAMartin Nolan T · Anchorage, AKBuilt 1978 · S/N 7182CN343GAN343ga Leasing LLC · Anchorage, AKBuilt 1976 · S/N 7009CN359XDoran James V · Saint John, KSBuilt 1976 · S/N 7002CN366XRomano Stephen Henry Daniel · Seattle, WABuilt 1976 · S/N 7005CN369DGHunninghake Brent L · Baileyville, KSS/N 7288CN379XCjr Air Service LLC · Saint Louis, MOBuilt 1976 · S/N 7011CN381XMead Lane · Minocqua, WIBuilt 1976 · S/N 7019CN382XAnderson David C · Dilley, TXBuilt 1976 · S/N 7021CN384X1 Zero Sierra Whisky LLC · Helena, MTBuilt 1976 · S/N 7025CN385XJohns Justin C · Dillingham, AKBuilt 1976 · S/N 7016CN386XO'Connor Robert W · San Bernardino, CABuilt 1976 · S/N 7029CN387XDowns Rodney A · Anchor Point, AKBuilt 1976 · S/N 7024CN388XWarner Walt M · Willow, AKBuilt 1976 · S/N 7018CN390XNovak Matt E · Port Orchard, WABuilt 1976 · S/N 7028CN394XBenham Aaron J · Sullivan, INS/N 7022CN395XRegistration Pending · Marion, MTRegistration pending, pending cancellationBuilt 1976 · S/N 7037CN397XMikepaparomeo LLC · Bend, ORBuilt 1976 · S/N 7033CN402XWeyrauch Paul H · Ray, NDBuilt 1976 · S/N 7035CN403XCc Motors LLC · Redding, CABuilt 1976 · S/N 7036CN405XStover Lance E · Eden Prairie, MNBuilt 1976 · S/N 7038CN407XCallahan Ashton G · Homer, AKS/N 7041CN409XDunn Blake · Bristol, COBuilt 1976 · S/N 7043CN417XMiller Christopher A · Broomfield, COBuilt 1976 · S/N 7047CN418XMerrell Robert H · Farmington, NHBuilt 1976 · S/N 7042CN419XBellamy William J · Duluth, MNBuilt 1976 · S/N 7048CN41VZCarver Co LLC · Chugiak, AKBuilt 1976 · S/N 7026CN433XSwanson G C · Valentine, NES/N 7046CN435XBorders Nowell · Edinburg, TXBuilt 1976 · S/N 7055CN436AKThompson James A · Ketchikan, AKBuilt 1976 · S/N 7053CN51572Registered aircraftBuilt 1974 · S/N 5005CN51635Kovaleski Thomas J · Chugiak, AKBuilt 1974 · S/N 5025CN547XMoyle Dean E DBA · Filer, IDBuilt 1976 · S/N 7008CN555AQFreeman Michael D · Morgantown, INS/N 7027CN56286Rigoni Terry N · Prescott, AZS/N 7221CN56290Franscioni Farms Inc · Salinas, CABuilt 1978 · S/N 7220CN56291Mccall Albert B II · Lebanon, TNS/N 7223CN56298Breffeilh Robert A · Juneau, AKBuilt 1978 · S/N 7227C
Back to AD 81-25-01