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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N3357KNewman Steve M · Portland, ORN3366KWilson Stephen A · Granbury, TXN3368KFink Jeffrey C K · Austin, TXN3370KMinor James F · Lake Dallas, TXN3371KRengstorf Larry · Windsor, CAN3378KGarcia Michael J · La Verne, CAN337ECrosswhite Dan F · Axtell, TXN3380KKabat Jules Max · Las Vegas, NVN3385KSalmonsen James A · Oswego, NYN3390KFowler Darrel D Trustee · Las Vegas, NVN3393KAnderson James · Saint Onge, SDN3395KWoxof LLC · Advance, NCN3398KStahl Brad · Jackson, CAN33TCAviation Safety Services And Management LLC · Grapevine, TXN347Haugen Michael C · Oklahoma City, OKFirst renewal noticeN34RXNelson Miguel E · Lake Stevens, WAN369BZBartholomew Don · Gardnerville, NVN3704KWilson Stephen A · Granbury, TXN3707KGoodman Steven L · Phoenix, AZN3709KPlane Fun Inc Tr Trustee · Snellville, GAN3712KPatton Charles R · New Bern, NCN3717KVetter Virgil R · Plattsburg, MON3719KSouthern Aircraft Consultancy Inc Trustee · Casper, WYN3720KGreen Mark · Killeen, TXN3723KMiller Charles · Bynum, TXN3725KWalters Jeffrey D · Morganton, NCN3727KFussell L J · Broxton, GAN3729KRoth Steven C · The Villages, FLN3731KDicker Alan J · Scottsdale, AZN3735KHarris George P · Pine, CON3740KWilliamson Ronald W · Westlake Village, CAN3741KFratti Robert B · Nampa, IDN3748KDuffus Andrew · Renton, WAN3749KMorley Richard G · Indian Rocks Beach, FLN3755KRegistration Pending · Carlsbad, CARegistration pendingN3756KStottlemyer Bradley J · Lake Geneva, WIN3760KPavlinovic Lawrence E · Lake Stevens, WAN3762KKawasaki Clyde H · Carson City, NVN3764KAnderson Ricky P · Dodge, TXN3767KSkibinski Jan Joseph · Midlothian, VAN3770KBalint Jozef · Fort Worth, TXN3772KSale Reported · Crestline, CASale reportedN3773KHansen Ernest F · Sequim, WAN3782KRegistered aircraftN3783KAndrews Nathan S · Graham, WAN3785KBartholomew Don · Gardnerville, NVN3787KStearns Edwin Ben Jr · Chandler, AZN3788KSwift Museum Foundation Inc · Athens, TNN3793KVolpe Francis B · Boynton Beach, FLN3796KFletcher Larry · Fairhope, AL
Back to AD 47-06-01