OpenAirDocs.org
AD 46-04-01

Registered aircraft · 65

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:46-04-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-04-01')
  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.

N101BNHigh Alpha Airshows LLC · Camarillo, CAS/N 305N20949Ozarks Auto Show Inc · Hollister, MOBuilt 1940 · S/N 102N20988Registration Pending · Oklahoma City, OKRegistration pendingBuilt 1940 · S/N 117N24RPlane Fun Inc Tr Trustee · Snellville, GABuilt 1940 · S/N 186N281WRezich & Rezich Aviation Consulting Inc · Winnebago, ILBuilt 1940 · S/N 106N29250Wingnut Inc · Wilmington, DEBuilt 1940 · S/N 118N29252Rule Paul Crane Trustee · Wapato, WAS/N 120N29258Rule Paul Crane Trustee · Wapato, WABuilt 1940 · S/N 126N29272Rezich & Rezich Aviation Consulting Inc · Winnebago, ILBuilt 1940 · S/N 141N29273Nimmons Johnny F · Brookshire, TXBuilt 1940 · S/N 142N29283Jorgensen Bryan H · Wadsworth, OHBuilt 1940 · S/N 152N29288Kluver Richard L · Three Lakes, WIS/N 157N29295Hudgin Louis B · Gilbert, AZS/N 164N29298Sindlinger Lyle J · Puyallup, WABuilt 1940 · S/N 167N29385Szostak Edward M · San Diego, CABuilt 1940 · S/N 174N29392Willis Nelson W · Lebanon, TNBuilt 1940 · S/N 184N29396Jilek Dominic A · River Falls, WIBuilt 1940 · S/N 189N29398Somes Jason S · Santa Rosa Valley, CAS/N 191N32471Braddock James W · Nevada City, CABuilt 1941 · S/N 203N32476Currie Mark H · Justin, TXS/N 208N32484Giltner Sam · Gilbert, SCBuilt 1941 · S/N 216N34776Eckberg Robert K · Dakota City, IABuilt 1941 · S/N 230N34783M3x Hangar Rats LLC · Fairfield, OHBuilt 1941 · S/N 239N34785Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1941 · S/N 236N34788Naca 130 LLC · Cameron Park, CABuilt 1941 · S/N 248N34791Hays James B · Early, TXBuilt 1941 · S/N 243N34797Kellner Darlene D · Drums, PABuilt 1941 · S/N 258N34854Rule Paul Crane Trustee · Wapato, WABuilt 1941 · S/N 262N34856Deakyne Carl T · Federalsburg, MDBuilt 1941 · S/N 269N34864Champaign Aviation Museum · Urbana, OHBuilt 1941 · S/N 274N34874Kobe Thomas J · Lake Placid, FLS/N 283N34875Rule Paul Crane Trustee · Wapato, WABuilt 1941 · S/N 284N34879Kreutzfeld Kenneth F · Marblehead, OHS/N 287N34882Harbaugh Scott A · Belle Valley, OHBuilt 1941 · S/N 292N34883Rezich & Rezich Aviation Consulting Inc · Winnebago, ILBuilt 1941 · S/N 290N34890Trier Mark S · Cle Elum, WABuilt 1941 · S/N 303N34895Redding Steven R · Skiatook, OKBuilt 1941 · S/N 302N37803Dubert Jay · Hedgesville, WVBuilt 1941 · S/N 313N37804Mcguire Christopher C · Claremore, OKBuilt 1941 · S/N 312N37814Rule Paul Crane Trustee · Wapato, WABuilt 1941 · S/N 323N37818Lovett Brett E · Liberty, MOBuilt 1941 · S/N 329N37819Nimmons Johnny F · Brookshire, TXBuilt 1941 · S/N 330N37822Montague Richard B · Spruce Pine, NCBuilt 1941 · S/N 365N37823Jones Donald T Jr · Barrigada, GUBuilt 1941 · S/N 373N37826Currie Mark H · Justin, TXBuilt 1941 · S/N 331N37828Dart Gregory G · Mayville, NYS/N 328N37832Taylor Ronnie R · West Jefferson, NCBuilt 1941 · S/N 336N37833Kobe Thomas J · Lake Placid, FLBuilt 1941 · S/N 337N37841Otto Bryant C · Conway, ARBuilt 1941 · S/N 345N41601Songbird LLC · Columbus, GAS/N 377
Back to AD 46-04-01