AD 47-06-01

Registered aircraft · 541

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-06-01')
    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-06-01')
  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.

N3357KNewman Steve M · Portland, ORS/N 1350N3366KWilson Stephen A · Granbury, TXBuilt 1946 · S/N 1359N3368KFink Jeffrey C K · Austin, TXBuilt 1946 · S/N 1361N3370KMinor James F · Lake Dallas, TXBuilt 1946 · S/N 1363N3371KRengstorf Larry · Windsor, CAS/N 1364N3378KGarcia Michael J · La Verne, CABuilt 1946 · S/N 1371N337ECrosswhite Dan F · Axtell, TXBuilt 1946 · S/N 1303N3380KKabat Jules Max · Las Vegas, NVBuilt 1946 · S/N 1373N3385KSalmonsen James A · Oswego, NYBuilt 1946 · S/N 1378N3390KFowler Darrel D Trustee · Las Vegas, NVBuilt 1946 · S/N 1383N3393KAnderson James · Saint Onge, SDS/N 1386N3395KWoxof LLC · Advance, NCBuilt 1946 · S/N 1388N3398KStahl Brad · Jackson, CAS/N 1391N33TCAviation Safety Services And Management LLC · Grapevine, TXBuilt 1946 · S/N 2106N347Haugen Michael C · Oklahoma City, OKFirst renewal noticeBuilt 1946 · S/N 2091N34RXNelson Miguel E · Lake Stevens, WABuilt 1946 · S/N 47N369BZBartholomew Don · Gardnerville, NVBuilt 1946 · S/N 1302N3704KWilson Stephen A · Granbury, TXBuilt 1946 · S/N 1397N3707KGoodman Steven L · Phoenix, AZBuilt 1946 · S/N 1400N3709KPlane Fun Inc Tr Trustee · Snellville, GAS/N 1402N3712KPatton Charles R · New Bern, NCBuilt 1946 · S/N 1405N3717KVetter Virgil R · Plattsburg, MOBuilt 1946 · S/N 1410N3719KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 1412N3720KGreen Mark · Killeen, TXS/N 1413N3723KMiller Charles · Bynum, TXS/N 1416N3725KWalters Jeffrey D · Morganton, NCBuilt 1946 · S/N 1418N3727KFussell L J · Broxton, GABuilt 1946 · S/N 1420N3729KRoth Steven C · The Villages, FLBuilt 1946 · S/N 1422N3731KDicker Alan J · Scottsdale, AZBuilt 1946 · S/N 1424N3735KHarris George P · Pine, COBuilt 1946 · S/N 1428N3740KWilliamson Ronald W · Westlake Village, CABuilt 1946 · S/N 1433N3741KFratti Robert B · Nampa, IDBuilt 1946 · S/N 1434N3748KDuffus Andrew · Renton, WABuilt 1946 · S/N 1441N3749KMorley Richard G · Indian Rocks Beach, FLBuilt 1946 · S/N 1442N3755KRegistration Pending · Carlsbad, CARegistration pendingS/N 1448N3756KStottlemyer Bradley J · Lake Geneva, WIBuilt 1946 · S/N 1449N3760KPavlinovic Lawrence E · Lake Stevens, WABuilt 1946 · S/N 1453N3762KKawasaki Clyde H · Carson City, NVS/N 1455N3764KAnderson Ricky P · Dodge, TXS/N 1457N3767KSkibinski Jan Joseph · Midlothian, VABuilt 1946 · S/N 1460N3770KBalint Jozef · Fort Worth, TXS/N 1463N3772KSale Reported · Crestline, CASale reportedBuilt 1946 · S/N 1465N3773KHansen Ernest F · Sequim, WABuilt 1946 · S/N 1466N3782KRegistered aircraftBuilt 1946 · S/N 1475N3783KAndrews Nathan S · Graham, WABuilt 1946 · S/N 1474N3785KBartholomew Don · Gardnerville, NVBuilt 1946 · S/N 1478N3787KStearns Edwin Ben Jr · Chandler, AZS/N 1480N3788KSwift Museum Foundation Inc · Athens, TNBuilt 1946 · S/N 1481N3793KVolpe Francis B · Boynton Beach, FLBuilt 1946 · S/N 1486N3796KFletcher Larry · Fairhope, ALBuilt 1946 · S/N 1489
Back to AD 47-06-01