Granbury, TX
Registered aircraft · 360
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 = 'GRANBURY' 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 = 'GRANBURY' 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.
N10144Cessna 150L · S/N 15074807N1015TDiamond Aircraft Ind DA 40 NG · S/N 40.NC149N1032VCessna R172K · S/N R1722088N105JMCessna 182T · S/N 18281743N105XPAlfred S Damazio PANTHER · S/N 105N107SWSamuel Scott / George Wishon PANTHER · S/N 107N107XLStephen D Greene DR-107L · S/N 323N1085PWeiler Douglas C RV-4 · S/N 2649N10REDrake William L RV-10 · S/N 40807N110ACLenehan Jack BAKENG DUCE · S/N 12316519N110KKReiter Brian J RV-10 · S/N 40520N113FPColumbia Aircraft Mfg LC42-550FG · S/N 42546N11779Cessna 150L · S/N 15075627N117DAAtwell Douglas J VM-1 ESQUAL · S/N E180045N1181JAero Commander 112 · S/N 181N11DPPolen SPECIAL II · S/N 2N11HHoeffel Jan HOEFFEL SX300 · S/N 13N1228KCostruzioni Aeronautiche Tecna ASTORE · S/N 058N123SCScott Shawn C VAN'S RV-4 · S/N 3563N124AGPiper PA-31-350 · S/N 31-7852103N125JEVans RV-12 · S/N 120889N125WMGordon Hardy MUSTANG II · S/N M-II-654N126DACessna 172N · S/N 17270977N1302CColumbia Aircraft Mfg LC41-550FG · S/N 41632N134DGHigher Class HORNET · S/N 0052N1388TPiper PA-28-180 · S/N 28-7205293N143CWWilliams Charles H GLASAIR III · S/N 3269N143EBBarnard Stephen B RV-10 · S/N 40307N143MMark Morton MTOSPORT 2017 · S/N M02033N1475EAeronca 7AC · S/N 7AC-5038N147CVHouston Traville S RV-9A · S/N 91050N1492RGrumman American Avn. AA-1B · S/N AA1B-0592N150LMMcelroy Lloyd RV7A · S/N 72529N162DAAnderson Dale ANDERSON-ROTORWAY · S/N 6562N169FSDooley Peter C/Brown Richard K RV8 · S/N 83635N16MASchempp-Hirth VENTUS-2B · S/N 104N174KBBlack Kliffton M KITFOX S7 STI · S/N KA20318469N1757DCessna 170A · S/N 20200N1778VCessna 140 · S/N 13963N184PMCirrus Design SR22T · S/N 1234N186BBeech G35 · S/N D-4484N18WBWilliam A Beasley ELA/EVO · S/N 07226801025N190CUniversal Stinson 108-2 · S/N 108-3190N190RLBeech E-90 · S/N LW-1N197CHHuneycutt Cecil D RV-6A · S/N 21634N19CFBell UH-1H · S/N 66-01145N1KPCessna T210L · S/N 21060006N200MBBellanca 7GCBC · S/N 405-72N20842Cessna 182P · S/N 18261249N210THCessna 210M · S/N 21061574
Back to Granbury, TX