Frisco, TX
Cancelled registrations · 186
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 = 'FRISCO' 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 = 'FRISCO' 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.
N391RSShield Ai V-BAT · S/N VB-200048N391SVShield Ai V-BAT · S/N VB-200046N391TFShield Ai V-BAT · S/N VB-200049N391USShield Ai V-BAT · S/N VB-200039N391VSShield Ai V-BAT · S/N VB-200050N391WAShield Ai V-BAT · S/N VB-200047N475SAShield Ai V-BAT · S/N VB-200028N477SAShield Ai V-BAT · S/N VB-200029N492SAShield Ai V-BAT · S/N VB-200045N793VBShield Ai V-BAT · S/N VB-200096N798VBShield Ai V-BAT · S/N VB-200100N1877ZShield Ai V-BAT · S/N VB-100136N1885ZShield Ai V-BAT · S/N VB-100137N1891ZShield Ai V-BAT · S/N VB-100139N1892ZShield Ai V-BAT · S/N VB-100140N1866ZShield Ai V-BAT · S/N VB-100131N1872ZShield Ai V-BAT · S/N VB-100133N187GZShield Ai V-BAT · S/N VB-100132N1881ZShield Ai V-BAT · S/N VB-100135N1883VShield Ai V-BAT · S/N VB-100134N1890VShield Ai V-BAT · S/N VB-100138N207KTShield Ai V-BAT · S/N VB-100142N794VBShield Ai V-BAT · S/N VB-200097N795VBShield Ai V-BAT · S/N VB-200098N799VBShield Ai V-BAT · S/N VB-200101N33PKCirrus Design SF50 · S/N 0206N63STSkytrails Lsa PREDATOR E 582 · S/N PE6539986AN842ABTextron B300 · S/N FL-1094N287NSShield Ai V-BAT · S/N VBP-200011N786VBShield Ai V-BAT · S/N VB-200092N930QMMartin Uav V-BAT · S/N VBP-42N929RAMartin Uav V-BAT · S/N VBP-200007N9335TMartin Uav V-BAT · S/N VBP-100042N974PVMartin Uav V-BAT · S/N VB-100082N308VBShield Ai V-BAT · S/N VB-200056N3215SShield Ai V-BAT · S/N VBP-200017N3218SShield Ai V-BAT · S/N VBP-200018N322ESShield Ai V-BAT · S/N VBP-200019N3721DShield Ai V-BAT · S/N VB-100266N3722SShield Ai V-BAT · S/N VB-100265N372GVShield Ai V-BAT · S/N VB-100280N372KSShield Ai V-BAT · S/N VB-100279N372LSShield Ai V-BAT · S/N VB-100278N372MGShield Ai V-BAT · S/N VB-100277N372NTShield Ai V-BAT · S/N VB-100276N372QDShield Ai V-BAT · S/N VB-100275N372REShield Ai V-BAT · S/N VB-100274N372SJShield Ai V-BAT · S/N VB-100273N372TVShield Ai V-BAT · S/N VB-100272N372URShield Ai V-BAT · S/N VB-100271
Back to Frisco, TX