Crescent City, FL
Registered aircraft · 46
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 = 'FL' AND g.registrant_city = 'CRESCENT CITY' 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 = 'FL' AND g.registrant_city = 'CRESCENT CITY' 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.
N1121HHurdle James PANTHER LS · S/N 0028N114KRockwell International 114A · S/N 14519N12SFConsolidated Aeronautics LAKE LA-4-200 · S/N 814N159ERPiper PA-28-161 · S/N 2841211N1697GChampion 7ECA · S/N 581N185RWCessna A185E · S/N 18502060N18PJO'Neil PL-4A · S/N 18N212BAeropro CZ S R O A240 · S/N 51417N2236Raymond L Willis WILLIS 1 · S/N RW001N2782BAero Commander 560-E · S/N 559N3064WBeech V35B · S/N D-9553N3566YCessna 182F · S/N 18254466N37MQAeromot AMT-200S · S/N 200-156N39818Bellanca 17-30A · S/N 73-30511N40250Spirit Engineering SE-1 · S/N 017N4359RCessna TR182 · S/N R18200593N45559Amador Frank Donny AVID ACFT MAGNUM · S/N 52N45688Luscombe 8A · S/N 2215N460JFFugate Joseph C PITTS SPECIAL S1S · S/N JCF001N52389Cessna 182P · S/N 18262572N55PZCub Crafters PA18-150 · S/N 9971CCN560TCCacek Tom VELOCITY · S/N TC2N5703Van Cleave BARNETT J4B · S/N 069N6068FCessna 182P · S/N 18264084N611APBellanca 8GCBC · S/N 317-79N626APBellanca 8GCBC · S/N 176-75N6458HPiper J3C-65 · S/N 19637N66DLDehavilland DHC-1B-2-S5 · S/N 158/196N66ZMStamp Michael R WITTMAN W8 TAILWIND · S/N PFA 031-10259N686NTL Ultralight Sro STINGSPORT · S/N TLUSA 140N714WCCharles M Schwab III JA20 JUST ACFT HGHLN · S/N JA564-9-19N7373GRobinson Helicopter R22 BETA · S/N 3739N740BCCessna L-19E · S/N 24724N747RJDavid Johnston VANS RV-10 · S/N 41531N76225Cessna 140 · S/N 10628N767TRBarber Steven L SEAREY LSX · S/N 1LK559CN7754YProgressive Aerodyne SEAREY LSA · S/N 1104N777VMAero Commander 520 · S/N 520-125N78405Piper J3C-65 · S/N 23146N852BLLewis Brandon Scott SEARAY · S/N 1MK411CN871FFunk Kevin M.D. COZY MARK 4 · S/N 21N914RXWarren Robert WARREN SEAREY · S/N 1MK453CN924EDodge Robert DODGE RV4-2 · S/N 002N9624ACessna 140A · S/N 15345N964UECharles W Rogers ROTORWAY 162 · S/N 8164N999DVMartin Michael Joe RV8 · S/N 81596
Back to Crescent City, FL