Grapevine, TX
Registered aircraft · 77
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 = 'GRAPEVINE' 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 = 'GRAPEVINE' 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.
N103RLDJI AGRAS T30 · S/N 1581F446CKAM00300640N1098DCessna 195 · S/N 7710N114MKMaule MX-7-235 · S/N 10022-CN1243LConsolidated Aeronautics LAKE LA-4-200 · S/N 742N182HPCessna 182Q · S/N 18266509N222LABeech 200 · S/N BB-409N233SPPiper PA-28-160 · S/N 28-223N23530Textron T206H · S/N T20609691Registration pendingN247Snyder John B RV6A · S/N 23846N249LSRobinson Helicopter R66 · S/N 1386N28CXNorth American T-28C · S/N 140488N28EPNorth American T-28B · S/N BU#138175N29910North American AT-6D · S/N 88-13581N307JSRaytheon A36 · S/N E-3268N3315TCessna 177 · S/N 17700615N33TCGlobe GC-1B · S/N 2106N351JMMcgrew James C RV-8 · S/N 81655N35748Cessna 172I · S/N 17256950N3639UCessna 182F · S/N 18255039N396PCClark Patrick S PITTS S1 TM · S/N PC1989N3VBCessna 320D · S/N 320D0044N40617Maule M-4-220C · S/N 2140CN4079XAero Commander 100-180 · S/N 5179N4137BBellanca 17-30A · S/N 75-30738N41BHBeech F33A · S/N CE-1695N444RUBeech V35B · S/N D-9441N45663Cessna 150M · S/N 15077013N463GGriffin James Howard GRIFFIN SPECIAL · S/N 001N4707VCessna 195 · S/N 7275N477DPiper PA-32R-300 · S/N 32R-7780367N4FHBeech V35B · S/N D-9973N50FPAeros AEROS-2 · S/N 068N521SCCessna 210M · S/N 21062343N541Hughes Helicopters HUGHES 369D · S/N 711023DN5475SCessna 337B · S/N 337-0575N5501ECessna 150 · S/N 17001N557CBEurocopter AS 350 B2 · S/N 3431N56487Piper PA-28-140 · S/N 28-73-25639N5870PPiper PA-24-250 · S/N 24-953N60548Cessna 150J · S/N 15070392N6479SBoeing A75N1 · S/N 752468N666BSCessna 180E · S/N 18051179N678LBPiper PA-32-300 · S/N 32-7340062N7083LCessna 310K · S/N 310K0183N7092PPiper PA-24-250 · S/N 24-2246N73609Fairchild M-62C(PT-23A) · S/N FT-809N736DZCessna TR182 · S/N R18200722N761HYTed W Harrison F4 RAIDER · S/N 214N7680RBeech B19 · S/N MB-502N77212Cessna 120 · S/N 11674
Back to Grapevine, TX