Cookeville, TN
Registered aircraft · 59
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 = 'TN' AND g.registrant_city = 'COOKEVILLE' 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 = 'TN' AND g.registrant_city = 'COOKEVILLE' 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.
N108FJDassault-Breguet MYSTERE FALCON 900 · S/N 108N114WCRockwell International 114 · S/N 14126N1278TPiper PA-28-140 · S/N 28-7225447N148SWCirrus Design SR22 · S/N 0987N174MCJared Bennett J HIGHLANDER · S/N JA582-04-20N17MCPiper PA-32-300 · S/N 32-40523N1872Bell 206C · S/N 3695N1DNBeech A35 · S/N D-1967N2004WBeech S35 · S/N D-7966N235PLMaule MX-7-235 · S/N 10039CN242REMooney M20TN · S/N 31-0020N2490AWilkinson Neil A FLIGHTSTAR SC · S/N SC001N2550EQuad City Ultralight Acft CHALLENGER II · S/N CH2-2373N269CTPilatus PC-12/45 · S/N 547N28168Bellanca 17-30A · S/N 79-30912N28195Bellanca 17-30A · S/N 79-30938N28575Grumman American Avn. AA-5B · S/N AA5B0690N292MWBeech A36 · S/N E-2862N30067Piper PA-28-181 · S/N 28-7990083N300PCBell OH-58 · S/N 71-20531N3020HEngineering & Research 415-D · S/N 3645N303KCBeech F33A · S/N CE-1138N3193HErcoupe 415-C · S/N 3818N321MAPiper PA-32R-301T · S/N 3257311N3250EAeronca 11AC · S/N 11AC-1623N337DCReims CESSNA F337H · S/N F33700086N340AHCessna 340A · S/N 340A0333N344DMDavid M Meyer AR-1 · S/N 0043N351MPRaytheon B300 · S/N FL-305N3855RCessna 172H · S/N 17255355N3912WPiper PA-32-260 · S/N 32-858N410MBMooney M20R · S/N 29-0505N482STPiper PA-32R-301T · S/N 3257482N5454MCirrus Design SR20 · S/N 1226N5874PDanny C Holder VANS RV7 · S/N 74084N60045Cessna 162 · S/N 16200127N64PSTwin Commander 690C · S/N 11702N656LDSocata TBM 700 · S/N 656N6592CCGS HAWK ARROW II · S/N HA-II-096-R583N68029Dehavilland DHC-1 SERIES 22 · S/N C1-0737N6864JPiper PA-32-300 · S/N 32-7640104N6FAAmerican AA-1A · S/N AA1A-333N708TECessna 172N · S/N 17270934N72727Cessna 177B · S/N 177-01678N73530Cessna 172M · S/N 17267531N74JVBeech 100 · S/N B-74N811DDPilatus PC-12/47E · S/N 1027N8199ZCessna 210-5(205) · S/N 205-0199N8364GPiper PA-28-181 · S/N 28-8190203N8402NBeech V35A · S/N D-8769
Back to Cookeville, TN