AD 94-05-05 R1

Registered aircraft · 26,231

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:94-05-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:94-05-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.

N3827RSeaplanes R Fun Inc · Wilmington, DEBuilt 1966 · S/N 17255327N3827VRobotti Mark E · Lindstrom, MNBuilt 1948 · S/N 18685N3828HYagel Michael J · Raymond, KSBuilt 1947 · S/N 4529N3828VCoon Paul R · Benge, WABuilt 1948 · S/N 18686N3829LMustang Aviation LLC · Waterville, MEBuilt 1965 · S/N 17253998N3829RGibbons Warren · Toledo, OHS/N 17255329N3829SHagler Bennett J · San Carlos, CABuilt 1963 · S/N 17251029N382KOversquare LLC · Norman, OKS/N 101N382RXWatts Garage LLC · Jersey Shore, PABuilt 2009 · S/N TX-1010N3830KBrian Engineering & Consulting Pllc · Tulsa, OKBuilt 1948 · S/N 3519N3830RPace Michael C · Atlanta, GABuilt 1966 · S/N 17255330N3830SWin Win Aviation Inc · Wake Forest, NCBuilt 1963 · S/N 17251030N3831HBlickhan C John · Quincy, ILBuilt 1947 · S/N 4532N38322Krupinski Floyd M · Chugiak, AKFirst renewal noticeBuilt 1941 · S/N 6930N38326Wehrman Michael E · Billings, MTBuilt 1941 · S/N 6933N3832LArnold Jonah Jr · Milledgeville, GABuilt 1966 · S/N 17254001N3832RDemopoulos Chris · Dyer, INBuilt 1966 · S/N 17255332N38335L-Bird LLC · Hood River, ORBuilt 1941 · S/N 6941N3833KSampson Joel L · Belview, MNBuilt 1948 · S/N 3522N3833SBoehm Shannon Lynn · Mandan, NDBuilt 1963 · S/N 17251033N3833VWicks Mark A · Bethel, PABuilt 1948 · S/N 18691N3834HStuder Rodney J · Shelby, MIS/N 4535N3834JRegistration Pending · Buckeye, AZRegistration pendingBuilt 1966 · S/N 15065134N3834KVanderbeek Robert K · Plainfield, ILBuilt 1947 · S/N 1527N3834LZoltak Aviation LLC · Perry, GABuilt 1965 · S/N 17254003N3835DEubanks David D · Chuluota, FLBuilt 1961 · S/N 15059282N3835JSkylane Lift LLC · Cheboygan, MIBuilt 1966 · S/N 15065135N3835SMorgan Leon O · Eagle River, AKS/N 17251035N3836Trammell James S · Saint Paul, MNBuilt 1947 · S/N 12510N3836RWard David E · Quilcene, WABuilt 1966 · S/N 17255336N3836SDavis Michael W · Medicine Lodge, KSBuilt 1963 · S/N 17251036N3837LMountain Town Flying LLC · Hammondsport, NYBuilt 1965 · S/N 17254006N3838LBerry Charles J · Shreveport, LABuilt 1965 · S/N 17254007N3838RAviation Rentals LLC · Oakman, GABuilt 1966 · S/N 17255338N38395Buyak David W · New Hartford, CTBuilt 1941 · S/N 5945N383LCJohnson Knute Trustee · Art, TXBuilt 2008 · S/N AL-1134N38402Horst Aviation LLC · New Holland, PABuilt 1941 · S/N 5-952N3840LMikha Marvin · Nampa, IDS/N 17254009N38418Caldwell Gregg P · Desert Hot Springs, CAS/N 5-968N3841KCaito Michael F · Boynton Beach, FLBuilt 1948 · S/N 3541N3841LFisher John J · Middlefield, OHBuilt 1965 · S/N 17254010N38425Schirmer Brandon · Batesville, TXBuilt 1941 · S/N 5976N3842KBrunelle Alexander · Schaumburg, ILBuilt 1948 · S/N 3542N3842LKraupie Del Ray · Bridgeport, NES/N 17254011N3842SKrahn Nicholas D · Oak Creek, WIBuilt 1963 · S/N 17251042N3843JN3843j LLC · San Antonio, TXS/N 15065143N3843RHarbor View Air LLC · Kalispell, MTBuilt 1966 · S/N 17255343N3844Stricker Kim Allen · Jackson, MOBuilt 1974 · S/N 311N38449Woolslayer Joseph P · Tulsa, OKBuilt 1939 · S/N 7022N3845KSmith Jeffrey C · Asheboro, NCBuilt 1948 · S/N 3545
Back to AD 94-05-05 R1