OpenAirDocs.org
Show Low, AZ

Registered aircraft · 28

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 = 'AZ' AND g.registrant_city = 'SHOW LOW'
  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.

N123PKKelley Lonny R LANCAIR ES · S/N LRK-017Built 1998 · Nunley LonnieN1600XCessna T210L · S/N 21060636Ld&B LLCN160APSikorsky UH-60L · S/N 86-24515Built 1986 · Aero Products Component Services IncN177XPCessna 177 · S/N 17700953Hills Denver LN1806WBeech 95-B55 (T42A) · S/N TC-1506N1806w LLCN1947YPiper PA-12 · S/N 12-3253Built 1947 · Bitterroot Ventures LLCN2066BLuscombe 8E · S/N 6493Built 1948 · Aeschlimann StephenN2471HEngineering & Research ERCOUPE 415-C · S/N 3096Built 1946 · Lord Jason TN270APSikorsky UH-60L · S/N 85-24453Built 1985 · Aero Products Component Services IncN313CWWolff Charles L REVOLUTION · S/N 1001Built 1996 · Jackson Kimberly LN316TVBell 206B · S/N 2704Built 1979 · Aero ProductsN3246KGlobe GC-1B · S/N 1239Built 1946 · Riggins Construction LLCN411BDSteppling William RANS S-7 · S/N 0501304Built 2003 · Fort Charles W JrN5487Piper PA-32-300 · S/N 32-40110Built 1967 · Rhj Investments LLCN60PJBell 206B · S/N 2349Built 1978 · Aero Products Component Services IncN6196GCessna 182T · S/N 18281397Built 2004 · First Air Service LLCN61991Cessna 172M · S/N 17264942Built 1975 · Keime ParkerN699PGPiper PA 46-350P · S/N 4636600Built 2013 · Brady Richard VN7284NCessna 182P · S/N 18263071Built 1974 · Mcbride KellyN745CDCirrus Design SR22 · S/N 0040Trujillo Dax KN758WWPiper PA-46-600TP · S/N 4698127Built 2020 · Sky King Az LLCN848TDDiede Thomas VANS RV-8 · S/N 80848Built 2002 · Krugh Patrick MN885MSMark Elliott Starks SLING TSI · S/N 341SKBuilt 2023 · Starks Mark ElliottN9170XPiper PA 46-350P · S/N 4622018Built 1989 · Vb IncN9565MCessna 182S · S/N 18280274Built 1998 · Bitterroot Ventures LLCN9692VCessna R172K · S/N R1722347Built 1977 · Show Low Flight Academy LLCN9921XCessna 185 · S/N 1850121Built 1961 · Winslow William G JrN993KTCessna 182Q · S/N 18266450Built 1978 · First Air Service LLC
Back to Show Low, AZ