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.

N3506MOber John A · Candor, NYBuilt 1947 · S/N 12-2354N35075Bendure Ryan R · Brighton, COBuilt 1940 · S/N 6085N3507ZLaw T Wayne · West Point, UTBuilt 1960 · S/N 22-7402N35081Bent James L Jr DBA · Palatine Bridge, NYS/N 6088N3508PJones Casey A · Princeton, KSBuilt 1955 · S/N 22-3258N3509ASullivan Michael R · Crown Point, INS/N 22-1781N350CCYellow Bird Adventures LLC · Austin, TXBuilt 1951 · S/N 18-1172N3510ZBetka Thomas C · Stevens Point, WIS/N 22-7406N35116Biondich Dennis A · Rubicon, WIBuilt 1941 · S/N 6139N35119Lyons David F · Eliasville, TXBuilt 1941 · S/N 6128N3511MBlack Spruce Aviation LLC · Hermon, MEBuilt 1947 · S/N 12-2093N3511ZPogue Jimmy D · Owasso, OKBuilt 1960 · S/N 22-7407N3512MSutton Aircraft Salvage LLC · Palmer, AKS/N 12-2664N35139Wright David S · Pottstown, PABuilt 1941 · S/N 6152N3513AKnudsen John M · Anchorage, AKS/N 22-1785N35141Wolfe Eric D · Wilson, NYBuilt 1941 · S/N 6154N3514AEastern Stearman Inc Trustee · Leesburg, VAS/N 22-1786N35160Miller Jon D · Bondurant, IABuilt 1941 · S/N 6182N35171Huddleston Herbert H Jr · Greenville, MSBuilt 1941 · S/N 6196N35175Evans D F · Perry, GAS/N 5-562N3517MWilder Kirk E · Boonville, CABuilt 1947 · S/N 12-2384N3517PSmith Mark A · Bowling Green, KYBuilt 1946 · S/N 12-374N3517ZMeyers Carl A · Salem, CTBuilt 1960 · S/N 22-7414N35180Schildberg Matthew J · Greenfield, IABuilt 1941 · S/N 5-567N35189Green William D · Fairbanks, AKBuilt 1941 · S/N 5-576N35197Jackson Robbin S · Grafton, OHS/N 5-585N3519ABandy Clyde T · Orlando, FLBuilt 1953 · S/N 22-1791N3519ZSprott Robert L · Perkins, OKBuilt 1960 · S/N 22-7418N351BBFinnerty Maurice E · Tabernacle, NJBuilt 1952 · S/N 20-867N3520PWidner Jack A · Stanley, NCBuilt 1955 · S/N 22-3274N3520ZWaldo Charles N · West Ossipee, NHBuilt 1960 · S/N 22-7420N35215Sachs Maurice G · Foristell, MOBuilt 1941 · S/N 6212N3521PJet Jam LLC · Layton, UTBuilt 1955 · S/N 22-3275N35224Strong Myrt A · Marco Island, FLBuilt 1941 · S/N 6223N35226Isaac Timothy S · Independence, ORBuilt 1944 · S/N 6221N3522PBurling Daniel J DBA · Warsaw, NYBuilt 1955 · S/N 22-3276N35233Weaver Frederick G · Ocala, FLBuilt 1941 · S/N 6228N3523MMichigan Seaplane LLC · White Lake, MIBuilt 1947 · S/N 12-2369N3523PAdair Lawrence L Jr · Fountain Run, KYBuilt 1955 · S/N 22-3277N3524AGrd Aviation LLC · Canyon Lake, TXBuilt 1953 · S/N 22-1796N3524MMontmorency Enterprises LLC · Atlanta, MIBuilt 1947 · S/N 12-2370N3524PRichard Waldren LLC · Newberg, ORBuilt 1955 · S/N 22-3279N3524ZRehmel Robert S · Liberty, INBuilt 1960 · S/N 22-7427N35252Mansfield Heliflight Inc · Milton, VTBuilt 1941 · S/N 6246N35254Boyce Michael C · Shelby, OHS/N 6251N3525ZCollier Ronald O Trustee · Seymour, TNBuilt 1960 · S/N 22-7428N35266Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1941 · S/N 6190N35267Douthit Norman L · San Bernardino, CABuilt 1941 · S/N 6263N3526ZSwett John P · Zebulon, NCBuilt 1960 · S/N 22-7429N35275Harvey Daniel P · Port Leyden, NYBuilt 1941 · S/N 5-593
Back to AD 99-01-05 R1