Raleigh, NC
Cancelled registrations · 401
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 = 'RALEIGH' 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 = 'RALEIGH' 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.
N506SRCirrus Design SR20 · S/N 1692N4653HPiper PA-17 · S/N 17-63N113WTFlight Design CTLS · S/N F-12-02-10N5039WPiper PA-28 · S/N 28-41N228CHSocata TBM 700 · S/N 356N60124Bell Helicopter UH-1H (205) · S/N 10419N707AGPiper PA-31-325 · S/N 31-8012001N406MCRaytheon 400A · S/N RK-406N756WSDJI PHANTOM 3 PROFESSION · S/N P76DCH26A20708N692MCDJI FLAMEWHEEL F550 · S/N USIEE1N647FRDJI PHANTOM VISION 2+ · S/N PH645200155 V2.0N190EMTrimble Navigation UX5 · S/N EBX00698N26617Cessna 182S · S/N 18280330N9232PMaule MXT-7-180 · S/N 14015CN532SDDJI PHANTOM 2 · S/N PH645182031N3555SCessna 172E · S/N 17250755N5944UPiper PA-28-140 · S/N 28-26837N562AAYuneec International Q500 TYPHOON · S/N YU15031122B01101N8431VRockwell International S-2R · S/N 2191RN774XASensefly EBEE · S/N EB-03-13641N55917Aeronca 0-58B · S/N 7722751N46682Taylorcraft DCO-65 · S/N 0-4240N5058MTaylorcraft BF · S/N 10358N5421Sensefly EBEE · S/N EB-03-10824N326DJYuneec International TYPHOON Q500+ · S/N YU15230731B02D01N658PHPrecisionhawk HAWKEYE MKIII LANCAS · S/N LK3144413N1019Precisionhawk HAWKEYE MKIII LANCAS · S/N 001104-1N1044Precisionhawk HAWKEYE MKIII LANCAS · S/N 001104-2N1092Precisionhawk HAWKEYE MKIII LANCAS · S/N 001104-4N1157Precisionhawk HAWKEYE MKIII LANCAS · S/N 001235-1N1163Precisionhawk HAWKEYE MKIII LANCAS · S/N 001235-2N1180Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-1N1280Precisionhawk USA HAWKEYE MKIII LANCAS · S/N 001104-5N1377Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-2N1385Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-3N1503Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-4N1592Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-6N1623Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-7N1882Precisionhawk HAWKEYE MKIII LANCAS · S/N 001221-1N1897Precisionhawk HAWKEYE MKIII LANCAS · S/N 001221-2N2032Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-1N2034Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-2N2038Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-5N2039Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-6N2042Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-7N2044Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-8N2058Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-11N2074Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-14N2075Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-15N2080Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-16
Back to Raleigh, NC