Frisco, TX
Registered aircraft · 597
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 = 'FRISCO' 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 = 'FRISCO' 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.
N101KBKenneth R Bochman RV10 · S/N 42607N1031SCessna 152 · S/N 15279996N10VBMicket Roberta GLASAIR 1FT · S/N 375N110LBArbc Inc DBA Lindstrand 105A · S/N 5224N111VBShield Ai V-BAT · S/N VB-100250N11KMCirrus Design SR22T · S/N 9436N1388RGrumman American Avn. AA-5 · S/N AA5-0788N141KBKenneth R Bochman RV 14A · S/N 140279N1437TPiper PA-28-140 · S/N 28-7225514N144CACessna 650 · S/N 650-7004N1462XPiper PA-28-140 · S/N 28-7525300N147VBShield Ai V-BAT · S/N VB-100252N1563BBeech F33A · S/N CE-1776N156KBDJI AGRAS T40 · S/N 1581F574B239100100KYN159KBDJI AGRAS T40 · S/N 1581F574B23870010017N1826ZShield Ai V-BAT · S/N VB-100121N18273Beech 95-B55 (T42A) · S/N TC-2065N1829ZShield Ai V-BAT · S/N VB-100122N1832ZShield Ai V-BAT · S/N VB-100123N18381Beech F33A · S/N CE-732N1841ZShield Ai V-BAT · S/N VB-100124N1849ZShield Ai V-BAT · S/N VB-100125N184VBShield Ai V-BAT · S/N VB-100260N1851ZShield Ai V-BAT · S/N VB-100127N1853ZShield Ai V-BAT · S/N VB-100126N1855ZShield Ai V-BAT · S/N VB-100128N1857ZShield Ai V-BAT · S/N VB-100129N1863ZShield Ai V-BAT · S/N VB-100130N188VBShield Ai V-BAT · S/N VB-100251N1917LBeech C23 · S/N M-1817N1935LBeech B19 · S/N MB-797N195UCessna 195B · S/N 7705N1972GAmerican AA-5 · S/N AA5-0157N1DCGulfstream Aerospace G-V · S/N 651N1MFBeech 58 · S/N TH-835N2008ADJI MAVIC 3 ENTERPRISE · S/N 1581F5FHD236L00D7091N2043FShield Ai V-BAT · S/N VB-100146N204VGShield Ai V-BAT · S/N VB-100147N2051SShield Ai V-BAT · S/N VB-100157N2053SShield Ai V-BAT · S/N VB-100166N2058UShield Ai V-BAT · S/N VB-100158N2059SShield Ai V-BAT · S/N VB-100152N205SZShield Ai V-BAT · S/N VB-100165N205WSShield Ai V-BAT · S/N VB-100164N2060AShield Ai V-BAT · S/N VB-100161N2062SShield Ai V-BAT · S/N VB-100160N2066SShield Ai V-BAT · S/N VB-100154N2068UShield Ai V-BAT · S/N VB-100151N206HSShield Ai V-BAT · S/N VB-100167N206PRShield Ai V-BAT · S/N VB-100163
Back to Frisco, TX