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.

N7431HDayton Kenneth J · Great Mills, MDBuilt 1946 · S/N 20697N7431MWestern Pacific Systems Inc · Anchorage, AKS/N 55731N7431TKorinko Seana L · Rostraver Township, PABuilt 1959 · S/N 47031N7431XVannier Aviation LLC · Sheridan, ORBuilt 1960 · S/N 17247931N7432BSmith David C · Malott, WABuilt 1956 · S/N 7EC-470N7432TWilcox Joshua · Mesa, AZBuilt 1959 · S/N 47032N7432XFerguson Mark G · Wallkill, NYBuilt 1960 · S/N 17247932N7433ASmith Larry D · Friendswood, TXBuilt 1956 · S/N 29533N7433BRegistration Pending · Beebe, ARRegistration pendingBuilt 1956 · S/N 7EC-471N7433TAndreatta Susan J · Canon City, COBuilt 1959 · S/N 47033N7434TDixon Farm · Tribune, KSS/N 47034N7435HAdams Clayton S · Rosemount, MNBuilt 1946 · S/N 20701N7435TJohnson Scott E · Wausau, WIBuilt 1959 · S/N 47035N7435XRoduner Cindy J · Benton, KSS/N 17247935N7436BLooper Kyle · Las Vegas, NVBuilt 1956 · S/N 7EC-474N7438AKellogg Charlie H · Oxnard, CABuilt 1956 · S/N 29538N7438BLampe Jared Joseph · Turner, MIS/N 7EC477N7438GMcguinnis Joseph G · Scottsdale, AZBuilt 1973 · S/N 15074655N7439AAlsterlind Stephen W · San Rafael, CABuilt 1956 · S/N 29539N7439BWoyte John F · Eagle River, AKS/N 7EC-478N743CCLewis Meriwether F · Clarksville, VABuilt 2007 · S/N CC11-00042N743RBBenefield Shelby · Attalla, ALS/N 15072497N7440AN7440a LLC · Howell, MIBuilt 1956 · S/N 29540N7440BGoethel Eric D · Hampton, NHBuilt 1956 · S/N 7EC-485N7440GJohnes Charles H · Santa Maria, CABuilt 1973 · S/N 15074656N7440MAustin Kevin · Roseville, CABuilt 1959 · S/N 55740N7440TFranklin Benjamin L Jr · Woodstock, GABuilt 1960 · S/N 47040N7440XWatonwan Flyers Inc · Saint James, MNBuilt 1960 · S/N 17247940N7441AMadison Nicholas R · Fayette, ALBuilt 1959 · S/N 29541N7441HDoe Shannon W Trustee · Henderson, NVBuilt 1946 · S/N 20704N7441QRegistered aircraftRegistration pendingBuilt 1972 · S/N 18261081N7441TGarst Lynn F · Oklahoma City, OKBuilt 1959 · S/N 47041N7441XHolland Newel G · Nacogdoches, TXBuilt 1960 · S/N 17247941N7442TTrono Zach C · Charlotte, VTBuilt 1959 · S/N 47042N7442XBeail Herschel D · Quincy, CABuilt 1960 · S/N 17247942N7443MVaccari Kevin N · Walnut Ridge, ARBuilt 1959 · S/N 55743N7443TGuarno Adam C · Milton, FLS/N 47043N7444MMitchell Lester L · Okmulgee, OKBuilt 1958 · S/N 55744N7444TDmac Aircraft LLC · Savannah, GABuilt 1959 · S/N 47044N7445TKiss Sandor A Jr · Petaluma, CAS/N 47045N7445XMelott Matthew · Mesa, AZS/N 17247945N7446MHobson George A · Fairbanks, AKBuilt 1958 · S/N 55746N7446TGot Wings LLC · Woodbury, NYBuilt 1959 · S/N 47046N7447BCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1956 · S/N 7EC-496N7447HBelleau James R · Greeley, COBuilt 1946 · S/N 20712N7447XBrewer Eric V · Alva, OKS/N 17247947N7448MCadwell David Earl · Windsor, COBuilt 1959 · S/N 55748N7448XPeterson Bruce L · Williston, NDBuilt 1960 · S/N 17247948N744KGruntmeir Joe L · Iroquois, SDBuilt 2003 · S/N J-4N7450MJones Jeremy · Lampasas, TXS/N 55750
Back to AD 94-05-05 R1