Albuquerque, NM
Registered aircraft · 1,180
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 = 'ALBUQUERQUE' 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 = 'ALBUQUERQUE' 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.
N1005XMooney M20M · S/N 27-0302N100EUPiper PA-28-181 · S/N 28020030N101HRCobb Lawrence L PITTS S1S · S/N COBB 001N101UCessna 525 · S/N 525-0454N1037BBeech H35 · S/N D-5311N103BMPiper PA-44-180T · S/N 44-8107007N103JMBurkhart Grob G103C TWIN III SL · S/N 35041N104YRichter-Sand Robert J KITFOX SUPER SPORT · S/N KA11316217N1059SAdams Balloon A55 · S/N 046N105BMCameron Balloons US A-105 · S/N 6538N105DDCameron Balloons US 0-105 · S/N 6733N105JKCessna 172P · S/N 17275306N105NMCameron Balloons US 0-105 · S/N 6595N105PKCirrus Design SR22T · S/N 9235N105XRBalony Kubicek Spol Sro BB30XR · S/N 1130N10634Adams Balloon A55S · S/N 108N1064TCameron Balloons US C-80 · S/N 6410N106APRaven S-60A · S/N S60A-161N1070ZMooney M20K · S/N 25-1222N10791Cameron Balloons US 0-105 · S/N 6421N107RTCameron Balloons US Z-105 · S/N 6365N1095GGlasflugel STD LIBELLE 201B · S/N 348N10JWWylie Justin RV-10 · S/N 41665N1107ZCameron Balloons US A-105 · S/N 6434N1116EBellanca 7GCBC · S/N 981-77N111XFBender Thomas G RV-6 · S/N 24474N11218Cameron Balloons Z-90 · S/N 6437N11321Balony Kubicek Spol Sro BB30Z · S/N 1890N1138FPiper PA-28R-200 · S/N 28R35260N113BACessna 172M · S/N 17266046N1158JMooney M20J · S/N 24-1267N115VSSei Vincent Joseph F-1D ROCKET · S/N 115N116FSAdams Balloon A55S · S/N 171N116GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 339N116KBM&D Flugzeugbau JS-MD 3 RES · S/N 3.MD213N11716Kubicek Factory S R O BB30D · S/N 2034N118BCameron Balloons US V-90 · S/N 6689N119FFFerdon F/Ferdon S S-18 · S/N 119N11AGPilatus PC-12/45 · S/N 343N11HWMooney M20M · S/N 270057N11RUYakovlev YAK-11 · S/N 172701N11YEMooney M20R · S/N 29-0038N120PDAirbus Helicopters AS350B3 · S/N 9503N120USCameron Balloons CAMERON UNCLE SAM · S/N 1120N120WWPiper PA46-500TP · S/N 4697047N121NFBalony Kubicek Spol Sro BB26Z · S/N 1474N121RMMccoy ACRODUSTER II SA750 · S/N 1N1221Textron T206H · S/N T20609538N124RPilatus PC-12/47E · S/N 1840N124TTTranbarger Thomas P RV-4 · S/N 931
Back to Albuquerque, NM