Overgaard, AZ
Registered aircraft · 53
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'OVERGAARD' 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 = 'OVERGAARD' 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.
N110RWRonald White RV-8A · S/N 82809N12FEForbes David M LANCAIR 360 · S/N F-4N1489SCessna 182P · S/N 18265036N201CXMooney M20J · S/N 24-0443N20NXJames Fairchild ONEX · S/N ONX 0020N2103ZBishop Raymond Max AERO SPEC 2150 · S/N 890001Sale reported, pending cancellationN2180CCessna 195B · S/N 16165N2242KSilvaire LUSCOMBE 8A · S/N 4969N2264ZNelson-Gene WOODY PUSHER · S/N 37N282VHooton Jack RV-4 · S/N 3676N28760Grumman American Avn. AA-5B · S/N AA5B0795N3287ACessna 170B · S/N 25931N3597VCessna 150M · S/N 15076557N359BHHewett Brian LANCAIR 235 · S/N 176N37ZAMulder Theodor Louis LANCAIR 320 · S/N 377AN39GTGary Towner SUPER CUB EXP · S/N SC-100N42TMMulder Theodor L LANCAIR 4 · S/N 216N524TTowner Gary VANS RV-4 · S/N 3928N56HREmbree Keith E RV-8A · S/N 81408N5794HPiper PA-16 · S/N 16-410N63115Fairchild M-62C(PT-23A) · S/N 222-SLN642BKMacintyre Robert RV-10 · S/N 40681N6486PPiper PA-24-250 · S/N 24-1604N64RKCessna 182G · S/N 18255686N65908Cessna T182T · S/N T18208347N667WBCessna 182L · S/N 18258563N684AZGates Edward M RV6A · S/N 25295N6932UMooney M20E · S/N 302N6945PPiper PA-24-180 · S/N 24-2080N70PTTaylor Paul A RV-8 · S/N 81965N7136Taylor AMIGO 2 · S/N 19761N71814Luscombe 8A · S/N 3241N730BRReed Charles E JR RV-4 · S/N 3554N7371LAmerican AA-5 · S/N AA5-0210N7391Piper PA-20 · S/N 20-809N765FWWellman Fred L PANTHER LS · S/N P004N77NDavis D-1 · S/N 501N7912QCessna 401B · S/N 401B0012N807TBeech S35 · S/N D-7691N83KTPaul Taylor SUPER CUB EXP · S/N SC002N84JKWethington James RV-8 · S/N 80943N84SFFifield Scott GLASTAR · S/N 5334N8724TCessna 182C · S/N 52624N87VPAmerican Champion 7GCBC · S/N 1422-2006N882AZVans RV-12IS · S/N 121367N8867WPiper PA-28-235 · S/N 28-10422N9112SPeter Winikates RV-12 · S/N 121007N920HGKitzmiller BUSHBY MUSTANG M-II · S/N M-II-586N9251XCessna 182E · S/N 18253651N93549Bellanca 17-30A · S/N 74-30624
Back to Overgaard, AZ