Uvalde, TX
Cancelled registrations · 57
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'TX' AND d.registrant_city = 'UVALDE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'TX' AND d.registrant_city = 'UVALDE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N67MHJonker Sailplanes JS3 RES · S/N 03-177N68NPCessna 510 · S/N 510-0170N6936LCessna 310K · S/N 310K0036N81HACessna 510 · S/N 510-0361N6882TCessna 310D · S/N 39182N4487DRobinson Helicopter R44 · S/N 1654N183CCCub Crafters CC18-180 · S/N CC18-0016N1777FRobinson Helicopter R22 BETA · S/N 0777N206TUCessna TU206G · S/N U20604770N4967CBoeing E75 · S/N 75-8102N1502FAir Tractor AT-401 · S/N 401-0819N5758SSchweizer SGS 2-33A · S/N 92N598QKYuneec International Q500+ · S/N YU15220422B02D01N31849Aeronca 65-LB · S/N L-11400N9101LFiresheets William R RV-8 · S/N 80569N5663TCessna 172E · S/N 17251563N116KGEurocopter EC120B · S/N 1152N6918PPiper PA-24-250 · S/N 24-2052N10119Air Tractor AT-402 · S/N 402-0711N9558FHughes 269B · S/N 890441N56FTCirrus Design SR22 · S/N 0026N13RWNorth American T-28B · S/N 138246N117GMMcarthur Gary PIETENPOL AIRCAMPER · S/N 11T7N750FMGrumman FM-2 · S/N 86750N91228Cessna A188B · S/N 18802030TN12QGGuelker Henry L QUICKIE Q-2 · S/N 2616N9775GCessna A188B · S/N 18801600TN66APiper PA-11 · S/N 11-29N922SHRobinson Helicopter R22 BETA · S/N 3863N58TCCessna 500 · S/N 500-0261N3104MMaule MX-7-180A · S/N 20023CN8373TRobinson Helicopter R22 BETA · S/N 2746N958PHRobinson Helicopter R22 BETA · S/N 2423N4927XRockwell International S-2R · S/N 2128RN2222LMatheny Larry D RANS S-9 · S/N 1287033N75AJUvalde Flight Center CA 8 · S/N 008253N7734HRobinson Helicopter R22 BETA · S/N 0743N9425FHughes 269B · S/N 25-0158N801SJSmith-Johnson KR-2 · S/N KR2-01JD-A75N334JCCessna 500 · S/N 5000334N84191Aeronca 7AC · S/N 7AC2879N2820BBell 47G-2 · S/N 1488N6798APiper PA-18-150 · S/N 188009052N25367Cessna 152 · S/N 15280618N8606VBellanca 7GCBC · S/N 802-75N4892QCessna A188B · S/N 188-02628TN1261YCessna 150B · S/N 15059661N8201RBellanca 17-30A · S/N 73-30501N1860PPiper PA-18A · S/N 18-4127N8209CPiper PA-18A · S/N 18-4443
Back to Uvalde, TX