Registered aircraft · 30

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

N1110TArlington SISU 1A · S/N 108Muxworthy Keaton A N12476Davis D-1-K · S/N 701Built 1931 · Wallace Terry Earl N1398YDJI MAVIC 3 ENTERPRISE · S/N 1581F5FHD22CD00C539PYazel Peebles & Associates LLC N16358Fairchild 24 C8E · S/N 2819Built 1936 · Wallace Terry E N18KKCessna 150L · S/N 15072224Built 1970 · Khalil Kal Mohamed N224MMPiper PA-28-140 · S/N 28-7225291Built 1972 · Young David A N2260MPiper PA-28-161 · S/N 28-7816264Built 1977 · Bomar Robert B N2337TRaytheon A36 · S/N E-3137Built 1997 · Pate Jason L N257SXOwens Don M SONEX · S/N 00257First renewal noticeBuilt 2008 · Owens Don M N303KJCessna T303 · S/N T303-00301Built 1984 · Brother Michael Andrew N3238QPiper PA-28-161 · S/N 28-7716145Built 1977 · Attitude And Configuration Indicator LLC N3346RCessna 182L · S/N 18258646Built 1968 · Gonzalez Oscar N36FFBeech A36 · S/N E-2893Built 1994 · Garr Aero Inc N3HRPiper PA-24-250 · S/N 24-3126Built 1962 · Dow Glendal R Trustee N4944CBeech D-45 · S/N BG-283Coke Richard N50PTCessna 150H · S/N 15069220Built 1968 · Jackson Michael W N515ZCFred Williams CRUZER · S/N 7510568Built 2018 · Beaulieu Walter G N569KMooney M20S · S/N 30-0026Built 1999 · Cross Timbers Aviation LLC N6676RMooney M20C · S/N 2866Built 1964 · Jackson Michael W N6791Beech N35 · S/N D-6791Built 1961 · Maschmeyer Thomas L N67GPPeterson Gary ZODIAC 601XL · S/N 6-4912Built 2005 · Good Impressions Aviation LLC N71262Cessna 182M · S/N 18259554Lavin Keith P N7442PPiper PA-24-250 · S/N 24-2631Balske Curt A N7845ECessna 150 · S/N 17645Built 1959 · Wallace Terry E N79SMMooney M20R · S/N 29-0028Built 1995 · Turbine Services And Consulting LLC N847JWCessna 172M · S/N 17266700Built 1976 · Moon Samuel C N889SLCessna 180A · S/N 50226Built 1958 · Cunningham Richard Scott N8941RChampion AERONCA 7HC · S/N 7HC-24Built 1960 · Hamme Curtis S N9319MMooney M20E · S/N 1251Built 1966 · Culberson Donald L N999WNMcbride Winn RV6 · S/N 24521Built 1999 · Burgess Ross W Trustee

Back to Bedford, TX