Edinburg, 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 = 'EDINBURG' 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 = 'EDINBURG' 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.
N1151BCessna 150L · S/N 15075478N1163MCessna 550 · S/N 550-0568N123DAChampion 7ECA · S/N 798-71N129BRClark W/Reynolds R C-R SPORTSTER · S/N 52AN1438YCessna 172C · S/N 17249138N1494DCessna 170A · S/N 20096N1631JPiper PA-28-140 · S/N 28-25416N177EJCessna 177B · S/N 17701626N197LAPiper PA 46-350P · S/N 4636098N200JRBeech B200 · S/N BB-1123N234ZFlight Design CTLS · S/N F-09-03-12N24240Cessna T182T · S/N T18208763N2495DPiper PA-38-112 · S/N 38-79A0333N3488SCessna 182H · S/N 18255888N372JBBeech 200 · S/N BB-719N390MBRaytheon 390 · S/N RB-21N4292JPiper PA-28-140 · S/N 28-22660N435XMaule M-5-235C · S/N 7055CN450JRBeech 58 · S/N TH-670N5026UCessna 206 · S/N 206-0026N5293ELeading Edge Aerial Tech PV40X · S/N 11495N530DMCessna 421B · S/N 421B0839N537CTFlight Design CTSW · S/N 07-05-03N5411XCessna U206G · S/N U20605727N5457BCessna 182 · S/N 33457N5761BCessna 182 · S/N 33761N58981Cessna 182P · S/N 18262441N6408NCessna T210N · S/N 21062984N665TACessna T206H · S/N T20608665N66JWPiper PA-23-250 · S/N 27-7304967N6810SBeech 58 · S/N TH-691N716MASocata TBM 700 · S/N 310N72306Cessna U206D · S/N U206-1360N731EQCessna A188B · S/N 18802843TN736NGCessna TR182 · S/N R18200745N8043JRobinson Helicopter R22 BETA · S/N 1102N8119EMooney M20A · S/N 1390N818SCHughes 369A · S/N 770093N81HRHawker Beechcraft 390 · S/N RB-200N88112Piper J3C-65 · S/N 15725Revoked, canceledN9024SBeech 95-B55 (T42A) · S/N TC-963N90HKBeech F90 · S/N LA-176N920PAPiper PA-46-600TP · S/N 4698136N93586Bellanca 17-30A · S/N 73-30612N9468XCessna 210A · S/N 21057768N946BPRobinson Helicopter R44 · S/N 0909N9583MCessna U206G · S/N U20604552N9664KCessna A188B · S/N 18803965TN9935RCessna U206G · S/N U20606988
Back to Edinburg, TX