Chuckey, TN
Registered aircraft · 48
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 = 'CHUCKEY' 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 = 'CHUCKEY' 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.
N113CJCessna TR182 · S/N R18201076N139RVHiatt Bradley J RV-9A · S/N 90385N161ARJohn H Robinson ZENITH 750 CRUZER · S/N C75-10543N16RAConsolidated Aeronautics LAKE LA-4-200 · S/N 944N174RTThoma Roy E III RV-7A · S/N 73315N182JJCessna 182E · S/N 18254379N197SRickey Dyer SR M912 · S/N 197N203SCPiper PA-30 · S/N 30-1118N2961ACessna 180 · S/N 30161N32197Piper PA-32-300 · S/N 32-7540022N3602BFisher Steven C BEARHAWK PATROL · S/N 14P-35N/36N-P259N36077Piper PA-28-181 · S/N 28-7890492N36195Taylorcraft BC-65 · S/N 3115N37916Piper J3C-65 · S/N 6698N421JCessna 421C · S/N 421C0208N4635RPiper PA-28-140 · S/N 28-21386N4641RPiper PA-28-140 · S/N 28-21394N488BBBower Bruce C GN-1 PIENTENPOL · S/N EL-1-15-34-BBN4976LPiper PA-28-180 · S/N 28-4350N50LTExtra Flugzeugproduktions-Und EA 300/LT · S/N LT050N524JMJeffrey Piaott VANS RV8 · S/N 83062N54RDRickey Dyer SR ARGON 916 · S/N AR916-54RDN598PQJeffrey L Wilde KITFOX 7SS · S/N KA08156133N61JVCessna 421C · S/N 421C0097N627FFisher Steven C SKY DANCER · S/N 001N631AMStemme S10-V · S/N 14014N6430CStinson L-5 · S/N 1813N648YWaco INF · S/N 3384N6628FNichols Robert B BAKENG DUCE · S/N 002N679SMAlisport SILENT 2 ELECTRO · S/N 2066N702CStinson 108-3 · S/N 108-3702N7180ECessna 182B · S/N 52180N7297WPiper PA-28-180 · S/N 28-1150N738PRCessna R182 · S/N R18200951N83845Piper-Crockett J-4A · S/N 6-1529N87277Ercoupe 415-C · S/N 450N8764WPiper PA-28-235 · S/N 28-10304N8772XCessna 180D · S/N 18253172N8820JPiper PA-28-180 · S/N 28-2774N896CBBrunzlick Larry R SEAWIND 3000 EXPERIM · S/N 093N90106Cessna 140 · S/N 9167N914VMVans RV-12IS · S/N 121335N9168LCooper Herman A JR COOPER RV-6 · S/N 20812N917PBVans RV-12 · S/N 120971N9300LAmerican AA-1A · S/N AA1A-0200N944AGRotorsport UK ROTORSPORT UK CAVALO · S/N RSUK/CAVP/003N96080Taylorcraft BC12-D · S/N 8380N96KWTerrance Lee Daniel Weyant RV-14A · S/N 140975
Back to Chuckey, TN