Registered aircraft · 25

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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_state = 'KS' AND g.registrant_city = 'ROSE HILL' ORDER BY g.n_number

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_state = 'KS' AND g.registrant_city = 'ROSE HILL'
  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_state = 'KS' AND g.registrant_city = 'ROSE HILL'
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.

N102JTTaylor Jeffrey Loren THORP S-18 · S/N 190Built 1997 · Brady George K N107AZSharp-Rans S12 · S/N 0493394Built 2007 · Fitzgerald Brian J N1189EAeronca 7BCM · S/N 7BCM-4746Built 1946 · Robert William F II N124LGPayne David N HORIZON 1 · S/N H046Clark Ricky R N12GMMay George F JR KITFOX MODEL III · S/N 1034Built 2001 · Clark Ricky R N195RECessna 195B · S/N 7934Built 1952 · Ramey Robert L N19900Cessna 172M · S/N 17260847Built 1972 · Mcwhorter Christopher W N21075Aeronca KCA · S/N KCA-47Built 1950 · Towner Jeffery D N2524LCessna 172H · S/N 17255724Built 1966 · Graham Jacob W N277SSmith Jimmie A SONERAI IIL · S/N 00193Smith Jimmie A Trustee N2834MMichael R Snow RV-4 · S/N 2834Built 2023 · Tower Financial Strategies Corp N2951JCessna 150G · S/N 15065751Built 1966 · Johnston Robert G N2958SSmith Jimmie A RV-6 · S/N 23600Built 1998 · Smith Jimmie A Trustee N29TSSnedeker Frank E THORP T-18C · S/N 1037-C49Built 1990 · Brady George K N320EDDalbec Edward D LANCAIR 320 · S/N 1288Oday Shane C N379GSStrausheim George Glenn RV-4 · S/N 2098Smith Adam N4259VCessna 170 · S/N 18615Kurt Robert F N67884Boeing A75N1(PT17) · S/N 75-2505Snow Michael R DBA N6792SCessna 150H · S/N 15067592Built 1967 · Johnston Robert G N6944NMooney M-20G · S/N 680153Yates Gary Douglas N7125GCessna 172K · S/N 17258825First renewal noticeBuilt 1969 · Bohannan Joshua S N770CGGantzer Charles G PIETENPOL AIR CAMPER · S/N 001Gantzer Charles G N8675DDodds Kimball Dean MARK II · S/N M2-212Mcclure Milo D N8804RBellanca 14-19-3 · S/N 4156Built 1959 · Gouldsmith Marlene S N8922JPiper PA-28-180 · S/N 28-2939Built 1965 · Towner Jeffery D

Back to Rose Hill, KS