Jacksonville, FL
Registered aircraft · 507
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 = 'JACKSONVILLE' 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 = 'JACKSONVILLE' 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.
N10096Cessna 150L · S/N 15074791N1027TMooney M20R · S/N 290307N102WMPiper PA-31-350 · S/N 31-8152112N103JPBell Textron Canada 407 · S/N 54946N1066HBeech 58 · S/N TH-1766N106AFCessna 172R · S/N 17281055N1084HHead Balloons AX7-77 · S/N 101N108LPedano Stephen W PANTHER LS · S/N 0097N10GSCessna 150D · S/N 15060587N10YPTextron 208 · S/N 20800666N11366Cessna 150L · S/N 15075356Registration pendingN113NDCessna 150H · S/N 15067823N1149PMooney M20K · S/N 25-0609N115MSMooney M20J · S/N 24-0031N116DECirrus Design SR22T · S/N 1934N117DMBeech 19A · S/N MB-381N1180MCessna 172K · S/N 17258680N11BPPitts S-1C · S/N 11BPN12016Maule M-4 · S/N 26N120JWRaytheon HAWKER 800XP · S/N 258672N12150Cessna 172M · S/N 17261845N12704Cessna 172M · S/N 17262192N1300QCessna 150L · S/N 15072600N1303ACirrus Design SR22 · S/N 3712N132KSWaco Classic YMF-F5C · S/N F5C-8-132N132RSkyrunner MK 3.2 · S/N 719MK32912E601007N133KSRaytheon HAWKER 800XP · S/N 258697N1348VCessna R172K · S/N R1722176N134CTFlight Design CTSW · S/N 06-09-10N135VBBeech V35B · S/N D-10263N13752Cessna 172M · S/N 17262993N13810Cessna 172M · S/N 17263012N138GBAmerican Champion 8GCBC · S/N 473-2005N13HLCessna 421B · S/N 421B0927N13NFNorris RANS S7-S · S/N 0205395N142BHBuddy F Henson HENSON PANTHER · S/N P017N144CSLockheed P3B · S/N 153446N146CSLockheed P3B · S/N 5286N149CSLockheed P3B · S/N 154581N15051Piper PA-28-140 · S/N 28-7225570N15222Cessna 172S · S/N 172S10454N152DMCessna 152 · S/N 15280302N153CKCirrus Design SR22 · S/N 3451N154DBYakovlev YAK-54 · S/N 01002N154DJRaytheon 400A · S/N RK-175N154SMIrvin Frank W JR IRVIN CHLNGR II CWS · S/N CH2-1195-CW-1413N1600ZSchweizer 269C-1 · S/N 0248N1602WBeech G33 · S/N CD-1292N160WBCessna 175 · S/N 55238N162MBMichael Benson EXEC 90 · S/N 8100123A
Back to Jacksonville, FL