Casa Grande, AZ
Registered aircraft · 72
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 = 'CASA GRANDE' 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 = 'CASA GRANDE' 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.
N1039JAero Commander 112 · S/N 101N1143MCessna 172L · S/N 17259443N119DPNorth American SNJ-4 · S/N 88-10185N125JSSnyder John W III RV-4 · S/N 1360N130NSBonesteel W/Bonesteel T SONEX · S/N 0798N1343EAeronca 7AC · S/N 7AC-4904N153JPTeam Rocket LP F1 F1 · S/N 053N1555NElliott MUSTANG II · S/N 409N1658YCessna 172C · S/N 17249358N184JPCessna 180K · S/N 18052889N1902HPiper PA-28-161 · S/N 28-7716060N204LDJI PHANTOM 4 PRO · S/N 11UCF8T0A50181N2085SCessna T210L · S/N 21061051N20MGSchempp-Hirth K G VENTUS A · S/N 86N220JJones Jory J RV 14A · S/N 140543N2236EChampion 7AC · S/N 7AC-5810N2291ADJI AGRAS T40 · S/N 64TBK7H00100WWN2426EAeronca 7AC · S/N 7AC2481N25138Luscombe 8A · S/N 1062N2580SCessna T210L · S/N 21061333N258FDCirrus Design SR22T · S/N 9884N260DBBabcock Dayton STALKER · S/N DBS01N270MECessna T206H · S/N T20608213N271XFDJI AGRAS T40 · S/N 5X5BLJD0020HA3N279YQDJI AGRAS T40 · S/N 64TBL8F002009CN2819Aerovodochody L-29 DELFIN · S/N 892819N2929MPiper PA-12 · S/N 12-1331Sale reported, pending cancellationN319RDPiper PA 46-350P · S/N 4636139N32692Piper PA-28-180 · S/N 28-7505083N3449RCessna 182L · S/N 18258749N3522QCessna 172M · S/N 17261661N357HPCessna 140 · S/N 8836N388WCessna 182A · S/N 33876N414BCPiper PA-28-140 · S/N 28-21129N4181AErickson JR 1 · S/N 1N4607QCessna T210L · S/N 21059507N4673NCessna 182 · S/N 18266848N505CGDJI MAVIC 2 ZOOM · S/N 0M6CGLR0A1BMKN50CGCessna 182N · S/N 18260110N51034Boeing IB75A · S/N 75-1048N515LMDJI INSPIRE 1 PRO · S/N W21ACL04020253N5267CBeech B35 · S/N D-2660N562BZMapes John L/Drew Michael T RV-12 · S/N 120628N5872MCessna 310P · S/N 310P0172N5878JBeech S35 · S/N D-7870N621ACessna T210N · S/N 21064069N6240ECessna 172 · S/N 46340N626MJPiper PA-28-140 · S/N 28-7625134N626SPPiper PA-23-250 · S/N 27-7654094N6333DBryan Carr RV-4 · S/N 1092
Back to Casa Grande, AZ