Fort Mohave, AZ
Registered aircraft · 54
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 = 'FORT MOHAVE' 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 = 'FORT MOHAVE' 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.
N113SAGlaser-Dirks DG-400 · S/N 4-113N1640PPiper PA-32RT-300T · S/N 32R-7887221N16564Piper PA-28-180 · S/N 28-7305285N17EZChambliss-Max VARIEZE · S/N 1522N2012QCessna 177RG · S/N 177RG0412N22004Luscombe 8E · S/N 854N2857UCessna 172D · S/N 17250457N2993YCessna 182E · S/N 18253993N2QBMeyer William LASER · S/N 1N3195DCessna 180 · S/N 31993Registration pendingN400FKPiper PA-24-400 · S/N 26-47N4364APiper PA-22-150 · S/N 22-3716N47504Taylorcraft DCO-65 · S/N L5260N4812JPiper PA-28R-180 · S/N 28R-30605N48MGMartelet Ronald G MONI · S/N 144N4YAPiper PA-30 · S/N 30-365N503XSidney P Essex SR SONEX ONEX · S/N 0167N5251JCessna T310R · S/N 310R0813N5390PPiper PA-24-180 · S/N 24-441N53LCCramer Todd/Alsterlind Stephen CRAMER/ALSTERLIND L2 · S/N 001N5423PPiper PA-24-250 · S/N 24-477N5856ZPiper PA-22-108 · S/N 22-9712N6096JCessna A150L · S/N A1500396N620MPCanadian Light Acft Sales &Svc BUSHCADDY LSA · S/N BCLSA003-D-TG-XN6219LAmerican AA-1 · S/N AA1-0419N6288DCessna 172N · S/N 17272694N6753VMooney M20E · S/N 700052N6780NMooney M20C · S/N 680088N6953QBeech A23-24 · S/N MA-300N6979HCessna 172M · S/N 17265678N71810Bruce Harrison HARRISON HAWK I · S/N 001N7295MCessna 175 · S/N 55595N750AZSteven Smith STOL CH 750 · S/N 75-11395N776WRCessna 560 · S/N 560-0459N777JCirrus Design SR22T · S/N 0344N806LCColburn Richard S T51 MUSTANG · S/N M0261450HK0006N8086RPiper PA-28RT-201T · S/N 28R-8231027N808NZAir Tractor AT-802A · S/N 802A-0793N811JKVans RV-12 · S/N 120564N8170GPiper PA-34-220T · S/N 34-8233116N8269ECessna 172N · S/N 17272159N8650ZCessna P206C · S/N P206-0450N8665HNorth American NAVION · S/N NAV-4-665N88FSMartelet Ronald G KOLB FIRESTAR II · S/N FS-640N88YYBeech 35-C33A · S/N CE-64N8915GCessna 182N · S/N 18260455N8940XCessna 182D · S/N 18253340N9105RMarlowe Gordon RIDGE RUNNER IIIS · S/N 414N9116WPiper PA-28-235 · S/N 28-10728N91189North American NAVION · S/N NAV-4-240
Back to Fort Mohave, AZ