Kingsbury, TX
Registered aircraft · 39
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 = 'KINGSBURY' 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 = 'KINGSBURY' 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.
N11850Curtiss Wright JR CW1 · S/N 1224N14302Fairchild 22 C7D · S/N 915N14HDDahler Harley DORMOY BATHTUB · S/N 143N15896Rearwin 7000 · S/N 477N163PAuster AOP 9 · S/N XP-277N16570Aeronca C-3 · S/N A706N1909EJunge Julius BLERIOT XI · S/N VA1N1917HFreeman Roger FOKKER DR.1 · S/N VA4N1918HSchuetzeberg Fritz FOKKER D-VII · S/N VA3N1932GFreeman Roger M PIETENPOL SKY SCOUT · S/N VA2N2096EAeronca 7AC · S/N 7AC-5666N2104EChampion AERONCA 7AC · S/N 7AC5673N25144Luscombe 8A · S/N 1068N252NInland W500 · S/N W-512N308FHatch Vernon JN-4C · S/N C-308N318YWilcox GREAT LAKES REPLICA · S/N 6829-D-367N3229Curtiss Aeroplane & Motor CURTISS JN-4D · S/N 3229N322FDBoeing A75N1 · S/N 75-1790N34310Meyers OTW · S/N 53N37AZPiper J-2 · S/N 1926N3880PThomas Morse S4C · S/N 38802N3885LThomas Morse S4C · S/N 38850N38882Thomas Morse S4C · S/N 38882N38923Freeman THOMAS MORSE S4C · S/N 1N43133Taylorcraft BC12D-85 · S/N 6792N4534Waco GXE · S/N 1381N592HRearwin 2000-C · S/N 103N598EFStandard STANDARD J-1 · S/N T-4598N6337Binski Norbert SOPWITH F 1 · S/N N6337N6525UMooney M20C · S/N 2308N66YYErcoupe 415-C · S/N 1643N7563Fairchild KR-31 · S/N 200N761VAThomas Morse S-5 · S/N 761N8111COdell Bob R TURBO GOLDEN · S/N B2002N8152Binski Norbert AUSTIN S E 5A · S/N F8157N8225Eaglerock A-1 · S/N 790N85563Aeronca 7DC · S/N 7AC-4305N88313Piper J3C-65 · S/N 15931N92911Rearwin 185 · S/N 1643
Back to Kingsbury, TX