Waxhaw, NC
Cancelled registrations · 70
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 = 'NC' AND d.registrant_city = 'WAXHAW' 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 = 'NC' AND d.registrant_city = 'WAXHAW' 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.
N6862NMooney M-20G · S/N 680121N229WJMB Aircraft S R O VL-3EH-916 · S/N VL-3-603N3090UCessna 172E · S/N 17250690N70UKGulfstream American G-1159A · S/N 454N6490VHelio H-295 · S/N 1444N6484VHelio H-295 · S/N 1439N5094XChampion 7ECA · S/N 653N642ESDJI PHANTOM 3 PROFESSION · S/N P76DCE16011723N654SSnow Richard H PHANTOM X-1 · S/N 392116N319RAS.O.C.A.T.A. RALLYE 150 ST · S/N 3068N483SSPdps Pzl-Bielsko SZD-48-3 · S/N B-2121N115AFCessna 310L · S/N 310L-0026N60JAHelio H-295 · S/N 1240N77KQQuest KODIAK 100 · S/N 100-0077N7145MCessna 175 · S/N 55445N5321MMcginnis Buddy L CGS HAWK A · S/N AAH5-159N4431YHelio H-295 · S/N 1227N199TBBell 206L-3 · S/N 51511N499KQQuest KODIAK 100 · S/N 1000048N497KQQuest KODIAK 100 · S/N 100-0038N4292PCessna U206F · S/N U20603207N57981Hiller OH-23D · S/N 1302N4691UCessna TU206G · S/N U20605060N498KQQuest KODIAK 100 · S/N 100-0008N927MXPilatus PC-6/B2-H4 · S/N 927N8282UBeech 58 · S/N TH-1686N331JTTravis Justin B JUSTIN TRAVIS JET EX · S/N 6056N3198ZBell 206L-3 · S/N 51156N3382CBeech F35 · S/N D-4049N6620ZCessna TU206G · S/N U20606347N401APiper PA-23-250 · S/N 27-3023N90953Hiller H-23D · S/N 61-3194N90955Hiller H-23D · S/N 64-15301N60182Cessna 150J · S/N 15070129N87741Helio USAF U-10B · S/N 606N6253Carter BENSEN B-8M · S/N 239640049N379PCessna 402C · S/N 402C0263N6511YPiper PA-23-250 · S/N 273802N300CSBell Helicopter Textron 206L-1 · S/N 45612N8026SCessna 150F · S/N 15061626N8613UCessna 172F · S/N 17252514N48066Douglas C-47J · S/N 4499827N6TMPiper PA-23-250 (6PCLM) · S/N 27-3042N6787ZCessna 402C · S/N 402C0422N87731Helio H-295 · S/N 1235N756CGCessna U206G · S/N U20603979N14635Hiller UH-12E · S/N 1587N9427GCessna U206E · S/N U20601627N30TUPilatus PC-6/B2-H2 · S/N 726N8265QCessna TU206F · S/N U20603126
Back to Waxhaw, NC