Nashville, AR
Cancelled registrations · 60
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 = 'NASHVILLE' 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 = 'NASHVILLE' 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.
N4164TRobinson Helicopter R44 · S/N 1882N9600DPiper PA-22-160 · S/N 22-6509N8455ABeech A35 · S/N D-2011N7213SCessna 150H · S/N 15067913N5407PPiper PA-24 · S/N 24-461N1156DCessna 140A · S/N 15719N50034Maynard Joe HIPPS RELIANT SX · S/N 62035N981RBeech J35 · S/N D-5338N8749MBeech 23 · S/N M-537N8784MBeech A23 · S/N M-569N7843DPiper PA-22-150 · S/N 22-5493N72767Cessna 120 · S/N 9950N65533Boeing 75 · S/N 75-3494N6868UMooney M20E · S/N 180N51066Cessna 150J · S/N 15069741N5123DCessna 182A · S/N 51223N2494NPiper PA-38-112 · S/N 38-79A0872N3531UCessna 172S · S/N 172S8824N4457DBeech G35 · S/N D-4610N5831UPiper PA-28-140 · S/N 2826662N9895WPiper PA-28-140 · S/N 2823415N8474RPiper PA-28-140 · S/N 2822380N34477Cessna 177B · S/N 17701830N3852DCessna 182A · S/N 34552N6558VBellanca 17-30A · S/N 30263N606FLPiper PA-28-140 · S/N 287125483N6458ECessna 172 · S/N 46558N6678VBellanca 17-30 · S/N 30042N2964QCessna 421A · S/N 421A0064N1635DCessna 170B · S/N 20277N23286Cessna 150H · S/N 15068850N3222WPiper PA-32-260 · S/N 3228N326JACessna 206 · S/N 2060066N9829Grumman Acft ENG Cor-Schweizer G-164A · S/N 1289N6317UCessna TU206G · S/N U20605420N8FRBeech B-55 · S/N TC-1916N95DDBeech C90 · S/N LJ-637N5826SBeech 35-C33 · S/N CD-817N1897WBeech E-55 · S/N TE924N100PEBeech J50 · S/N JH-168N9939ACessna 170A · S/N 19299N6823QBeech 65-A80 · S/N LD-160N100BZBeech A36 · S/N E-538N273MBBeech H-18 · S/N BA-655N9514QBeech 65-B80 · S/N LD-306N4198RPiper PA-32-300 · S/N 32-40539N8471NBeech 95-B55 · S/N TC-1107N8762ABeech A35 · S/N D-2184N6359NChampion 7GCAA · S/N 150N9288BCessna 175 · S/N 55088
Back to Nashville, AR