Live Oak, FL
Registered aircraft · 107
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 = 'LIVE OAK' 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 = 'LIVE OAK' 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.
N10968Curtiss Wright JR CW1 · S/N 1146N1099SHanes Steven G HIGHLANDER · S/N JAESC0080N10KPBoeing A75N1(PT17) · S/N 755247N1121Aeronca 7DC · S/N 47-1267N116RMJ&J Ultralights TUKAN · S/N RDM-3913N1192JAmerican General Acft AG5B · S/N 10027N1260YCessna 150B · S/N 15059660N13801Stinson JR. SR · S/N 8755N14592Stinson SR-5 · S/N 9333AN14632Aeronca C-3 · S/N A-518N15170Stinson SR-6 · S/N 9647N1602EChampion 7AC · S/N 7AC-516N16122Stinson SR-7B · S/N 9684N17116Stinson SR-8C · S/N 9801N17190Stinson SR-9C · S/N 5173N171HBAeronca 7AC · S/N 7AC-2169N184ABSellers Robert L CHALLENGER II · S/N CH2-1975N19502Piper J-2 · S/N 1702N19716Aeronca KC · S/N K228N19744Aeronca K · S/N K260N2032LLake LA-4 · S/N 365N21309Aeronca 50-C · S/N C-1148N21354Aeronca 65-C · S/N C-1598N2146ACessna 182T · S/N 18281265N2308Stinson SR-10J3 · S/N 5924N2502FChampion 7ECA · S/N 152N251AWMcevoy Peter R RANS S-6ES COYOTE II · S/N 06021446N2570FChampion 7ECA · S/N 201N25BKBoltair SEAWIND 3000 · S/N 26N2614George Matthew Wagoner ZENITH 601 HD · S/N 6-8820N26374Aeronca 65-C · S/N C8370N2743LCessna 172H · S/N 17255943N2772MPiper PA-12 · S/N 12-1245N28099Piper J3C-65 · S/N 4577N28880Luscombe 8B · S/N 1622N3004ACessna 170B · S/N 25648N301KMPyle Kent E SPACEWALKER II · S/N 001KEPN3109EAeronca 7CCM · S/N 7AC-6706N3115LCurtiss-Robertson ROBIN · S/N 55N3141HHolton Loye W ZENITH ZODIAC · S/N 6081N315YGrumman American Avn. AA-5B · S/N AA5B-0532N3239MSzybowcowy Zaklad Doswiadczaln 41A JANTAR STANDARD · S/N B712N323ECurtiss Wright ROBIN · S/N 288N323JCurtiss Wright ROBIN C-2 · S/N 480N323RStinson SR-9C · S/N 5324N3312EAeronca 7AC · S/N 7AC-6756N33738Aeronca 65-CA · S/N C13061N337XCahill William F BOWERSFLY BABY 1A · S/N 1C71N34130Commonwealth REARWIN 185 · S/N 1835N34SSSellers Craig S KR-2 · S/N 1
Back to Live Oak, FL