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.

N30329Vetter Brent E · Helena, MTBuilt 1940 · S/N 4794N3032MMoore Timothy J · Canandaigua, NYBuilt 1947 · S/N 12-1725N3033ZRobertson Scott C · Chappell Hill, TXS/N 22-6987N30340Schultz Clarence H · Elgin, MNBuilt 1940 · S/N 4-1169N30342Beugli David M · Astoria, ORBuilt 1940 · S/N 4-1170N30343Jenkins Michael D · Rigby, IDBuilt 1940 · S/N 41171N30348Mulder Darryl J · Galesburg, MIS/N 4-1176N3034ZBrown Timothy M · Clyde, OHS/N 22-6988N30354Jaggers Wesley · Tupelo, MSS/N 5179N30358Ash James L · Whitefield, NHS/N 4808N30368Forsberg Danny J · Iron Ridge, WIBuilt 1940 · S/N 5-183N3036MBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1947 · S/N 12-1581N3036ZAbell Alan R · Elgin, ILBuilt 1959 · S/N 22-6990N30372Gleason Rhett C · Timmonsville, SCBuilt 1940 · S/N 4908N30379Grant General J · Commerce Township, MIBuilt 1940 · S/N 5-184N3038ZFischer Mark D · Hooker, OKBuilt 1959 · S/N 22-6992N3039ZSvec Adolph R · Marengo, ILBuilt 1959 · S/N 22-6993N303TRegistered aircraftBuilt 1953 · S/N 18-2417N30403Besch Thomas M · West Sand Lake, NYBuilt 1940 · S/N 4-1182N30410J4 Coupe Inc · Jacksonville, FLBuilt 1940 · S/N 41192N3041MCasagranda Dennis · Anchorage, AKBuilt 1947 · S/N 12-1733N3041ZDunn Carrie B · Emporia, KSBuilt 1959 · S/N 22-6995N3042Potter Everett A · Lansford, NDS/N 4-1190N30424Hawkins Richard · Tybee Island, GAS/N 4-1205N30429Nance David B · Quinton, VAS/N 4-1221N3042MPatrick Andrew S · Moscow, IDS/N 12-1734N30432Alexander John H · Sandwich, MABuilt 1940 · S/N 4-1212N30434Gugisberg Mark R · Longville, MNBuilt 1955 · S/N 4-1220N30435Davis Judith A · David City, NEBuilt 1940 · S/N 4-1219N3043ZMaria A Sklar Pa DBA Sklar Law Trustee · Fort Lauderdale, FLBuilt 1959 · S/N 22-6997N30440Tsidjs LLC · Lehighton, PABuilt 1940 · S/N 41227N3044LMack Anita T · Scott Afb, ILBuilt 1942 · S/N 5-1410N3044MDavis Ronald L Jr · Soldotna, AKBuilt 1947 · S/N 12-1736N3044ZRoberts Marvin L · Calhoun, GABuilt 1959 · S/N 22-6998N30455Davidge William B · Winlock, WABuilt 1940 · S/N 5-198N30459Dowd Darin R · Frisco, TXBuilt 1940 · S/N 4845N3045ZColson Douglas J · Emmitsburg, MDBuilt 1959 · S/N 22-6999N3046ZSzostak Edward M · San Diego, CABuilt 1959 · S/N 22-7000N30472Hendrix Steven Roy · Bakersfield, CAS/N 4859N3047ZRiffle David T · Woodinville, WABuilt 1960 · S/N 22-7001N3048MBennis Joseph M · Sarasota, FLBuilt 1947 · S/N 12-1753N3048ZPalmatier Curt A · Montrose, PABuilt 1959 · S/N 22-7002N30497Nyboer Paul H · Hamilton, MIBuilt 1940 · S/N 4876N30508Byars Guy F · Goshen, OHBuilt 1940 · S/N 5-204N30519Ericson Steven P · Lancaster, CABuilt 1940 · S/N 4891N3051MFlying S Inc · Palestine, ILBuilt 1947 · S/N 12-1580N30520Warner Walter M Jr · Willow, AKS/N 5-213N3052MGarver John H · Fairland, INS/N 12-1742N3052ZSummer Aviation LLC · Eden Prairie, MNBuilt 1959 · S/N 22-7006N3053PKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 11-895
Back to AD 99-01-05 R1