Sahuarita, AZ
Registered aircraft · 43
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 = 'SAHUARITA' 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 = 'SAHUARITA' 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.
N103RFBurkhart Grob G-103A TWIN II ACRO · S/N 33921K156N10WBStemme S10-VT · S/N 11-022N116AMPiper PA-18-150 · S/N 183684N1190KLuscombe 8A · S/N 3917N1212SThompson Ronald B RAN S12XL · S/N 07950623N12546Cessna 172M · S/N 17262061N1273UCessna 172M · S/N 17266968N131CBBoswell Carter H JR GLASSAIR II RG · S/N 1119N18SUBenjamin R Austerman RANS S-18 · S/N 0701017First renewal noticeN20852Cessna 182P · S/N 18261258N272DRRobl Greg RV-3A · S/N 272DRN3052TAllen Arnold R WAGABOND · S/N 359 A-BN3404BBeech D35 · S/N D-3642N3799VCessna 140A · S/N 15220N379BFCessna T182T · S/N T18208253N4115MBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3799KN44WPSchlanser TAILWIND W-10 · S/N ES1N482ASPiper PA-28-140 · S/N 28-25252N500JNPzl-Swidnik PW-5 · S/N 1706010N5150UCessna 172RG · S/N 172RG0261N5448WBurkhart Grob G 103 TWIN II · S/N 3869-K-110N6079MStinson 108-3 · S/N 108-4079N6403QMooney M20C · S/N 670143N65865Schweizer SGS 2-33A · S/N 350N678TSPzl-Swidnik PW-6U · S/N 78.03.10N67PJAlexander Schleicher ASK 21 · S/N 21707N691RRHughes 269B · S/N 124-0143N70779Nemec Brant CGS HAWK ARROW II · S/N H-AII-169-F30-TRIN731MLBeech V35B · S/N D-10208N73525Cessna 172M · S/N 17267528N74314Bellanca 14-13-2 · S/N 1427N74796Mooney M20B · S/N 1796N818VPQuicksilver SPORT 2S · S/N 0195N8236MCessna 182P · S/N 18264569N825LJeremy Blackketter SONEX · S/N 1047N8552Bellanca 7GCBC · S/N 454-73N856AWRichard A Washburn VANS ACFT INC RV-7A · S/N 73945N86047Grover J3 KITTEN · S/N 434N876FSchleicher ASW-19 · S/N 19068N8847RDowner BELLANCA 14-19-3 · S/N 4201N95758Taylorcraft BC12-D · S/N 8058N9701PPiper PA-25-260 · S/N 25-7556012N9815PPiper PA-25-235 · S/N 25-7556129
Back to Sahuarita, AZ