Skip to content

Kawasaki ALL MDLS A/B

Registered aircraft · 18

Aircraft with this engine in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('35500')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('35500')
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.

N13GKKramer George M · Deerbrook, WIBuilt 1998 · S/N 001 N14XCRobinson Kent A · Richardson, TXS/N 01 N20397Rich Burrus Y · Lakeland, FLBuilt 1983 · S/N R-101 N2676ACrider Vernon Dwayne · Barnhart, MOBuilt 1983 · S/N 001 N2798NMeigs Jonathan H · Corning, NYBuilt 2007 · S/N H-SSC-942-K-TRI N340DBKoza William J · Albert Lea, MNBuilt 1987 · S/N 950 N35LMBrown David J · Lexington, SCBuilt 2025 · S/N 350T N4903SLang John F · Alma, MIBuilt 1984 · S/N 359 N5566KCooper Jim A · Brookings, SDBuilt 1994 · S/N 631 N6130AGrageda Carlos R · Walla Walla, WABuilt 1989 · S/N 006 N6526ABloomfield Lloyd W · Adams, WIFirst renewal noticeBuilt 2009 · S/N 122 N7050USides Jerry W · Medina, TXBuilt 1993 · S/N 1918 N713KKNelson Retta · Grasston, MNBuilt 2003 · S/N HSI 001384 N747WFDressler David C · Mission Viejo, CAS/N FS-21000-585 N80667Harden Melvin R · Dalton, GABuilt 1981 · S/N FP-135-YB N8066VHarden Melvin R · Dalton, GABuilt 1983 · S/N FP-135-BW N921SLWalworth Joel E · Cocoa Beach, FLBuilt 2001 · S/N 717 N9JVVonlinsowe John E · Metamora, MIBuilt 1984 · S/N 0014D

Back to Kawasaki ALL MDLS A/B