Harlingen, TX
Registered aircraft · 49
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 = 'HARLINGEN' 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 = 'HARLINGEN' 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.
N103SVCessna 172R · S/N 17280534N10PPPiper PA-46-310P · S/N 46-8408011N11HKPiper PA-32R-301T · S/N 32R-8129071N1328LRistine Wayne L AVID MARK IV · S/N 1328DN143DDouglas DC3A-S4C4G · S/N 2054N167DPRaytheon 390 · S/N RB-67N172DMcdonald David L GLASAIR II FT · S/N 1053N2050ABeech C90 · S/N LJ-813N20WFCessna 310R · S/N 310R0684N211YAYakovlev YAK 52 · S/N 866713N217ARRaytheon A36 · S/N E-3421N22014Cessna 150H · S/N 15068010N2393BPiper PA-38-112 · S/N 38-79A0035N274KABeech E-90 · S/N LW-274N3016UCessna 172E · S/N 17250616N30898Piper PA46-500TP · S/N 4697202N3089AAyres S2R-T34 · S/N T34-063DCN318CARaytheon 58 · S/N TH-2001N3425JCessna 150G · S/N 15066125N350UPiper PA 46-350P · S/N 4636874N3812LCessna 172G · S/N 17253981N4858KRyan NAVION · S/N NAV-4-1858N4906LPiper PA-28-180 · S/N 28-4274N5270SCessna TR182 · S/N R18201532N52YKYakovlev YAK 52 · S/N 8910007N56HTBeech E-90 · S/N LW-215N5935TCessna 150D · S/N 15060635N595BEEngle Byron C T-40A · S/N 176N601BPiper AEROSTAR 601 · S/N 6106057962136N6159LAmerican AA-1 · S/N AA1-0359N6311KYves JM Garric POTEZ-GARRIC 6311 · S/N 844N63536Nanchang China CJ-6 · S/N 4032016N6555YCessna 210N · S/N 21064436N704KVCessna 150M · S/N 15078680N73799Cessna 172N · S/N 17267689N739DWCessna 172N · S/N 17270470N743NXCirrus Design SR22 · S/N 4369N756YDCessna U206G · S/N U20604455N77DSPiper PA-31-325 · S/N 317812061N8126SCessna 150F · S/N 15061726N82EDCessna 150L · S/N 15075663N854DZCessna 182T · S/N 18281150N8790XCessna 182D · S/N 18253190N8889RDowner 14-19-3A · S/N 4251N905RVGarrett Stephen C RV12 · S/N 120366N91157Cessna 207 · S/N 20700096N91783North American NAVION · S/N NAV-4-495N9448TPiper PA-38-112 · S/N 38-78A0103N988SCRaytheon B300 · S/N FL244
Back to Harlingen, TX