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.
N3210KBurrous Peter M · Mount Pleasant, SCN3214KGadis Anthony J · Etiwanda, CAN3224KBoronkay Peter H · Rockwall, TXN3230KMoore Michael C · Brooklyn, MIN3232KEastern Stearman Inc Trustee · Leesburg, VAN3235KRacoon Aviation LLC · San Antonio, TXN3240KJester Andrew R · Santa Claus, INN3242KPorter Thomas G · San Carlos, CAN3243KKadrich Mark S · Manteca, CAN3245KAdair Edward A · Hemet, CAN3246KRiggins Construction LLC · Show Low, AZN3247KKroll Cody A · Cincinnati, OHN3248KEngel Eberhard E · Northfield, MNN3252KCrnic Paul C · Chesterfield, MON3253KWarbird Adventures Inc · Ocoee, FLN3256KCreager Wes L Md · Hopkinsville, KYFirst renewal noticeN3257KKrueger Hendrick · Rockport, TXN3264KBudde Bobby M Jr · San Jose, CAN3267KShay John D · Covina, CAN3269KJones Michael R · Riverside, CAN3271KCameron Reginald B · Cumberland, MEN3283KSchultz John G · Independence, ORN3285KWoelbing Aviation LLC · Franksville, WIN3288KZahler Mitchell J · Stillwater, MNN3289KWayman Ian A · Peyton, CON3293KLegarra Mark · Redding, CAN3296KSwift Museum Foundation Inc · Athens, TNN3297KElevate780 LLC · Burlington, WIN3301KHarrison George B · Peachtree City, GAN3304KTomerlin Erin G · Napa, CAN3307KArbeau Denis M · Napa, CAN3308KHowell Harley L Jr · Colville, WAN3311KBartholomew Donald B · Gardnerville, NVN3312KGass William D Trustee · Mountain View, CAN3313KMckenney Bret K · Billings, MTN3315KBauerle Gerald F · Hammond, LAN3318KMace Wade L · Ottawa, KSN3321KReiff Christopher R · Mansfield, MAN3323KBurrous Peter M · Mount Pleasant, SCN3325KBartholomew Don · Gardnerville, NVN3327KBornheber Raif · DraskovicN3329KCalifornia Antique Aircraft Museum DBA · San Martin, CAN3331KWright Wayne M · Chestertown, MDFirst renewal noticeN33336Swift Museum Foundation Inc · Athens, TNN3333KOrtet Jon · Valley Springs, CAN333DKMalinchak Louis Trustee · Bristow, OKN3343KSel LLC · Dover, DEN3344KKremmling Flying Inc · Kremmling, CON3348KTribley Lori J · Magnolia, TXN3351KBartholomew Don B · Gardnerville, NV
Back to AD 47-06-01