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.

N2356PJohnson Terry M · Wolfforth, TXS/N 18-4242N2357ZUsda Aphis Ws Atoc · Cedar City, UTBuilt 1980 · S/N 18-8109016N2358ABedell Samuel G · Fairbanks, AKBuilt 1952 · S/N 20-921N2358MGrassley Leonard J · Newport, ORBuilt 1946 · S/N 12-1619N2359PRyan Good Aviation LLC · Sioux Falls, SDBuilt 1955 · S/N 18-4245N235AUNorcross Ashley S · Anchorage, AKS/N 22-9772N235PRussell Robert · Worthington, OHRegistration revokedBuilt 1939 · S/N 3179N235TBossert Brett · Tucson, AZBuilt 1953 · S/N 18-2349N235WERudloff Uwe K · Lake Village, INBuilt 1975 · S/N 25-7556108N2360QStar Ads Incorporated · Torrance, CABuilt 1979 · S/N 25-7956034N2361AGeorge Raymond C · Wasilla, AKS/N 18-1906N2361MSutter Tim C · Glennallen, AKBuilt 1946 · S/N 12-1615N2362HCarpenter Forrest A · Longmont, COBuilt 1979 · S/N 18-7909177N2362MCanfield James R · South Gibson, PABuilt 1946 · S/N 12-1616N2364KEngler William O · Filion, MIBuilt 1939 · S/N 3108N2364MKissenger Richard G · Centre Hall, PABuilt 1946 · S/N 12-1611N2364PDesert Flyers Inc · Mc Neal, AZBuilt 1955 · S/N 18-4251N2366AShort Ann C · Neillsville, WIBuilt 1952 · S/N 18-1914N2367ADanreuther Keith E · Loma, MTS/N 18-1916N2368AMondt Erik C · Waterloo, IABuilt 1952 · S/N 18-1921N2368MOconnor Sarah A · Franklin, WIBuilt 1946 · S/N 12-1500N2368PAerial Messages Leasing Co · Longwood, FLBuilt 1955 · S/N 18-4257N2369MBoberg James J · Littleton, COBuilt 1946 · S/N 12-1501N236TStickley John E · Lothian, MDBuilt 1953 · S/N 18-2350N2370HMoeller David A · Anchorage, AKBuilt 1979 · S/N 18-7909178N2371ACael David P · Folsom, CABuilt 1952 · S/N 22-734N2371PZmirly Aviv · San Diego, CABuilt 1955 · S/N 22-2762N2372SChristensen Robert F · Gillette, WYBuilt 1979 · S/N 18-7909138N2373JHilker David E · Cimarron, KSBuilt 1979 · S/N 18-7909113N2375PKirsteatter Todd · Kewaunee, WIBuilt 1955 · S/N 22-2766N2376MHuberd Kyle A · Wilsonville, ORBuilt 1946 · S/N 12-1504N2376PBoyd Paul E · North Pole, AKBuilt 1955 · S/N 22-2767N2378MLacher Louis R Jr · Wasilla, AKBuilt 1946 · S/N 12-1623N2379KEast Bay Inc · Stanton, MNBuilt 1979 · S/N 18-8009054N2379MThies Trevor H · Seattle, WABuilt 1946 · S/N 12-1624N237MLN237ml LLC · Glennallen, AKS/N 18-6787N237WTGage Scott M · Anchorage, AKS/N 18 237N2380PWalker Kody Chance · Hobbs, NMBuilt 1955 · S/N 22-2771N2381MArnold V Charles F · Anchorage, AKS/N 12-1509N2383PJkr7 LLC · The Dalles, ORBuilt 1955 · S/N 22-2774N2384MDiedrich Steve · Sandpoint, IDS/N 12-1510N2384PLarsen Steve J · Colton, ORS/N 22-2775N2385ADevries Myles · Cut Bank, MTBuilt 1952 · S/N 22-750N2385MLucatorto Jeffrey A · Mc Gaheysville, VABuilt 1946 · S/N 12-1627N2386MHoeffler James P · Fort Collins, COBuilt 1946 · S/N 12-1628N2386SAm Trans 731 LLC · San Antonio, TXS/N 18-7909140N2387MOlson Catherine R · Two Rivers, AKBuilt 1946 · S/N 12-1630N2387SWittkop Joseph D · Dillingham, AKBuilt 1979 · S/N 18-7909142N2388MVotaw Kristina M · Anchorage, AKBuilt 1947 · S/N 12-1631N238THoffer William T · Orr, MNBuilt 1953 · S/N 18-2352
Back to AD 99-01-05 R1