OpenAirDocs.org
AD 51-04-02

Registered aircraft · 71

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

N10057Triple Tree Aerodrome Inc · Woodruff, SCBuilt 1929 · S/N 810N101YSnj Component Holdings LLC · Kalispell, MTBuilt 1930 · S/N 3272N110SPHolliday Mark E · Lake Elmo, MNBuilt 1931 · S/N 6W13N11221Gray Eagle Farms LLC · Southampton, NJBuilt 1938 · S/N 3415N11223Hoover Michael B · Ridgeland, WIS/N 3416N11254Daniel Sharon L · Southampton, NJBuilt 1931 · S/N 3457N113YSparrowhawk Aviation LLC · Moraine, OHS/N 3297N11715Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 12W-2040N12344Lyons James P · Lake Suzy, FLS/N 6W-38N12350Binkley David P Trustee · Sedona, AZBuilt 1932 · S/N 6W39N124YHaley Billie Jo · San Martin, CABuilt 1930 · S/N 3303N127YDeno Gerald G · Battle Creek, MIBuilt 1930 · S/N 3287N1290Weeks Kermit · Polk City, FLBuilt 1971 · S/N LCNC 1967N130YRichards T D · Saint Jo, TXBuilt 1930 · S/N 3310N140YDream Wacos LLC · Oklahoma City, OKS/N 3317N143YWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 3417N15641Hurdle Jack M II · Senoia, GABuilt 1935 · S/N 1000N1649Rhinebeck Aerodrome Museum · Red Hook, NYS/N 1649N18629Bowe Walter C Trustee · Sonoma, CAS/N 6W00N18642Historic Aircraft Restoration Museum · Saint Louis, MOBuilt 1933 · S/N 6W53N2009VWeeks Kermit · Polk City, FLBuilt 2003 · S/N 065N204KBradley Gary C · Orchard Park, NYBuilt 1929 · S/N 30N2203Windward Aviation Inc · Tukwila, WABuilt 1972 · S/N 535/17N252NPioneer Flight Museum · Kingsbury, TXS/N W-512N255MSHodges Mcneill Jr · Andersonville, GABuilt 2004 · S/N 1N258NWingnut Inc · Wilmington, DEBuilt 1930 · S/N W-518N26473Jasper Ralph Lane · Biloxi, MSBuilt 1940 · S/N 26N265NFlying Plane LLC · Bartow, FLBuilt 1930 · S/N W-514N278HWestern Antique Aeroplane And Automobile Museum · Hood River, ORS/N 20N2890Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1933 · S/N 2509N289HSilver Ranch Airpark Inc · Jaffrey, NHBuilt 1929 · S/N 5N324NAerotrack Inc · Hemet, CABuilt 1931 · S/N 3003N34304Sheeree Corp · Wilmington, DES/N 49N412WAlfred And Lois Kelch Aviation Museum Inc · Brodhead, WIBuilt 1990 · S/N 2013-1990N425EDDoyle Mary · Hampton, IABuilt 1975 · S/N 425N443WWagner Paul D · Argyle, WIS/N 12Q2009N4725Jenkins George Merritt · Wayne, PABuilt 1928 · S/N 120N510YFlying Plane LLC · Bartow, FLS/N R-409N533WCowell Norman B · Lomita, CABuilt 1930 · S/N 5W70N561MRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1929 · S/N 801N607MDream Waco LLC · Oklahoma City, OKS/N 183N6204Neely James B · Kane, PABuilt 2023 · S/N 001N62103August Aero LLC · Kalispell, MTBuilt 1993 · S/N 001N632YKhalid Rauf J · Indianapolis, INBuilt 1930 · S/N 3343N638MWestern North Carolina Air Museum · Hendersonville, NCBuilt 1930 · S/N 213N65DSBrowett Donald A · Independence, MOBuilt 1966 · S/N 2N663YSnyder Kenneth C · Lonsdale, MNBuilt 1930 · S/N 3356N713SWood John M · Hernando, FLBuilt 1968 · S/N 11N72517Smith James E Trustee · Kalispell, MTBuilt 1980 · S/N H-1N729VClark Kenneth · Claremore, OKBuilt 1930 · S/N 295
Back to AD 51-04-02