Fayetteville, AR
Cancelled registrations · 86
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 = 'AR' AND d.registrant_city = 'FAYETTEVILLE' 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 = 'AR' AND d.registrant_city = 'FAYETTEVILLE' 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.
N232ATAir Tractor AT-802A · S/N 802A-0051N61246Air Tractor AT-802 · S/N 8020018N9151QAir Tractor AT-401 · S/N 401-0896N99BTMitsubishi MU-2B-35 · S/N 591N673VBeech M35 · S/N D-6273N815PBChampion 7EC · S/N 7EC453N80950Cessna 172M · S/N 17266816N1532BAir Tractor AT-502 · S/N 502-0167N187PACessna 182S · S/N 18280187N9032VBeech F33A · S/N CE-378N325BRAir Tractor AT-602 · S/N 602-1147N102GDAmerican Champion 8KCAB · S/N 751-95N6781ECessna 175A · S/N 56281N650FADJI S800 · S/N 5B999590CL25BCAB0A2N60893Air Tractor AT-502B · S/N 502B-0288N3031JAir Tractor AT-502B · S/N 502B-2892N626ESDJI S1000 · S/N 02Q0023057N627ZKDJI PHANTOM 2 · S/N PH646C48171N45317Cessna 150M · S/N 15076839N3239BPiper PA-22-135 · S/N 22-2069N7BEBeech 58 · S/N TH-442N2460YCessna 172D · S/N 17249760N901RWRichard L Ward RICHARD L WARD · S/N 101N500KZBarnes Norman J MINI-500 · S/N 325N964ARJohnson Donald H LIBERTY X-2 · S/N 002N71390Cessna 172M · S/N 17267224N1476PPiper PA-23 · S/N 23-543N8788HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1528N1895WBeech 58 · S/N TH-342N662UGrumman G-164 · S/N 398N6671Beech 3NM · S/N CA-152N24SVPiper PA-34-200 · S/N 34-7250280N16EGGriffith Emmett M TIGER MOTH REPLICA · S/N TM-20N25322Cessna 152 · S/N 15280594N43005Taylorcraft BC12-D · S/N 6664N97502Stinson 108 · S/N 108502N111BPDassault/Sud FAN JET FALCON · S/N 111N810APiper PA-22 · S/N 22-112N1100JRaytheon A36 · S/N E-3058N47365Aeronca 0-58B · S/N 058B-13334N2728SCessna 150G · S/N 15066628N32FYAeronca/Younkin L-16A · S/N 47-1013N6672Beech C18S · S/N 192N6465KAerostar International RAVEN S-55A · S/N S55A-3022N627ZBeech D-50 · S/N DH-84N6177PPiper PA-24 · S/N 24-1279N524MFHarris Floyd R GLASTAR-1 · S/N 5101N561ASCessna 550 · S/N 550-0383N60971Cessna 150J · S/N 15070705N2144KLuscombe 8A · S/N 4871
Back to Fayetteville, AR