Registered aircraft · 18

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'FULSHEAR' ORDER BY g.n_number

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 = 'FULSHEAR'
  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 = 'FULSHEAR'
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.

N10QGMark Chastain Fletcher VANS RV-10 · S/N 41473Fletcher Mark C N1420SCessna 182P · S/N 18264976Small Edward D N223LMPilatus PC-12/47E · S/N 1050Built 2008 · Lgp Hidden Oaks LLC N2597KCessna 180K · S/N 18053010Built 1978 · Crossno James N3048QCessna 182K · S/N 18258048Built 1967 · Bad Eagle Aviation LLC N419SBPiper PA-28-236 · S/N 2811034Built 1992 · Lipscomb Brian N455PRaytheon A36 · S/N E3276Built 1999 · N455p LLC N484HPPiper PA-34-220T · S/N 34-8133199Built 1981 · Fly With Kay LLC N51UUSergio Pensotti MAGNI M-24+ · S/N 24202926Built 2021 · Fbc Texas LLC N53ESCessna 180 · S/N 30053Spooner Brent N555CPCessna 340A · S/N 340A0651Built 1979 · Firebird Air LLC N5933ECessna 150 · S/N 17433Built 1959 · Fletcher Mark C N6978CKimbrough Geoffery D RV-8 · S/N 81554Built 2008 · Peschke Michael S N712RVVans RV-12 · S/N 120545Registration pendingBuilt 2012 N7699Grumman Acft ENG Cor-Schweizer G-164A · S/N 1004Built 1972 · Soucy Gene N777MXCessna 650 · S/N 650-0051Built 1984 · Airplane III LLC N853PATextron 172S · S/N 172S12286Built 2019 · Dk Skyhawk LLC N907BLBrian Lipscomb RV-14A · S/N 141150Lipscomb Brian William

Back to Fulshear, TX