OpenAirDocs.org
AD 52-07-03

Registered aircraft · 952

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

N103WEEngel Douglas A · Plainfield, ILS/N 2537N1049CGerbi Charles R Trustee · Auke Bay, AKS/N 11-1027N108RHBashaw Nathan R · Salem, NYBuilt 1940 · S/N 5958N10UGraber Paul E · Brooksville, MSBuilt 1940 · S/N 4231N1104GBrowett Don A · Independence, MOBuilt 1947 · S/N 3007N1106TPierce John R · Hulett, WYBuilt 1949 · S/N 11-996N113CWDawson John W · Milton Freewater, ORBuilt 1946 · S/N 11-3N11CJJackson William A Jr · Hillsboro, ORS/N 3322N11SDavis Susan J · Castroville, CABuilt 1947 · S/N 11-273N12190Cirrus Sr22t 9120 Inc Trustee · Wilmington, DEBuilt 1940 · S/N 5805N1406NShirley Tyler A · Dalton, GABuilt 1947 · S/N 22929N1429VTeed Brad S · Vancouver, WAS/N 11-339N143RUpson Theodore C · Newport, NYBuilt 1947 · S/N 11-1520N1468NDepoy Lowell K · Salem, INBuilt 1947 · S/N 23001N147PZZattoni Peter D · Mountain Iron, MNBuilt 1947 · S/N 11-1084N149NGerner Carl T · Cadyville, NYBuilt 1947 · S/N 11-1421N14LGRichards William · Gardiner, NYBuilt 1981 · S/N 401N162LFFeick Larry E · Crestline, OHBuilt 1947 · S/N 11-162N16686Smith A J · Oneill, NES/N 11-JRS-3N16PDMurphy Frank · Quitman, GABuilt 1945 · S/N 14699N17RBN17rb LLC · Fredericksburg, PABuilt 1946 · S/N 16314N1953NKnutson Wayne R · Thompson, NDS/N 11-820N1967KAir-Ag Inc · Tarboro, NCBuilt 1947 · S/N 11-1523-201N20156Fazzolare Dennis J · Strabane, PABuilt 1938 · S/N 2233N20165Newcomer Steven · Loganville, GAS/N 2217N20206Risker Dale W · Bulger, PAS/N 2006N20231Gregory Richard L Jr · Houston, TXBuilt 1937 · S/N 2031N20240War Eagles Air Museum · Santa Teresa, NMS/N 2042N20257Palmer Flying Service Inc · Manito, ILBuilt 1941 · S/N 2057N20258Brandt Terry R · Hood River, ORBuilt 1938 · S/N 2058N20261Vankirk Malcolm R · Frederick, MDBuilt 1938 · S/N 2061N20280Zimmer-Galler Ingrid E · Jefferson, MDBuilt 1939 · S/N 4058N20284Schulz Gerald · Appleton, WIBuilt 1938 · S/N 2084N20815Barnett Bryan C · Rch Palos Vrd, CABuilt 1938 · S/N 2115N20833Paetzold Larry E · Brownwood, TXBuilt 1961 · S/N 2133N211FHHelm Flying Service Inc · Casselton, NDBuilt 1946 · S/N 19044N21478Parker Daniel C · Stillwater, MNBuilt 1938 · S/N 2502N21523Monreal Michael E · North Barrington, ILBuilt 1938 · S/N 2361N21528Palmenteri Louis J · Rhome, TXBuilt 1938 · S/N 2380N2154MTrumbull Thomas A · Leland, MIS/N 20940N21561Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1938 · S/N 2474N21583Batte Randall · Forest, MSBuilt 1938 · S/N 2436N21604Delgaizo Damian A · Andover, NJBuilt 1938 · S/N 2450N21659Ramin Jeanette J · Houston, TXBuilt 1938 · S/N 2552N21661Bracewell Brent E · Zebulon, GABuilt 1938 · S/N 2549N21828Holt Arlin J · Waterford, MEBuilt 1938 · S/N 2613N21831Roberson Carlton L · Williamson, GABuilt 1938 · S/N 2608N21879Schiestle Jason T · Greenville, PABuilt 1938 · S/N 2657N2225MBerry Darrel · Camden, TNBuilt 1946 · S/N 21017N2230MPepper William G · Fayette, MEBuilt 1946 · S/N 21022
Back to AD 52-07-03