Skip to content

Jonker Sailplanes JS3 RES

Registered aircraft · 12

Aircraft of this model 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 aircraft_model_code IN ('05640T1', '05641KC')
  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 aircraft_model_code IN ('05640T1', '05641KC')
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.

N111WRRuehle William R · Midlothian, TXBuilt 2023 · S/N 03-189 N143FSSilva Fernando · Atlanta, GABuilt 2023 · S/N 03-143 N145MSClark Harold R · Saint Johns, FLBuilt 2023 · S/N 03-145 N1KGMozer Eric H · Charlotte, NCBuilt 2023 · S/N 03-178 N233EGGonzalez John E · Malibu, CABuilt 2022 · S/N 03-121 N333TNNau Thomas W · San Antonio, TXBuilt 2022 · S/N 03-135 N335MHHostage Gilmary M III · Boerne, TXBuilt 2022 · S/N 03-105 N348NCCirrus 5100 LLC Trustee · Wilmington, DEBuilt 2002 · S/N 03-120 N37JGGillis John H · Elbert, COS/N 03-179 N435MHHostage Gilmary M III · Boerne, TXBuilt 2023 · S/N 03-186 N737AHHurtig Anders P · Las Vegas, NVBuilt 2023 · S/N 03-180 N883JSLee Philip G · San Jose, CABuilt 2022 · S/N 03-137

Back to Jonker Sailplanes JS3 RES