OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-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:99-01-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.

N3713ZVysoky Jessica L · Edwardsville, ILS/N 22-7584N3715PSeeley Edward J · Las Cruces, NMBuilt 1955 · S/N 22-3433N3715ZThomas Michael D · Dallas Center, IABuilt 1960 · S/N 22-7586N3716AHigh Point Construction Lbk LLC · Lubbock, TXS/N 22-1956N3716MAmbler Robert L · San Diego, CABuilt 1947 · S/N 12-2657N3716POsburn Christie R · Kotzebue, AKBuilt 1955 · S/N 22-3434N3717MLeonard David J · Bettles Field, AKBuilt 1947 · S/N 12-2659N3718PNation Richard Vernon Jr · Wellsville, MOBuilt 1955 · S/N 22-3436N3718ZMckinnis James A · West Sunbury, PAS/N 22-7591N3719AWagner James E Jr · Peotone, ILBuilt 1954 · S/N 22-1959N3719MDuros Christopher J · Bothell, WABuilt 1947 · S/N 12-2541N371SCCaracciolo Tristano · Dayton, NVBuilt 1970 · S/N 18-8914N3721MCape May Aerial Advertising LLC · Rio Grande, NJBuilt 1947 · S/N 12-2662N3722AZawada Matthew J · Roberts, MTBuilt 1953 · S/N 22-1963N3724AHoeksel Michael J Sr · Poplar Grove, ILS/N 22-1965N3725ASwan Glenn E · Eagle River, AKFirst renewal noticeBuilt 1954 · S/N 22-1966N3725MPaczkowski John P · Culpeper, VABuilt 1947 · S/N 12-2544N3725PEnck Ronald L · Corvallis, ORBuilt 1955 · S/N 22-3443N3726PPrimm Jim R · Roswell, NMBuilt 1955 · S/N 22-3444N3727AHackett Joel W · Georgetown, DEBuilt 1954 · S/N 22-1968N3728MMohr Robert J · Wausau, WIBuilt 1947 · S/N 12-2668N3728PChambers Clark B · Wichita, KSBuilt 1955 · S/N 22-3446N3729AAgnew Michael D · Pardeeville, WIBuilt 1954 · S/N 20-1094N3729MArnold Ray E · Cascade, IDBuilt 1947 · S/N 12-2669N372FPMcpeek Isaac S · Barnesville, OHS/N 22-3439N372TBeautte James E · Fairland, OKBuilt 1948 · S/N 14-492N3732AWil-Mar Corp · Hazen, ARBuilt 1953 · S/N 22-1975N3732PHusain Arif · Pipersville, PABuilt 1955 · S/N 22-3451N3733PCottrell Mark C · Leitchfield, KYS/N 22-3453N3734ASteel Alan P · Odessa, TXBuilt 1953 · S/N 22-1977N3734PHamilton Richard L · Monticello, FLBuilt 1955 · S/N 22-3454N3735ATurner John C · Corinth, MSBuilt 1953 · S/N 22-1978N3736APlitt Benjamin T · Hortonville, WIFirst renewal noticeS/N 22-1979N3736PKelly Larry M · Alexander City, ALBuilt 1955 · S/N 22-3456N3739MAdair Steven M · Collierville, TNBuilt 1947 · S/N 12-2676N3740ZCarl Eric Storm Trustee · Eagle River, AKBuilt 1966 · S/N 18-7496N3741APrice John C · Bennington, KSBuilt 1953 · S/N 22-1984N3741ZStanton Morgan · Anchorage, AKBuilt 1963 · S/N 18-7497N37430Sbandi John L · New London, NCS/N 3338N3743PBulldog Aviation LLC · Ely, MNBuilt 1955 · S/N 22-3463N3744APhillips Mark W · New Underwood, SDBuilt 1954 · S/N 22-1987N3744PCaplinger Jimmy C · Justin, TXBuilt 1955 · S/N 22-3464N3744ZWild About Nature LLC · Fairbanks, AKBuilt 1960 · S/N 18-7502N3746ASpivey Harold E · Thomaston, GAS/N 22-1989N3746ZButtrick Jason · Anchorage, AKS/N 18-7504N3747PRegistration Pending · Sterling, AKRegistration pendingBuilt 1955 · S/N 22-3467N3748MDebilt Bruce A · Berthold, NDS/N 12-2683N3748PStade Joel T · Iowa Park, TXS/N 22-3468N374SDByrd Benjamin Earl · Moab, UTBuilt 1976 · S/N 18-7609039N3750PMartyn Vincent J · Crossville, TNBuilt 1955 · S/N 22-3470
Back to AD 99-01-05 R1