El Paso, TX
Registered aircraft · 312
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 = 'TX' AND g.registrant_city = 'EL PASO' 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 = 'TX' AND g.registrant_city = 'EL PASO' 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.
N1059FNew Piper PA-28-181 · S/N 2843643N1082GPiper J3C-65 · S/N 14087N11114Beech V35A · S/N D-8901N116MEJoseph F Salomone S-21 OUTBOUND · S/N 05200105N117KBLearjet 60 · S/N 003N117RKPiper PA-28RT-201T · S/N 28R-7931068N118DRBell UH-1H · S/N 66-00903Non-citizen corporation, flight hours not reportedN1237EAeronca 7AC · S/N 7AC-4795N1274XCessna LC41-550FG · S/N 411077N127ACChretin Alberto AIRCAM · S/N AC-25N1281KBillie R Kirkwood VANS RV-6 · S/N 24143N1282PRichard L King PIETONPOL AIR CAMPER · S/N 1007N132RLGarner Lynn H TEAM HI-MAX 1700R · S/N 112546LHGN1340WMooney M20E · S/N 228N13435Cessna 172M · S/N 17262749N137BRLearjet 45 · S/N 45-2068N138AZCessna T182T · S/N T18208355N146LCBeech B200 · S/N BB1046N1477DAmerican Legend AL18 · S/N AL-371N15966Piper PA-28-140 · S/N 28-7325214N1678TCessna 414 · S/N 414-0471N1686YCessna 172C · S/N 17249386N169PPCessna 182R · S/N 18268444N16KHAerospatiale SA341G GAZELLE · S/N 1456N170CFCessna 170B · S/N 25904N17911Schweizer SGS 1-26E · S/N 541N180DDDaniels David R RV-4 · S/N 1355N1868JPiper PA-28-140 · S/N 28-24309N189SBLearjet 60 · S/N 210N197PSCzech Sport PIPER SPORT · S/N P1001062N198HBLearjet 60 · S/N 198N1990YMooney M20E · S/N 277N2007MPiper PA-28R-201 · S/N 28R-7837061N203WTJabiru USA Sport J250-SP · S/N 456N204JCessna 525 · S/N 525-0164N208BHLearjet 60 · S/N 208N2091RHughes 369A · S/N 380381N2103MPiper PA-28R-201 · S/N 28R-7837066N210TRCessna T210M · S/N 21061745N210XPCessna T210K · S/N 21059336N2118SCessna T210L · S/N 21061081N212JALearjet 60 · S/N 010N2138ZMooney M20R · S/N 29-0158N218HLCirrus Design SR22T · S/N 1310N2191RCessna 182G · S/N 18255391N21TNCessna 180 · S/N 31685N2204TPiper PA-28R-200 · S/N 28R-7135168N2205ZFirefly Balloons FIREFLY 8B-15 · S/N F8B-2068N220MDLearjet 60 · S/N 251N2213EHerman Freadrich VELOCITY XL RG · S/N 3RX090
Back to El Paso, TX