Skip to content

Warner Robins, GA

Cancelled registrations · 60

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 = 'WARNER ROBINS' 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 = 'WARNER ROBINS'
  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 = 'WARNER ROBINS'
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.

N810CNNorth Wing Uum SCOUT XC · S/N LS9026Cancelled Sep 27, 2024 · Exported to South Korea · Built 2017 · Sang Ahn Arthur N4909ECorben Baby Ace CRS-2 · S/N 5727Cancelled Dec 1, 2023 · Built 1959 · Kirkland Hugh E N482GCAgusta Bell AB206 C1 · S/N 9029Cancelled Nov 18, 2023 · Registration pending, canceled N50964Taylorcraft DCO-65 · S/N 5888Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1943 · Frs & Craig Llp N210BRCessna 210L · S/N 21060593Cancelled Mar 20, 2021 · Sale reported, canceled · Built 1974 N152LGCessna 152 · S/N 15282249Cancelled Jun 2, 2020 · Registration expired, pending cancellation · Built 1978 · Webbair LLC N795XHDJI INSPIRE 1 PRO · S/N W21ACL04020295Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Hamlin James F N3253YCessna 182E · S/N 18254253Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Smith Daniel N83LAWaters Thomas L QUICKIE Q2 · S/N 2074Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1983 · Leguia Augusto A N584THDJI S1000 · S/N 00L0120686Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Hamlin James F N586FHDJI PHANTOM 1 · S/N 635315352Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Hamlin James F N589JHDJI S1000 · S/N 02Q0021584Cancelled Feb 1, 2019 · Registration expired, pending cancellation · Hamlin James F N1000FCessna T210L · S/N 21060523Cancelled Jan 23, 2019 · Built 1974 · Givens Byron Keith Jr N9325SBeech C23 · S/N M-1640Cancelled Jun 19, 2018 · Exported to Canada · Built 1975 · Yemane Michael N1213KLuscombe 8A · S/N 3940Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1946 · Schulz Arland L N9004BBalloon Works FIREFLY 8B · S/N F8B-162Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1988 · Eagle James A N3297WPiper PA-32-260 · S/N 32-130Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1965 · Rigby Steve L N6141DKolb MARK II · S/N M-2-168Cancelled May 21, 2015 · Sale reported, canceled · Built 1990 N86054Aeronca 11BC · S/N 11AC-476Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Martin Phillip L N1852VCessna 120 · S/N 14120Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1947 · Martin Phillip L N9260BCessna 175 · S/N 55060Cancelled Aug 7, 2013 · Revoked, canceled · Built 1958 · Hughey James D Jr N1635VCessna 172M · S/N 17263699Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Neal Billy R N32233Stinson 10A · S/N 7949Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1941 · Camp William B N60966Commonwealth 185 · S/N 1642Cancelled Jul 16, 2013 · Revoked, canceled · Built 1946 · Tyus Larry N38HPConvair C-131A · S/N 52-5790Cancelled May 31, 2013 · Sale reported, canceled N5619RCessna 172F · S/N 17253234Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1965 · Wilcox R Chris N55LXBerg BUSHBY MUSTANG M II · S/N M-II-407Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1976 N28942Forney 415-C · S/N 37Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1968 · Tallent Anita A N621KBeech J35 · S/N D-5657Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1958 N29583Taylorcraft BL-65 · S/N 2426Cancelled Aug 30, 2012 · Sale reported, canceled · Built 1940 N42RPitts Special S-1C · S/N A-100Cancelled Jun 12, 2012 · Revoked, canceled · Built 1967 · Odonnell Richard A N22331Cessna 150H · S/N 15068220Cancelled Jul 28, 2011 · Registration pending, canceled · Built 1968 N70FBBaldwin Frank WOLF W-11 · S/N 39Cancelled Jan 27, 2010 · Exported to Italy · Built 1994 · Baldwin Dale A N1580CCessna 180 · S/N 30280Cancelled Sep 18, 2009 · Registration revoked · Built 1953 · Arnold Emerick E N99DHHutchins WITT FORMULA V RACER · S/N 1974Cancelled Sep 17, 2009 · Registration revoked · Built 1974 · Hutchins Dennis W N1302Midget Mustang MM-1 · S/N VLT-135Cancelled Jun 30, 2009 · Registration revoked · Built 1967 · Thaxton Van L N845Stinson 108-1 · S/N 108-1082Cancelled Mar 7, 2007 · Triennial form not returned · Built 1946 · Wells James H N81DCAero Commander 100 · S/N 124Cancelled May 20, 2005 · Built 1967 · Thompson Neal Richard N1053WHolloway Hubert L STOLP SA750 · S/N 242Cancelled Jan 28, 2005 · Triennial form not returned · Holloway Hubert L Jr N102HACessna 150F · S/N 15064386Cancelled Jan 16, 2004 · Built 1966 · Middle Georgia Technical College N12478Cessna 172M · S/N 17262006Cancelled Jan 16, 2004 · Built 1973 · Middle Georgia Technical College N425KBeech B90 · S/N LJ-318Cancelled Jan 16, 2004 · Triennial form not returned · Built 1967 · Middle Georgia Technical College N7673BBellanca 14-19-2 · S/N 4024Cancelled Jan 16, 2004 · Triennial form not returned · Built 1957 · Middle Georgia Technical College N99EHPiper PA-31P · S/N 31P-7400201Cancelled Jan 16, 2004 · Triennial form not returned · Built 1974 · Middle Georgia Technical College N8385EMooney M20A · S/N 1563Cancelled Sep 30, 2002 · Triennial form not returned · Built 1960 · Fuller Ronnie L N36DADavis BABY ACE D · S/N 10-14-37Cancelled Sep 10, 2002 · Registration revoked · Built 1975 · Davis Vergil N11HCConant-Holman PITTS SPECIAL S-1C · S/N 70-1HCCancelled Feb 22, 1999 · Sale reported N87027Bellanca 7GCBC · S/N 71074Cancelled Nov 5, 1998 · Triennial form not returned · Cody Ernest Jay N8857PPiper PA-24-260 · S/N 244314Cancelled Aug 31, 1998 · Second triennial mailing, no response · Mansour Paul J N72SDMoore David W LONG-EZ · S/N 750Cancelled Sep 21, 1992 · Exported to United Kingdom · Moore David W

Back to Warner Robins, GA