Registered aircraft · 25

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 = 'NE' AND g.registrant_city = 'OGALLALA' 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 = 'NE' AND g.registrant_city = 'OGALLALA'
  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 = 'NE' AND g.registrant_city = 'OGALLALA'
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.

N113YXRothe Brian D WAIEX · S/N WO113Built 2009 · Oneil Conn W N115CMMaupin Clay C SPACE WALKER II · S/N CM01Built 1999 · Oneil Conn W N1163YCessna 150B · S/N 15059563Built 1962 · Wyatt Airventures LLC N119CLConn Oneil WAIEX · S/N W0150Built 2016 · Oneil Conn W N1594YCessna 172C · S/N 17249294Sexson Lance Mason N222RVMartens S / Martens E RV-4 · S/N 2305Built 1992 · Wyatt Jacob A N2422BTemco GC-1B · S/N 3722Built 1949 · Roki Classics LLC N2465GCessna 182B · S/N 51765Built 1959 · Munson Darrel L N336BWLatham David T RV-4 · S/N 4352Built 2001 · Allen Scott L N3679KPiper J3C-65 · S/N 22370Built 1946 · Barnhill Marcia Trustee N3793EAeronca 11AC · S/N 11AC-S-16Built 1947 · Allen Scott L N39230Taylorcraft BC12-D · S/N 6484Built 1945 · Frerichs Kevini M N4576DBeech G35 · S/N D-4755Built 1956 · Djm LLC N488MMIndian Michael J MURPHY RENEGADE SPIR · S/N 0488Built 1996 · Oneil Conn W N5025FBellanca 7GCBC · S/N 1054-78Built 1978 · Allen Scott L N597JJabiru USA Sport J250-SP · S/N 425Built 2007 · Wach Jared L N6109ZQuad City Ultralight Acft CHALLENGER II · S/N 688 7485Built 2005 · Frerichs Kevin M N61941Housman Bert B JENNY JN4-D · S/N 348516Built 2000 · Oneil Conn W N619CWRans S6ES · S/N 06271952Built 1992 · Oneil Conn W N626PDCessna T182T · S/N T18208547Built 2006 · C S A Inc N666TJSix Chuter SR7 XL · S/N 2588Built 2000 · Simeon Jim N85870Aeronca 11AC · S/N 11AC-282Built 1946 · Allen Scott L N8788DPiper PA-18-150 · S/N 18-6325Built 1958 · Martens Edwin L N97AFGenre Agile F JR VANS ACFT RV4 · S/N 2118Built 1997 · Armstrong Aviation LLC N9GNMooney M20E · S/N 639Built 1965 · Gudgel Scott A

Back to Ogallala, NE