AD 47-21-21

Registered aircraft · 126

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

N6283KTraylor Robert B · Millersview, TXFirst renewal noticeBuilt 1947 · S/N 496N6286KKomko Randy M · Mckenna, WAS/N 499N6288CSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 441N6294KHill Bruce J · Mc Alpin, FLBuilt 1947 · S/N 507N6295KWallitner Aviation And Restoration LLC · Bremerton, WABuilt 1946 · S/N 508N6302KRandall Adam M · Au Sable Forks, NYS/N 518N6317KCoutches Steven S · Cameron Park, CABuilt 1947 · S/N 540N6323KKosir John · Chardon, OHBuilt 1947 · S/N 547N6325KHigh Road Time LLC · West Palm Beach, FLBuilt 1947 · S/N 549N6342KBjorlie Paul A · Pekin, NDBuilt 1947 · S/N 566N6356KMonarch M Miller · Ocala, FLBuilt 1947 · S/N 585N6373KWoodberry Robert A · Mineral, VABuilt 1947 · S/N 602N6375KHonrud Josepth C · Cal Nev Ari, NVBuilt 1947 · S/N 604N6381KSpencer John S · Indian, AKBuilt 1962 · S/N 610N6386KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 615N6428KBus Bee Nlg LLC · Sheridan, WYS/N 673N6429KMau Timothy J · Gardendale, ALFirst renewal noticeBuilt 1947 · S/N 674N6432KDicecco Thomas III · Bear, DEBuilt 1947 · S/N 682N6440KChase 13 LLC · Wilmington, DES/N 690N6443KBucher Burton W · North Chicago, ILBuilt 1947 · S/N 693N6449KHutchinson Daniel S · Lakeview, ORBuilt 1947 · S/N 700N6460KWasik Richard C · Frankston, TXBuilt 1947 · S/N 711N6467KHicks Jacob W · Crozet, VABuilt 1947 · S/N 718N6485KCoutches Steven S · Cameron Park, CABuilt 1947 · S/N 739N6488KMccutcheon Frank Jr · Scottsboro, ALS/N 750N6490KWasik Richard C · Frankston, TXBuilt 1947 · S/N 752N6501KBertuca Judy A · Glennallen, AKBuilt 1947 · S/N 767N6505KBohl Howard M · Temecula, CABuilt 1947 · S/N 771N6511KGateway Air Center Inc · Merced, CABuilt 1947 · S/N 777N6517KVan Vleet Raymond J · Naperville, ILBuilt 1947 · S/N 783N6518KPullman Michael A · Scottsdale, AZBuilt 1947 · S/N 784N6519KLarrabee Consulting Group LLC · Dayton, OHBuilt 1947 · S/N 785N6522KKaskel Super Service LLC · Evansville, INS/N 788N6523KVfr Ltd · Wilmington, DES/N 789N6538KPockrus Pat B · Mineral Wells, TXBuilt 1947 · S/N 804N6568KSandy George T · Tehachapi, CAFirst renewal noticeS/N 838N6588KWais Richard J · Leesburg, FLBuilt 1947 · S/N 861N6589KPoules Alexander · Hope Valley, RIBuilt 1947 · S/N 862N6590KJohnson Christopher J · Tacoma, WABuilt 1947 · S/N 863N6615KReeve Howard E · Minot, NDS/N 888N6650KMiners Inn LLC · Portland, ORS/N 927N665CBAlquist Kevin B · Edwardsville, KSS/N 371N6684KMaslar Joseph P · Houston, TXBuilt 1946 · S/N 967N66CBAlaska Aviation Museum · Anchorage, AKBuilt 1947 · S/N 774N6706KDornier 27 Warbird LLC · Chugiak, AKBuilt 1947 · S/N 989N6713KOberholtzer John F · Davis, CABuilt 1947 · S/N 996N6724KSteria Kermit J · Monahans, TXBuilt 1947 · S/N 1007N6738KSandy George T · Tehachapi, CAFirst renewal noticeBuilt 1947 · S/N 1026N6739KHendrix Todd M · Bakersfield, CABuilt 1947 · S/N 1027N6748KWolf Aerospace Corp · Ontario, CAS/N 1036
Back to AD 47-21-21