Starkville, MS
Registered aircraft · 68
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 = 'MS' AND g.registrant_city = 'STARKVILLE' 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 = 'MS' AND g.registrant_city = 'STARKVILLE' 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.
N105JGMckibben Gerald H RV-6A · S/N 25159N12222Cessna 182T · S/N 18282003N12459Cessna 172M · S/N 17261996N141JWCirrus Design SR22T · S/N 0058N160WYTimothy J Diestel RV-8 · S/N 83608N182BCCessna 182P · S/N 18265071N1869GChampion 7GCAA · S/N 189N2071RPiper PA-28-180 · S/N 28-5452N217PCRaytheon A36 · S/N E-3330N221ECPiper PA-20 · S/N 20-979N2254GCessna 182A · S/N 51554N24284Aeronca 65-LA · S/N L-7540N257MTRobinson Helicopter R44 II · S/N 13535N2LYCessna 421C · S/N 421C0301N32LACessna 172L · S/N 17260454N3302DGeorge Clifford E VANS ACFT RV-4 · S/N 3302N3453BAerotechnik UH Hradiste L-13 SW · S/N 840003N3511EAeronca 7AC · S/N 7AC-6882N35165Cessna 177B · S/N 17702241N3548MCessna 182T · S/N 18281019N37880Cessna 319 · S/N 608N402MSWinward Performance OWL · S/N 002N411GMCessna 525B · S/N 525B0467N413MSWindward Performance OWL · S/N 003N41547Piper PA-28-151 · S/N 28-7415263N43153Taylorcraft BC12-D · S/N 6812N4327VCessna 195 · S/N 7270N455MSTeam Edge PIPER CUB · S/N 035N458MSNavmar Applied Sciences TIGER SHARK XP · S/N XP-011N459MSNavmar Applied Sciences RQ-23 TIGERSHARK BLO · S/N XP007N460MSNavmar Applied Sciences RQ-23 TIGERSHARK BLO · S/N XP008N461MSGriffon Aerospace G2 · S/N 040-4403N462MSGriffon Aerospace G2 · S/N 040-4404N463MSNavmar Applied Sciences TIGER SHARK XP · S/N XP-010N465MSNavmar Applied Sciences TEROS C · S/N TRC0003N466MSNavmar Applied Sciences TEROS C · S/N TRC0002N47905Piper PA-28-161 · S/N 28-7816155N53129Boeing A75N1(PT17) · S/N 75-1519N531CPCessna 150L · S/N 15074997Registration pendingN55401Piper PA-28-140 · S/N 28-7325405N558BTCessna 310P · S/N 310P0220N5672FAlon A2 · S/N A-172N57SPPrest STEEN SKYBOLT · S/N 2051N5809RCessna 172G · S/N 17253478N59901Boeing A75N1(PT17) · S/N 75-3379N6517LGrumman American Avn. AA-1B · S/N AA1B-0317N6558UMooney M20C · S/N 2305N662VBellanca 7KCAB · S/N 357-73N6966RBeech C23 · S/N M-1616N704CACessna 150M · S/N 15078495
Back to Starkville, MS