OpenAirDocs.org
AD 94-05-05 R1

Registered aircraft · 26,232

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

N7770ASampson Zachary J · New Braunfels, TXS/N 17252309N7770EDye John Donald Jr · Higginsville, MOBuilt 1960 · S/N 17570N7770TShinn William D · Milton, WABuilt 1960 · S/N 47370N7770UBrown Michael E · Miramar, FLBuilt 1964 · S/N 17251770N77710Lugten Lyle · Hamilton, MIBuilt 1946 · S/N 380N77712Texas Air Museum · San Antonio, TXBuilt 1946 · S/N 342N77714Hurt Roy A DBA · Newark, OHBuilt 1946 · S/N 344N77715Masterson Fred A · Calera, ALBuilt 1946 · S/N 345N77718Vyfvinkel Frederick J · New Smyrna Beach, FLS/N 348N77719Tundra Aviation Inc · Casselton, NDBuilt 1946 · S/N 349N7771BBeam Thomas W · Paw Paw, MIBuilt 1964 · S/N 17251607N7771EEchanove Michael · Palouse, WABuilt 1959 · S/N 17571N7771TBailey Bradley E · Phoenix, AZBuilt 1960 · S/N 47371N7771UPryor Isaac L · Charlotte, NCBuilt 1964 · S/N 17251771N77720Jstream Lc · Sheridan, WYBuilt 1946 · S/N 350N77721Cooper Walter O · Defiance, OHS/N 351N77722Jstream Lc · Sheridan, WYBuilt 1946 · S/N 352N77724Cochran Robert M · Marathon, NYS/N 354N77725Mcdaniel Lee T · La Center, WABuilt 1946 · S/N 355N77729Price John DBA · Bennington, KSBuilt 1946 · S/N 359N7772FCushing Aviation LLC · Red Wing, MNBuilt 1966 · S/N 15063872N7772UKiger Aviation LLC · Corvallis, ORBuilt 1964 · S/N 17251772N7772XPremier Air Inc · Raceland, LABuilt 1961 · S/N 17248272N77731Dawson Harry E Jr · Rome, GABuilt 1946 · S/N 361N77732Specht Leo M · Towner, COBuilt 1946 · S/N 362N77735Philbrick John F · Santa Margarita, CABuilt 1946 · S/N 365N77736Riffle George W · Auburn, WABuilt 1946 · S/N 366N77738Haskin Justin Wade · Odessa, TXS/N 368N7773FDux Aaron T · Missoula, MTS/N 15063873N7773TBennett Kevin S · Bay City, ORBuilt 1960 · S/N 47373N7773UWitsberger Kelly R · Newburg, MOBuilt 1964 · S/N 17251773N77740Miller Barry W · Deltaville, VABuilt 1946 · S/N 370N77741Wirt Christopher W · Chehalis, WABuilt 1946 · S/N 371N77742Brown Carl E · Greenville, TXBuilt 1946 · S/N 372N77748Zumwalt B Joseph · Sheldon, ILBuilt 1946 · S/N 378N7774ASaydun LLC · Richardson, TXBuilt 1964 · S/N 17252168N77752Hovanec Nicki · Enterprise, FLBuilt 1948 · S/N 3524N77753Wilson Stephen A · Granbury, TXBuilt 1948 · S/N 3525N77755Plane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 3527N77756Sinclair James Stanley · Douglas, GABuilt 1948 · S/N 3528N77757Taylor Jeffrey S · Cinnaminson, NJS/N 3529N77759Walsh Samuel R · Bemidji, MNBuilt 1948 · S/N 3531N7775DTupper Stanley R III · Beaufort, SCBuilt 1957 · S/N 18-5960N7775TSheaffer Hayden L · Lititz, PABuilt 1960 · S/N 47375N77760Schooler Gary M · Mesa, AZBuilt 1948 · S/N 3532N7776EOtte Bowdie · Norfolk, NEBuilt 1959 · S/N 17576N7776XVista I Inc · Smithville, OHBuilt 1961 · S/N 17248276N7778UAngel Del Mar LLC · Park City, UTBuilt 1964 · S/N 17251778N7779FSmith Brian · Richmond, INBuilt 1966 · S/N 15063879N777ADLeithead Bruce O · Stone Mountain, GABuilt 1958 · S/N 55502
Back to AD 94-05-05 R1