Knutson Wayne R
Registered aircraft · 92
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'KNUTSON WAYNE R' OR list_contains(g.other_registrant_names, 'KNUTSON WAYNE R') ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'KNUTSON WAYNE R' OR list_contains(g.other_registrant_names, 'KNUTSON WAYNE R') ORDER BY g.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.
N1111APiper PA-18-125 · S/N 18-703N12EKBoeing A75 · S/N 75-199N1637SSnow 600-S2C · S/N 600-1186CN1683SSnow 600-S2C · S/N 600-1266CN1953NPiper PA-11 · S/N 11-820First renewal noticeN2070CStinson 108-1 · S/N 108-1004N2166APiper PA-20-135 · S/N 20-892N2235JCessna 150 · S/N 150-65435N22385Cessna 150H · S/N 15068248N2452RCessna 182G · S/N 182-55552N2763UCessna 172D · S/N 17250363N28801Hiller UH-12D · S/N 1218N30384Cessna 150F · S/N 15064473N3053PPiper PA-11 · S/N 11-895First renewal noticeN3132LBeech C24R · S/N MC563First renewal noticeN3209NPiper J3C-65 · S/N 22401N3385NPiper J3C-65 · S/N 22585N3570CCessna 170B · S/N 26614N3801PPiper PA-22-150 · S/N 22-3490N3857ZPiper PA-18-150 · S/N 18-7622N3976YCessna 210D · S/N 210-58476N40107Universal Stinson 108 · S/N 108-37First renewal noticeN4046EAeronca 11BC · S/N 11BC135First renewal noticeN4083XAero Commander 100-180 · S/N 5183N4142BAero Commander 520 · S/N 520-47N4175ZPiper PA-28-140 · S/N 28-22170First renewal noticeN43832Ercoupe 415-C · S/N 178N44147Piper PA-25-150 · S/N 25-49N4479YPiper PA-25-235 · S/N 25-4108N4538YPiper PA-25-235 · S/N 25-4184First renewal noticeN4563ZPiper PA-22-108 · S/N 22-8070N46660Cessna 150G · S/N 15066075First renewal noticeN4693YPiper PA-25-235 · S/N 25-4424N4772YPiper PA-25-235 · S/N 25-4535N4897YPiper PA-25-235 · S/N 25-4704N50850Cessna 150J · S/N 15069596N51156Cessna 150J · S/N 15069801N5161DCessna 182A · S/N 51261N5173UCessna 206 · S/N 206-0173N5199MTaylorcraft BC12-D · S/N 10499N5417BCessna 182 · S/N 33417N5572HPiper PA-11 · S/N 11-964N5680JCessna A188A · S/N 18800630N5692ACessna 172 · S/N 28292First renewal noticeN5812ECessna 150 · S/N 17312N5912XBrantly B-2 · S/N 48N6095QPiper J3C-65 · S/N 19769First renewal noticeN6203ZPiper PA-25 · S/N 25-241N6239ECessna 172 · S/N 46339First renewal noticeN6241WPiper PA-28-140 · S/N 28-20284First renewal notice
Back to Knutson Wayne R