High Point, NC
Cancelled registrations · 51
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 = 'HIGH POINT' 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 = 'HIGH POINT' 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.
N651KPDJI PHANTOM 4 · S/N 07DDD4C0A10780N420CStinson 108-2 · S/N 108-3420N1034GFisher James E BAKENG DUCE · S/N 451N265PMCessna R182 · S/N R18201925N55014Buckeye DREAM MACHINE · S/N 6108N655DEDehavilland DHC-2 · S/N 1561N22BDEmbraer EMB-120RT · S/N 120.143N7738BStits Playboy SA3B · S/N NDW-1N999APiper PA-22 · S/N 22-333N54183Piper PA-23-250 · S/N 27-7405462N6401NCessna 210N · S/N 21062977N407FAWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0407N990KUI.C.A.-Brasov IS-28B2 · S/N 39N111SBWittman TAILWIND · S/N 33022N18854King BENSEN B-8M · S/N DLK6-9-42N233VWLayson Stanley B STEEN SKY BOLT · S/N 1JH4SBLN223BDEmbraer EMB-120 · S/N 120.260N8039MBeech F33A · S/N CE-1588N26665Taylorcraft BL-65 · S/N 2007N8162NPiper PA-28-140 · S/N 28-25358N74PTThomas P A THOMAS OUTBACK · S/N S96060181N614AGBoeing 727-200 · S/N 22377N612AGBoeing 727-2B6 · S/N 21297N90514Grumman Acft ENG Cor-Schweizer G-164B · S/N 107BN641KEMitsubishi MU-2B-26 · S/N 320N4447FCessna P210N · S/N P21000619N55AGCessna R182 · S/N R18200034N360BUCessna 310R · S/N 310R0876N5600TCessna 172E · S/N 17251500N8210DBeech H35 · S/N D-5297N2938FCessna 182J · S/N 18257038N52993Fairchild M-62A-3 · S/N FZ-273N8632WPiper PA-28-235 · S/N 22-10147N9327JPiper PA-28-180 · S/N 28-3421N96621Taylorcraft BC12-D · S/N 8921N1647PPiper PA-22 · S/N 22-2463N5085PPiper PA-24-180 · S/N 24-91N43919Taylorcraft BC12-D · S/N 7578N54XBoeing B75N1 · S/N 754322N39934Taylorcraft BC12-D · S/N 6587N23167Piper J3L · S/N 2949N52872Cessna T-50 · S/N 4856N3127HErcoupe 415-C · S/N 3752N9775HCessna T-50 · S/N 2738N6028MStinson 108-3 · S/N 108-4028N654Waco 9 · S/N 269N19507Piper J-2 · S/N 1707N16559Aeronca LC · S/N 2047N566NCurtiss Wright ROBIN 4C-1A · S/N 718N5387Waco 9 · S/N 198
Back to High Point, NC