Kingman, AZ
Registered aircraft · 105
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 = 'KINGMAN' 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 = 'KINGMAN' 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.
N1106XPiper PA-34-200T · S/N 34-7570212N1126XPiper PA-28R-200 · S/N 28R-7535253N12PFCessna T210M · S/N 21062401N140FLPiper PA-28-140 · S/N 28-7125111N14872Cessna U206 · S/N U20602144N1508RGrumman American Avn. AA-5B · S/N AA5B-0030N150HPGrimes Brian T LANCAIR 235 · S/N 001N155CADouglas DC-8-73F · S/N 46073N189ASHurricane 103 · S/N 134N19480Cessna 150L · S/N 15074442N20CBRepublic RC-3 · S/N 522N20CXSchleicher ASW-20C · S/N 20702N218HGCirrus Design SR22T · S/N 1632N227DCessna 210 · S/N 21061540N2363PPiper PA-38-112 · S/N 38-79A0963N238VNorth American T-28B · S/N 52-1238N23976Beech C23 · S/N M-1900N242KShelton Joseph G S-7 · S/N 0101298N2483XLindquist Alex R ZODIAC 601XL · S/N 6-5934N2835RCessna Wren 182K460 · S/N 18258435N2889FCessna 182J · S/N 18256989N2975BBeech D35 · S/N D-3615N301CAPiper PA-32-300 · S/N 32-40178N3114PBoeing N2S-3 · S/N 75-7889N32425Piper PA-28-151 · S/N 28-7515154N32871Piper PA-28-235 · S/N 28-7510032N329MHHawker Beechcraft B200GT · S/N BY-40N34380Meyers Industries 200A · S/N 262N367RWHughes 269C · S/N 870627N376TBeech B-55 · S/N TC-2012N38FRCessna 172N · S/N 17270698N3948Allen HEADWIND M-2 · S/N AB-7N39767Boeing A75 · S/N 75-3485N4086FCessna 172 · S/N 36986N40HAFlight Design CTSW · S/N 06-09-20N4217JPiper PA-28-140 · S/N 28-22565N426WWMooney M20TN · S/N 31-0007N433CVCarswell Joseph C TITAN II · S/N D01582S0HK0416N451SXPettyjohn Steven William SONEX · S/N 0451N46WBMooney M20R · S/N 29-0226N4744CCessna 210N · S/N 21063609N474JRRoybal Jesse U CH650B · S/N 65-11082N48716Aeronca 0-58B · S/N 058B-6452N4990WRockwell International 114 · S/N 14310N49MDBeech 95-C55 · S/N TE-57N5001DCessna 182A · S/N 51101N5060TPiper PA-28R-200 · S/N 28R-7235187N5061CCessna T182T · S/N T18208166N508WLCessna 170B · S/N 25897N510PKCessna 510 · S/N 510-0304
Back to Kingman, AZ