Marana, AZ
Registered aircraft · 125
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 = 'MARANA' 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 = 'MARANA' 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.
N10294Grumman G-164 · S/N 94N108TMNewkirk William FLYER · S/N 013N1127CCameron Balloons US ZL-65 · S/N 6380N1189MCessna 310D · S/N 39180N1281MCessna 337E · S/N 33701281N12RSSuter Robert W SONEX · S/N 111N1357BLuscombe 8E · S/N 5984N144VAeropro CZ S R O A240 · S/N 57919N159JWJohn M Wadleigh BUSHCAT · S/N CH215CN1612APiper PA-18-125 · S/N 18-1253N1743WBeech V35B · S/N D-9404N183HKBoeing 767-3P6 · S/N 24496N1845XCessna 182H · S/N 18255945N2040VCameron Balloons US N-105 · S/N 5392N21066Mastopietro Kurt MAXAIR DRIFTER · S/N 102552N22CDTaylorcraft BC12D-85 · S/N 10260N23274Cessna 150H · S/N 15068841N232ABMaas Douglas W SIX CHUTER 2 · S/N 1005N241VYAviat A-1A · S/N 1449N2425SCessna T210L · S/N 21061276N2566MPiper PA-12 · S/N 12-1045N287KBMcdonnell Douglas DC-9-87 · S/N 49768N29922Cameron Balloons US N-105 · S/N 5225N30102Waco UPF-7 · S/N 5499N3085YPiper PA-25-235 · S/N 25-4265First renewal noticeN3108MPiper PA-12 · S/N 12-1796N31251Bellanca 7GCBC · S/N 399-72Registration pendingN3217ZPiper PA-22-150 · S/N 22-7158First renewal noticeN321AVAirbus A321-231 · S/N 2234N32522Piper J3C-65 · S/N 5417N327DTCirrus Design SR22 · S/N 0972N3291ZCessna 150L · S/N 15075105N3300CAirbus A330-202 · S/N 211N340BSCessna 340 · S/N 340-0353N34572Aeronca 65-CA · S/N CA-15791N3475TCessna 177 · S/N 17700775N351WHHampton William A GLASAIR SUPER II S · S/N 2309N3526KPiper PA-28-140 · S/N 28-23606N352PKQuicksilver SPORT · S/N 2384N3546QCessna 172S · S/N 172S8889N3611GAerostar International RX 8 · S/N RX8-3031N3762VCessna 140 · S/N 15047N3772QBeech V35 · S/N D-8405N3814DCessna 182A · S/N 34514N3954RPiper PA-28-180 · S/N 28-7105059N4025LAircreation GTE912J · S/N T01067N4045WWeston Stephen K AVID FLYER · S/N 1365DN4179ZPiper PA-18-150 · S/N 18-8359N429TCThunder & Colt Airborne Amer AX7-65S1 · S/N 2232USASale reportedN430GHHobbs Greg H LIGHTNING · S/N 3First renewal notice
Back to Marana, AZ