Rantoul, KS
Registered aircraft · 329
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
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_state = 'KS' AND g.registrant_city = 'RANTOUL' 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 = 'RANTOUL' 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.
N100AGRaytheon HAWKER 800XP · S/N 258747N109WGAgusta A109A II · S/N 7316N114BWCommander 114-B · S/N 14541N1163AMooney M20K · S/N 25-0666N118RJIsrael Aircraft Industries 1124 · S/N 188N1212CCessna 441 · S/N 441-0346N1216NCirrus Design SR22 · S/N 0549First renewal noticeN135AEEurocopter Deutschland EC 135 P2+ · S/N 1127N145KKCessna 560 · S/N 560-0276N146SLPiaggio P180 · S/N 1091N148JRCessna 560XL · S/N 560-5043N14PSFleet Edward S1S · S/N 7EF-25N150EXIsrael Aircraft Industries 1124 · S/N 262N150TXDassault-Breguet FALCON 50 · S/N 13N1552DBeech C90A · S/N LJ-1204N1597MCessna 182P · S/N 18264387N15BAIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 020First renewal noticeN15PMBeech A36 · S/N E-1016N163JRCanadair CL-600-2A12 · S/N 3057N163TCCessna 510 · S/N 510-0039N167UBeech 60 · S/N P-99N16CSLearjet 60 · S/N 098N173DPIsrael Aircraft Industries ASTRA SPX · S/N 103N1744XCessna 210L · S/N 21060765N176DPSikorsky S-76B · S/N 760356N177VVCessna 525 · S/N 525-0182N178WBeech 95-B55 (T42A) · S/N TC-2096N1805DBeech A36TC · S/N EA-233N1815JPiper PA-28-140 · S/N 28-24244N182PBAir Tractor AT-402 · S/N 402-0806N183DMRaytheon Corporate Jets HAWKER 800XP · S/N 258335N184RAWSK PZL Mielec M-18A · S/N 1Z013-30N1872HPiper PA-31-350 · S/N 31-7652053N189RBDassault-Breguet MYSTERE FALCON 20-F5 · S/N 262N190SADassault FALCON 2000 · S/N 190N191KMCirrus Design SR22 · S/N 0017N1927GIsrael Aerospace Industriesltd GULFSTREAM G150 · S/N 261N192CSPiper PA-31P · S/N 31P-7300138N1930VCessna 172M · S/N 17263798First renewal noticeN199NDBeech KING AIR A200CT · S/N BP-025N199PLBeech E-90 · S/N LW-167N200PRRaytheon 390 · S/N RB-79N204PMCessna 550 · S/N 550-0320N205DJDassault-Breguet MYSTERE FALCON 20-F5 · S/N 399N20FJDassault/Sud FAN JET FALCON · S/N 119N212FJDassault-Breguet FALCON 10 · S/N 147N213AVBeech C-99 · S/N U-213N215NCRaytheon A36 · S/N E-3444N217MLBeech 200 · S/N BB739N220CVDassault-Breguet FALCON 10 · S/N 220First renewal notice
Back to Rantoul, KS