Moriarty, NM
Registered aircraft · 42
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 = 'NM' AND g.registrant_city = 'MORIARTY' 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 = 'NM' AND g.registrant_city = 'MORIARTY' 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.
N101AZStart & Flug H101 "SALTO" · S/N 60N10389Schweizer SGS 1-23H · S/N 55N10ZGPipistrel VIRUS 912 · S/N 300 V 912N110EVPipistrel SINUS 912 · S/N 095N129SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1212N153MWRolladen-Schneider OHG LS3-A · S/N 3227N158ESAlbastar D O O AS-15E · S/N 2N15FJZaklady Lotnicze Marganski MDM-1 FOX · S/N 256N162SSBurkhart Grob Flugzeugbau SPEED ASTIR II · S/N 4017N1QGBeech V35 · S/N D-8328N2065UMaule M-4-220C · S/N 2056CN223WPBurkhart Grob G-103A TWIN II ACRO · S/N 3846-K-92N2581Coppock STARDUSTER SA-100 · S/N 1N270BALet L-23 SUPER BLANIK · S/N 938027N295EZMudd-Robert VARIEZE · S/N 295N321CAGarratt Carol ANN RANS S-7S · S/N 0504372N33DFGlaser-Dirks DG-800 · S/N 8-35A27N461RTHylio HYL-150 · S/N 17906110368N463FHHylio HYL-150 · S/N 17906110367N4862YPiper PA-25-235 · S/N 25-4665N4934Larkin Dave ZENAIR CH 701 SP · S/N 74934N49379Schempp-Hirth K G VENTUS A · S/N 58N503SPdps Pzl-Bielsko SZD-50-3 · S/N B-2086N505ANAntonov A-15 · S/N 0505N51338Piper PA-28-235 · S/N 28-10828N58RWAB Sportine Aviacija GENESIS 2 · S/N 2014N628CACentrair 101A · S/N 101A0154N665EZPipistrel VIRUS SW · S/N 897 SW 100 ISN7087LGarrison Paul E J5-SUPERKITTEN · S/N 00197N71525Hanle H121 GLOBETROTTER · S/N 1N7316VBellanca 17-30 · S/N 30171N800UMDG Flugzeugbau DG-800B · S/N 8-227B141N8035PPiper PA-24-250 · S/N 24-3282N808EEDg-Flugzeugbau DG-808 C · S/N 8-352B251X16N8309TCessna 175C · S/N 17557009N83RLLantrip Robert A BARRACUDA · S/N 336N888ZGPiper PA-28-140 · S/N 28-7525109N914LSchempp-Hirth K.G. JANUS B · S/N 75N93290Commonwealth REARWIN 185 · S/N 1854N9609PPiper PA-25-260 · S/N 25-7656007N9823VCessna A188 · S/N 188-0073N99DWSchleicher KA 6 E · S/N 4081
Back to Moriarty, NM