OpenAirDocs.org
AD 76-20-07

Registered aircraft · 150

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

N130EOshinuga Anthony A · Valley Center, CABuilt 1940 · S/N 1029N1413AKing John D · Midland, VABuilt 1947 · S/N 1532N1413BSimpson Bradley C · Grandview, TXBuilt 1949 · S/N 1640N14396Tobias Eric · Milwaukee, WIBuilt 1947 · S/N 1509N15691Trevor Howard T · Moultonborough, NHBuilt 1939 · S/N 1006N237Shannon Air Museum LLC · Fredericksburg, VAS/N 187N242Ohlmer Ted J · Monterey, CAS/N 1425N25190Wiley Calvin B · Summer Shade, KYBuilt 1940 · S/N 1011N25192Cullman Daniel H · Kent, WABuilt 1939 · S/N 1013N25193Cullman Daniel H · Kent, WABuilt 1940 · S/N 1014N25195Andraka Andrew · Newport News, VABuilt 1940 · S/N 1016N251MHawaiian Airlines Inc · Honolulu, HIBuilt 1929 · S/N 154N25305Cullman Daniel H · Kent, WAS/N 1027N25309Workman Paul E · Urbana, OHBuilt 1940 · S/N 1031N25314Cullman Daniel H · Kent, WABuilt 1940 · S/N 1036N28971Cullman Daniel H · Kent, WABuilt 1979 · S/N 1041N28972Wahrer Terry J · Cripple Creek, COBuilt 1941 · S/N 1042N28974Friends Of Bellanca Airfield Inc · New Castle, DEBuilt 1941 · S/N 1044N28980Cullman Daniel H · Kent, WAS/N 1050N28984Cullman Daniel H · Kent, WABuilt 1941 · S/N 1054N29TJRegistration Pending · Bear Creek, PARegistration pendingBuilt 1946 · S/N 1174N33FPPatterson Frederick W III · American Canyon, CAS/N 150N33GMMeulenberg Jacobus Mj · Schenevus, NYBuilt 1947 · S/N 1542N413RPalmer Earl S · Lewiston, IDBuilt 1947 · S/N 1531N427Olson Wesley M · Clovis, NMS/N 1364N44FPShipman William L · Mc Calla, ALBuilt 1946 · S/N 1096N6504NBrown Justin G · Folsom, CAS/N 1621N6506NThoms Robert D · Clyde, MIBuilt 1949 · S/N 1624N6507NEack Kenneth B · White Rock, NMBuilt 1949 · S/N 1625N6508NRegistration Pending · Independence, ORRegistration pendingS/N 1627N6520NDemeyer Scott M · Olympia, WABuilt 1949 · S/N 1641N6523NJenkins Grant W · Seattle, WAS/N 1644N7084Cullman Daniel H · Kent, WAS/N 108N73KVlk Mark J · Moses Lake, WABuilt 1947 · S/N 1154N74203Gray David M · Albuquerque, NMBuilt 1946 · S/N 1316N74212Hartman Dave · Miles City, MTS/N 1325N74213Mullins Mike W · Marshall, TXBuilt 1946 · S/N 1326N74220Grzeskowiak Robert J · Tioga, NDS/N 1333N74221South Carolina Aviation Museum Ltd · Wilmington, DEBuilt 1947 · S/N 1334N74223Mid Atlantic Air Museum · Reading, PABuilt 1946 · S/N 1336N74228King John D · Midland, VABuilt 1946 · S/N 1341N74231Valkyrie Wings LLC · Springville, UTBuilt 1946 · S/N 1344N74233Hunter James Rogers · Schertz, TXBuilt 1946 · S/N 1346N74235Thorpe Brian J · Saint Augustine, FLBuilt 1946 · S/N 1348N74241Hoover Ronald L · Springfield, MOS/N 1354N74257Norton John B · Colorado Springs, COBuilt 1946 · S/N 1370N74266Stephenson Gary E · Philip, SDBuilt 1946 · S/N 1379N74267Siler Martin R · Macon, GAS/N 1380N74269Tanner Paul Leslie · Savoy, TXBuilt 1947 · S/N 1382N74281Szostak Edward M · San Diego, CABuilt 1946 · S/N 1394
Back to AD 76-20-07