Registered aircraft · 52

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

N10354Schweizer SGU 2-22CK · S/N 82Built 1960 · Rebholz Mark A N1202JAero Commander 112 · S/N 202Built 1974 · Aldrich Curtiss N1204XMooney M20C · S/N 2607Built 1963 · Mcdonald Monroe N124BDBede BD-4 · S/N 124Built 1971 · Moore Kathryn Cv Julianne N1352SCessna 182P · S/N 18264915Ejw Enterprises LLC N136JMPiper PA-22-150 · S/N 22-5557Built 1963 · Gregory Warren D Jr N1684BLuscombe 11A · S/N 11-190Built 1949 · Greissing John P N1741NCessna 120 · S/N 11985Built 1946 · Aero Optics Inc N180HCessna 170A · S/N 19944Built 1951 · Porter Jeff S N1998ZCessna 150C · S/N 15059798Milhous Richard J N202PTPennington Curtis Lee PT2C PROSTAR · S/N 0016Built 2017 · Herreman Brian J N228AKJoseph Romson CALIDUS · S/N C00338Built 2021 · Burton Anthony A N23391Cessna 150H · S/N 15068925Built 1968 · Porter Scott N2435Ahl-Pietenpol IMPROVED AIRCAMPER · S/N WHA-1Built 1970 · Elg Rodney C N252SWCessna T210N · S/N 21063029Built 1978 · Symns Robert A N253XSlingsby T-53B · S/N 1601Davidson Donna J N296PBoeing A75N1(PT17) · S/N 75-2893Cooke Carole J Trustee N30790Cessna 177B · S/N 17701466Built 1970 · Cammarato Thomas Angelo N33GVPeterson Keith D RV6A · S/N PETERSON 3Built 2017 · Milhous Richard J N3560ZPiper PA-22-160 · S/N 22-7474Built 1960 · Bolding Ronald B N387PExtra Flugzeugproduktions EA 300/L · S/N 1287Built 2008 · Ejw Enterprises LLC N40647Maule M-4-220C · S/N 2163CBuilt 1973 · Rozum Richard A N42036Cessna 182L · S/N 18258822Built 1968 · Murphy Steven R N43855Taylorcraft BC12-D · S/N 7514Built 1946 · Elliot Gary L N4450NSchweizer SGS 1-26C · S/N 365Davidson Donna J N44781Laister-Kauffman LK-10A · S/N 82Built 1943 · Rebholz Mark A N4631TCorben Baby Ace ELG D · S/N 101Built 1964 · Elg Rodney C N4737FCessna A185F · S/N 18503552Built 1978 · Jelm Gordon E N47390Laister-Kauffman LK-10A · S/N 19Built 1942 · Rebholz Mark A N4BVCessna P337H · S/N P3370348Joe Sanchez Farms Inc N508DHStockman Harold STOCKMAN RANS S-7S · S/N 0508508First renewal noticeBuilt 2010 · Eiting Joseph N N5105SPiper PA-28-140 · S/N 28-7125335Built 1971 · Syphers Harold A N5171FRassler Herman D A · S/N 1Built 1994 · Elliot Gary L N5619HPiper PA-16 · S/N 16-230Built 1949 · Franklin Vernon L N5980WPiper PA-28-150 · S/N 28-4260Built 1967 · Cooke Carole J Trustee N60SDDickey K Shirlan VARI-EZE · S/N 1995Dickey K S N614JTJames Thurman RV7 · S/N 73952Built 2021 · Porter Scott N66455Cessna 150M · S/N 15076061Built 1974 · Soendergaard Carsten N71594Silvaire LUSCOMBE 8A · S/N 3021Built 1946 · Mundy Terrence D N72PFCessna 172G · S/N 17253530Built 1965 · Kuck Russell W N73811Commonwealth 185 · S/N 1816Mertesdorf Daniel R N7388QCessna 182P · S/N 18261028Built 1972 · Johnson Timothy R N74199Piper PA-23-250 · S/N 27-3026Built 1965 · Aldrich Curtiss R N757JFCessna TR182 · S/N R18201236Built 1979 · Boykin Randy K N7755HPiper PA-12 · S/N 12-653First renewal noticeBuilt 1946 · Goos Lynn N8808TCessna 182C · S/N 52708Built 1960 · Greissing John P N8873GCessna 150F · S/N 15062973Built 1966 · Harris David J N888KHHosfiel Keith VANS RV6 · S/N 25478Built 2005 · Franklin Vernon L N92320Piper J3C-65 · S/N 16773Built 1946 · Yarbrough Donald D N947JNewsum James D RV-6 · S/N 60436Built 2014 · Newsum James D

Back to Aguila, AZ