North Little Rock, AR
Cancelled registrations · 42
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 = 'NORTH LITTLE ROCK' 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 = 'NORTH LITTLE ROCK' 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.
N2083VCessna 120 · S/N 14315N6161CKohut Mark A MURPHY SR 2500 · S/N 015SRN345PHRobinson Helicopter R66 · S/N 0227N7420LBalloon Works FIREFLY 7 · S/N F7-289N680PCBeech 56TC · S/N TG-24N550KBeech 95-B55 · S/N TC-2180N8118Dallair Aeronautica DALLAIR FR 100 SNAP · S/N 1113N89826Cessna 140 · S/N 8875N43762Bell-Watson 47-G · S/N W1007N52150Piper NE-1 · S/N 8159N305CGRobinson Helicopter R44 II · S/N 11492N123CSCessna 401A · S/N 401A0035N827QNoble Robert Allen QUICKIE Q-200 · S/N 2790N3416PPiper PA-23-160 · S/N 23-1380N116AHomebuilt BG 12-X · S/N JHA-3N57274Raven S55A · S/N S55A-787N150TGCessna 150J · S/N 15069470N5677YRaven S55A · S/N S55A-463N855VCVancleve Ralph H LONG-EZE · S/N 855N4397ARaven S-60A · S/N S60A-334N83755Ragsdale UFM-EASYRISER · S/N 124N8610SCessna 150F · S/N 15061910N5839ECessna 150 · S/N 17339N4739CBeech D-45 · S/N BG-367N645MAPiper PA-23-250 · S/N 27-2456N3566APiper PA-22 · S/N 22-1840N5431ACessna 310B · S/N 35631N72901Cessna 140 · S/N 10095N995TDLearjet 24 · S/N 149N173VEHowe Cory VELOCITY 173 RG ELTE · S/N 301N18248Anderson ZMA-000 · S/N 1N757UKCessna 152 · S/N 15280012N8763DPiper PA-22-160 · S/N 225949N8041CBeech U-8D · S/N 581341N757KDCessna 152 · S/N 15279793N5931WPiper PA-28-160 · S/N 28-3379N4807SPiper PA-32-260 · S/N 321191N18512Cessna 150L · S/N 15073903N26504Taylorcraft BL-65 · S/N 1845N86274Aeronca 11AC · S/N 11AC-79N75626Consolidated Vultee BT-13A · S/N 11088N6404KRepublic RC-3 · S/N 648
Back to North Little Rock, AR