Cancelled registrations · 26

Query with SQL

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 = 'GA' AND d.registrant_city = 'JONESBORO' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'GA' AND d.registrant_city = 'JONESBORO'
  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 = 'GA' AND d.registrant_city = 'JONESBORO'
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.

N704AKAntenor Velazco LANCAIR EVOLUTION · S/N EVO - 070Cancelled Oct 23, 2021 · Akv Aviation LLC N299CCBell OH-58 · S/N 70-15484Cancelled Nov 20, 2018 · Clayton County Police Department N1831WBeech A36 · S/N E-388Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1973 · Aps Aviation LLC N297CCBell OH-58C · S/N 71-20704Cancelled Dec 5, 2017 · Clayton County Police Department N35594Cessna 172I · S/N 17256856Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1968 · Hyatt Alex K N7776FCessna 150F · S/N 15063876Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1966 · Bedford Vernon L N50RFFauscett Russell Royal ROTORWAY-EXEC · S/N 3170Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Fauscett Russell R N2053Garrett STARDUSTER TOO · S/N 165Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1972 N2761YBeech 95 · S/N TD-123Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1958 · Turner Joseph C N3447VCessna 195 · S/N 7137Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1948 N2514EPiper PA-38-112 · S/N 38-78A0477Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1978 · Expressway Air Service Inc N2280APiper PA-22-135 · S/N 22-671Cancelled Aug 14, 2012 · Registration pending, canceled · Built 1952 N2061MPiper J3C-65 · S/N 20834Cancelled Aug 8, 2012 · Sale reported, canceled · Built 1946 N119TBeech G18S · S/N BA-488Cancelled Jun 4, 2012 · Sale reported, canceled · Built 1960 N62601Piper PA-23-250 · S/N 27-7654079Cancelled Oct 1, 2009 · Triennial form not returned · Built 1976 · Miller-Shrieves Renee E N408JDCessna 650 · S/N 650-0035Cancelled Sep 5, 2008 · Exported to Mexico · Built 1984 · Eagle Jets LLC N32TJEurocopter AS 350 B3 · S/N 3097Cancelled Jan 19, 2007 · Triennial form not returned · Eagle Jets LLC N917ATCessna 172Q · S/N 17275932Cancelled Jan 31, 2003 · Exported to United Kingdom · Built 1982 · Davis Stephen R N2269LTalley Gene TALLEY-GREGA GN-1 AC · S/N 2577Cancelled Jul 27, 2000 · Talley Gene W N667GACessna R172E · S/N R172-0150Cancelled Nov 29, 1999 · Reeves James C N3247UVlahakes Nick BD-5 · S/N 170Cancelled Aug 13, 1996 · Triennial form not returned · Vlahakes Nick N4175PPiper PA-23-160 · S/N 231662Cancelled May 14, 1993 · Triennial form not returned · Suber Robnert L N9119Ben Epps 1911 · S/N E1Cancelled Jul 8, 1991 · Triennial form not returned · Georgia Aircraft Museum Inc N6404KCessna 150M · S/N 15077685Cancelled Feb 23, 1985 · Expressway Air Service Inc N2068PPiper PA-23 · S/N 23-655Cancelled Jul 14, 1977 · South Expressway Airport Inc N7430XCessna 172B · S/N 17247930Cancelled Aug 11, 1964 · South Expressway Airort Inc

Back to Jonesboro, GA