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.

N2373BWarbird Adventures Inc · Ocoee, FLBuilt 1948 · S/N 3673N2374BBoard David N · Moundsville, WVBuilt 1948 · S/N 3674N2379BRegistered aircraftBuilt 1948 · S/N 3679N2383BArt-Ticulate Tees LLC · Hazard, KYBuilt 1948 · S/N 3683N2384BAuiler Casey · San Diego, CABuilt 1948 · S/N 3684N2385BHernandez Dominic Juan · Brighton, COBuilt 1948 · S/N 3685N2387BMacken Inc Corp · Saint Paul, MNBuilt 1948 · S/N 3687N2390BSwift Museum Foundation Inc · Athens, TNS/N 3690N2394BSackett Dennis M · Orangevale, CABuilt 1948 · S/N 3694N2397BCochran Keith · Long Beach, CAS/N 3697N2398BCross John P · Houston, TXBuilt 1949 · S/N 3698N2399BSummerland Spins LLC · Summerland Key, FLBuilt 1948 · S/N 3699N2402BDaulton Rodney D · New Port Richey, FLBuilt 1949 · S/N 3702N2403BDmm Airshows LLC · Wilmington, DEBuilt 1949 · S/N 3703N2404BHaugen Michael · Oklahoma City, OKBuilt 1949 · S/N 3704N2410BMiller Charles T · Bynum, TXBuilt 1949 · S/N 3710N2413BLohse Randy · Onalaska, WABuilt 1949 · S/N 3713N2418BBartholomew Don B · Gardnerville, NVS/N 3718N2419BFenn Michael J · Cloverdale, CAS/N 3719N2422BRoki Classics LLC · Ogallala, NEBuilt 1949 · S/N 3722N2428BZahler Mitchell J · Stillwater, MNBuilt 1949 · S/N 3728N2429BRegistration Pending · Oshkosh, WIRegistration pendingBuilt 1950 · S/N 3729N2431BSampson Joel L · Belview, MNBuilt 1950 · S/N 3731N2432BKuffel Florian L · Seattle, WABuilt 1950 · S/N 3732N2436BDahler George F · Monterey, CABuilt 1950 · S/N 3736N2437BHernandez Dominic J · Brighton, COS/N 3739N2438BJentes Charles A · Smithville, OHS/N 3738N2440BBrubaker Farm Company Inc · Traer, IABuilt 1950 · S/N 3740N2441BNaumann Scott Trustee · Arroyo Grande, CABuilt 1950 · S/N 3741N2442BSwifty LLC · Dover, DES/N 3742N2443BBartholomew Don · Gardnerville, NVBuilt 1950 · S/N 3743N2444BRubiano Anthony · Cheyenne, WYBuilt 1950 · S/N 3744N2446BHolliday Mark E · Lake Elmo, MNBuilt 1950 · S/N 3746N2449BHolliday Mark E · Lake Elmo, MNBuilt 1950 · S/N 3749N2451BSimply Living LLC · Fort Myers, FLFirst renewal noticeBuilt 1951 · S/N 3751N2453BWalker Ray · Sanger, TXS/N 3753N2455BGillaspie Wade · Huntsville, TXBuilt 1952 · S/N 3755N2457BGurel Samuel E · Bentonville, ARBuilt 1951 · S/N 3757N2460BSwift Museum Foundation Inc · Athens, TNBuilt 1951 · S/N 3760N24SEBertus David · Coppell, TXBuilt 1946 · S/N 2151N251DTSwift Action LLC · Akron, OHS/N 2292N266JTCochran Keith W · Long Beach, CAS/N 1154N280VFKaczmarek Richard G · Sandersville, GABuilt 1946 · S/N 2260N28AGZahler Mitchell J · Stillwater, MNBuilt 1946 · S/N 42N2LMCollins Cody W · Palestine, TXS/N 2021N30JWLittle Colin J · Bidwell, OHS/N 1022N31WAbell Alan R · Elgin, ILBuilt 1946 · S/N 408N3200KRock Jeffrey B · Fountain Valley, CABuilt 1946 · S/N 1193N3202KKennelly Kevin T · Fort Lupton, COBuilt 1946 · S/N 1195N3207KHull Bart D · Laveen, AZBuilt 1946 · S/N 1200
Back to AD 47-06-01