Jacksonville, TX
Registered aircraft · 45
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 = 'TX' 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 = 'TX' 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.
N1717XCessna T210G · S/N T2100267N1798VCessna 140 · S/N 13983N1883KLuscombe 8E · S/N 4610N1902KLuscombe 8E · S/N 4629N206PBeech 200 · S/N BB-466N2086KLuscombe 8A · S/N 4813N2118BLuscombe 8E · S/N 6545N2189BLuscombe 8E · S/N 6616N224JWCessna 560XL · S/N 560-6120N2320KLuscombe 8E · S/N 5047N2409HEngineering & Research ERCOUPE 415-C · S/N 3034N2623GCessna 182B · S/N 51923N2821SCessna 150G · S/N 15066721N3405MPiper PA-28R-201T · S/N 28R-7803169N34587Aeronca 65-CA · S/N C-15831N358ZBeech 35-A33 · S/N CD-240N359BWRans Designs S-7LS · S/N 1214703N428MGCessna 525 · S/N 525-0457N43520Mitchell Harvey D RANS S-6ES · S/N 02051636N45494Luscombe 8A · S/N 2021N518TXCessna 560 · S/N 560-0222N525GCCessna 525 · S/N 5250065N560TXCessna 560 · S/N 560-0382N569TACessna 560 · S/N 560-0006N596JJabiru USA Sport J250-SP · S/N 424N61547Cessna 172M · S/N 17264630N6804ECessna 175A · S/N 56304N71326Cessna 182M · S/N 18259580N72009Luscombe 8A · S/N 3436N72066Silvaire LUSCOMBE 8A · S/N 3493N72759Cessna 120 · S/N 9942N76121Cessna 120 · S/N 10518N77837Luscombe 8A · S/N 3564N791EBBeech 200 · S/N BB791N825KABeech 200 · S/N BB-825N83029Piper PA-28-236 · S/N 28-8311005N8389NBeech V35A · S/N D-8774N8585TCessna 182C · S/N 52485N868RBCanadair CL-600-2B16 · S/N 5128N89309Cessna 140 · S/N 8337N89715Cessna 140 · S/N 8764N95247Taylorcraft BC12-D · S/N 9647N95ABGulfstream Aerospace 695A · S/N 96012N970MGRecreational RANS S-12 · S/N 0293392Sale reported, pending cancellationN999DTBeech 200 · S/N BB-138
Back to Jacksonville, TX