Frankston, TX
Registered aircraft · 49
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 = 'FRANKSTON' 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 = 'FRANKSTON' 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.
N100THHedding Tim EAA BIPLANE P2 · S/N 001THN116TPiper PA-18 105 · S/N 18-2230N118DTDenham J W/Baker W M THORP · S/N T1853N1517SCulver Robert J SONEX · S/N SNX1517N184GMMatejcek Glen J RV-8 · S/N 001N1903YPowrachute PEGASUS · S/N A415PEGN192CWCessna R172K · S/N R1723092N199CBGrumman American Avn. AA-5A · S/N AA5A0226N293RVAnnis Steve W RV6 · S/N 21225N3028GCessna 162 · S/N 16200095N373GHHaley Greg VANS RV-7 · S/N 73495N381WSWilliam Sallee VANS RV-7 · S/N 73800N41497Piper PA-28-140 · S/N 28-7425249N4258DBeech G35 · S/N D-4473N42VFSchultz Robert B VANS RV 8 · S/N 83091N452JRRobberson II Joe F S-7S · S/N 0414606N4672FCessna P206A · S/N P206-0272N4974ZPiper PA-22-108 · S/N 22-8579N513RSClassic WACO YMF · S/N F5C-049N521ECGlenn C Mathis JR RANS S-21 OUTBOUND · S/N 08220280N54517William French FOKKER DR 1 · S/N 001N5575VPeer JUNIOR ACE "E" · S/N E163N575GTSchmidt Charles W VANS RV-8 · S/N 80919N5842FCessna 210G · S/N 21058842N6082Beech C-45 · S/N 45-1207N6255UMooney M20C · S/N 2094N6357HPiper J3C-65 · S/N 19536N6460KRepublic RC-3 · S/N 711N6490KRepublic RC-3 · S/N 752N66740Boeing A75N1(PT17) · S/N 75-2360N7059ACessna 172 · S/N 29159N742TBYoung BOWERS FLYBABY · S/N 01AN75066Piper J3C-65 · S/N 43-535N7571CForney F-1 · S/N 5688N7770JRobert James Heckel JUST ACFT HIGHLANDER · S/N JA631-06-21N791BCBryan L Chilson SPORTSMAN GS-2 · S/N 7113N81757Aeronca 7AC · S/N 7AC-378N8335EMooney M20A · S/N 1513N83476Piper PA-18-150 · S/N 18-7609147N8457UCessna 172F · S/N 17252357N8788GCessna 150F · S/N 15062888N886DStinson 108-2 · S/N 108-2886N8992VCessna 172M · S/N 17264347N9407SBeech V35 · S/N D-8012N95367Taylorcraft BC12-D · S/N 9767N955RCotton Robin M QUICKSILVER SPORT 2S · S/N 4505N956LWZlin Aviation Sro SAVAGE CLASSIC · S/N 375N97MAero Commander 200D · S/N 302N98DLLederle Arthur ZODIAC 601 HDS · S/N 3865
Back to Frankston, TX