Registered aircraft · 31

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 = 'AZ' AND g.registrant_city = 'SUN CITY' 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 = 'AZ' AND g.registrant_city = 'SUN CITY'
  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 = 'AZ' AND g.registrant_city = 'SUN CITY'
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.

N10378Schweizer SGS 1-26C · S/N 69Built 1960 · Lyon Richard K N107BWBlumer James Allen CHALLENGER II SPEC · S/N CH20291CW0647Built 1991 · Blumer James Allen N1512XPiper PA-32R-300 · S/N 32R-76800024js Inc DBA Great Country Motors N1520LFirefly Balloons FIREFLY 7-15 · S/N F7-2015Built 2002 · Parmley Tina N1522PBalloon Works FIREFLY 7 · S/N 11064Built 1981 · Parmley Tina N1823VCessna 120 · S/N 14150Built 1947 · Weller Oscar R N19516Cessna 150L · S/N 15074462Built 1973 · Choppin Dale N2019ZBeech A36 · S/N E-1322Tvat LLC N2803TPiper PA-28-140 · S/N 28-7225241Built 1972 · Barron David L N32BPHall Dennis L ONEX · S/N ONX0112Built 2014 · Nachor Emanuel N36249Bellanca 7GCBC · S/N 554-73Davis Gary L N37DTTimberlake David G VANS AIRCRAFT RV 7 · S/N 70245Built 2010 · Timberlake David G N4007JHead Balloons AX7-70R · S/N 436Built 2014 · Chain Of Events LLC N402PBeech F33A · S/N CE-1671Built 1992 · Walker Mickey R N505WJHead Balloons AX7-70R · S/N 494Built 2021 · Chain Of Events LLC N552BBeech V35 · S/N D-8524Built 1967 · Winkelbauer Kim G N5632JMooney M20J · S/N 24-1369Lawrence Jeffrey A N6139CForney F-1 · S/N 5608Built 1957 · Daughters Turpen A N6641GCessna 150L · S/N 15072141Built 1970 · Walborn Carl L N6886QBeech 35-B33 · S/N CD-805Built 1964 · Young Steven F N707MGCessna 182B · S/N 52073Built 1959 · Tawoda Leanne N762SXCannon Scott R SONEX · S/N 0762Built 2006 · Nachor Emanuel N764CLBell 206B · S/N 2811First renewal noticeKestrel Enterprises Inc N8898YPiper PA-39 · S/N 39-33Built 1970 · Wickenheiser Kenneth W N901KAPiper PA-34-200 · S/N 34-7450045Built 1973 · Spiegel Richard J N93VTBeech V35B · S/N D-9155Built 1970 · Lidner Mark H N943KSCessna 172N · S/N 17270273Built 1978 · Stark James E Trustee N9578XCessna 210B · S/N 21057878Tvat LLC N963PPopp Timothy L RV-7 · S/N 70634Built 2012 · Popp Timothy L N96AZVans RV-12IS · S/N 120896Built 2024 · Unternaehrer William E N9784BCessna 172RG · S/N 172RG1034Built 1981 · Recycleworx LLC

Back to Sun City, AZ