AD 94-05-05 R1

Registered aircraft · 26,231

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.

N242XFour Aces Montana LLC · Missoula, MTBuilt 1965 · S/N 15062062N2430DDonahue Michael W · Sidney, MTBuilt 1952 · S/N 20582N2430JColster John W · Centerview, MOBuilt 1966 · S/N 15065530N2430LTaylor Kerry J · Childress, TXBuilt 1966 · S/N 17255630N2430NPace Seth M · Malibu, CABuilt 1947 · S/N 12682N2430UWarnaka Brian Justin · The Villages, FLBuilt 1963 · S/N 17250030N2430VN4629x LLC · Middletown, DES/N 14679N2431BSampson Joel L · Belview, MNBuilt 1950 · S/N 3731N2431DHanson Willow L · Nome, AKBuilt 1952 · S/N 20583N2431LMarsh John E · Washington, DCS/N 17255631N2431UJackson Robert W · Bridgeport, TXBuilt 1963 · S/N 17250031N2432BKuffel Florian L · Seattle, WABuilt 1950 · S/N 3732N2432VBell John W · South Haven, MIBuilt 1948 · S/N 14681N2433YWheeler Dean S · Lebanon, ORS/N 17249733N2434DHess Joel M · Allenwood, PABuilt 1952 · S/N 20586N2434JSkyhawk Aero LLC · Montevideo, MNS/N 15065534N2434LWeston Torey C · Unionville, MOBuilt 1966 · S/N 17255634N2434NGiovanetti Anthony J · Seymour, CTBuilt 1947 · S/N 12687N2434USkyhawk N2434u LLC · Wilmington, DEBuilt 1963 · S/N 17250034N2435Elg Rodney C · Aguila, AZBuilt 1970 · S/N WHA-1N2435JWitherspoon Jason C · Austin, ARBuilt 1966 · S/N 15065535N2435LAero Science International LLC · Augusta, GABuilt 1966 · S/N 17255635N2435UGalati Stephen E · Florissant, MOBuilt 1963 · S/N 17250035N2436BDahler George F · Monterey, CABuilt 1950 · S/N 3736N2436DSutton Aircraft Salvage LLC · Palmer, AKS/N 20588N2437BHernandez Dominic J · Brighton, COS/N 3739N2437VMidtgaard Michael A · Mason City, IABuilt 1948 · S/N 14687N2437YRussell John D · Dana Point, CABuilt 1962 · S/N 17249737N24380Harrington Aaron M · Frederick, MDBuilt 1946 · S/N 1716N2438BJentes Charles A · Smithville, OHS/N 3738N2438HMiley Ollie Z · Sacramento, KYBuilt 1946 · S/N 3063N2438JVayner Anton · Shorewood, WIBuilt 1966 · S/N 15065538N2438KSchwister Steven W · Forest Lake, MNBuilt 1947 · S/N 5165N2438NJerch Richard A · Lake Bluff, ILBuilt 1947 · S/N 12691N2438UThweatt Greg K · Lodi, CABuilt 1963 · S/N 17250038N2438VMadsen James E · New Underwood, SDBuilt 1948 · S/N 14688N2438YHoskins Aaron C · Cayuga, NYBuilt 1962 · S/N 17249738N2439HPumphrey Vickie E · Devine, TXBuilt 1946 · S/N 3064N2439JHenderickson Robert T · Galesburg, ILBuilt 1966 · S/N 15065539N2439LBetts William B · Big Lake, AKS/N 17255639N2439USmith Steven T · Charlottesville, VABuilt 1963 · S/N 17250039N2439VLavalley Asset Management Inc · Potsdam, NYS/N 14689N2439YBluegate Engineering LLC · Richburg, SCBuilt 1962 · S/N 17249739N2440BBrubaker Farm Company Inc · Traer, IABuilt 1950 · S/N 3740N2440JOliver Tim J · San Luis Obispo, CABuilt 1966 · S/N 15065540N2440LEads Kevin C · Arley, ALBuilt 1966 · S/N 17255640N2440UMiller Patrick · Madison, MNBuilt 1963 · S/N 17250040N2440YMorristown Flying Service Inc · Talbott, TNBuilt 1962 · S/N 17249740N2441BNaumann Scott Trustee · Arroyo Grande, CABuilt 1950 · S/N 3741N2442BSwifty LLC · Dover, DES/N 3742
Back to AD 94-05-05 R1