Skip to content

Cancelled registrations · 95

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 = 'AZ' AND d.registrant_city = 'GILBERT' 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 = 'AZ' AND d.registrant_city = 'GILBERT'
  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 = 'AZ' AND d.registrant_city = 'GILBERT'
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.

N180XZCessna 180A · S/N 32693Cancelled Jul 29, 2014 · Registration expired · Flying High LLC N71546North American T-28C · S/N 140528Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1957 · Freeman John N1848KLuscombe 8E · S/N 4575Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1946 · Luscombe Endowment Inc N4312EZeitlin/Macleod/Nwanagu Q2 · S/N 1Cancelled Aug 19, 2013 · Sale reported, canceled · Built 2000 N3697DBalloon Works FIREFLY 8B · S/N F8B-004Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1984 N8133LCessna T210L · S/N 21060620Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1974 N3030KPiper PA-34-200T · S/N 34-7970103Cancelled Aug 1, 2013 · Exported to Peru · Built 1979 · Horn Tyler Ray N421DMDomzalski David/Mark B-8M · S/N 01Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Domzalski David B N340TFCessna 340A · S/N 340A0248Cancelled Jul 10, 2013 · Exported to Canada · Germaine Noah R N67583Cessna 152 · S/N 15281929Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1978 · Baldry James S Jr N7124XBalloon Works FIREFLY 7 · S/N F7-444Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1988 · Winds Aloft Balloon Co Inc N58258Schuring James M HOVEY DELTA BIRD · S/N J1983MSCancelled Jun 12, 2013 · Registration expired, pending cancellation · Schuring James M N349CADiamond Aircraft Ind DA20-C1 · S/N C0049Cancelled May 14, 2013 · Exported to Canada · Built 1999 · Don A Mynard Consulting LLC N300HWHawker Siddeley DH.125-1A · S/N 25021Cancelled May 3, 2013 · Registration expired, pending cancellation · Hunter Aivation Inc N124DKBraegger Michael K G L NIEUPORT 17 · S/N 585Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1993 · Braegger Michael K N158HAHiller UH-12E · S/N HA3058Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1977 N7214KJudjahn Gerhard W TUNDR4 · S/N TUN970150045Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1997 N49835Cessna 152 · S/N 15281349Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1978 · Eagles Roost Aviation Services LLC N4713RBell 47G-5 · S/N 7922Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1968 · Maris John N N33BLBeech N35 · S/N D-6671Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1961 N1060JBell 47G-5 · S/N 7832Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Peed Robert M N4727CBeech C18S · S/N 4199Cancelled Aug 6, 2012 · Revoked, canceled · Built 1943 · Dale Robert N71446Luscombe 8A · S/N 2873Cancelled Aug 6, 2012 · Registration pending, canceled N223KTMooney M20M · S/N 27-0067Cancelled Apr 10, 2012 · Exported to Canada · Bissell James R N1650ECessna 172N · S/N 17271080Cancelled Dec 22, 2011 · Exported to Mexico · Built 1978 · Basko James L N4579DBeech G35 · S/N D-4753Cancelled Apr 15, 2011 · Exported to Canada · Built 1956 · Skinner James R N73PKKruse Paul G APEX 5XPK · S/N 001Cancelled Feb 28, 2011 · Triennial form not returned · Built 2004 · Kruse Paul G N2905QCessna U206F · S/N U20603014Cancelled Dec 4, 2008 · Sale reported · Built 1975 N201Irwin Gary LANCEAIR 360 · S/N 352-320-109-6PCancelled Aug 28, 2008 · Irwin Gary N9276TPiper PA-38-112 · S/N 38-78A0313Cancelled Jul 29, 2008 · Built 1978 · Mcdaniel Barry W N7490MCessna 175 · S/N 55790Cancelled Feb 5, 2007 · Triennial form not returned · Built 1959 · Hug Frederick W N309BDDeford Brian DEFORD COZY MI-IV · S/N 001Cancelled Sep 6, 2006 · Built 2002 · Deford Brian L N856ERCessna 152 · S/N 15281981Cancelled Sep 28, 2005 · Triennial form not returned · Built 1978 · Eagles Roost Aviation Services LLC N5406QCessna 150L · S/N 15073306Cancelled Feb 23, 2005 · Built 1972 · Murphy Mike J N2313KCombs Doug HEAVY 11 · S/N 0011Cancelled Jun 25, 2002 · Combs P Douglas N2526CCombs Doug HEAVY 1 · S/N 001Cancelled Mar 21, 2002 · Combs P Douglas N94818Ercoupe 415-E · S/N 4932Cancelled Jul 19, 2000 · Yuppa Carmine N1039QCessna 310H · S/N 310H0039Cancelled Jan 22, 1997 · Registration pending N6410Stits Skycoupe SA7D · S/N RW1Cancelled May 8, 1992 · Triennial form not returned · Domzalski Mark G N541TBeech N35 · S/N D6708Cancelled Aug 5, 1991 · Triennial form not returned · Berland Craig A N71PBGrumman G-164A · S/N 893Cancelled Jun 28, 1988 · Exported to Mexico · Barnes Phillip N2606MHarris Jack R QUICKSILVER MX II · S/N 4024Cancelled Apr 3, 1984 · Administratively canceled · Harris Jack R N5770ACessna 172 · S/N 28370Cancelled May 6, 1981 · Carpenter Jerald W N1148NBoeing E75 · S/N 75-5096Cancelled Dec 7, 1964 · Gerald Bulkley N6283ZPiper PA-25 · S/N 25-353Cancelled Oct 23, 1964 · Exported to Mexico · Built 1960 · Bulkley Gerald

Back to Gilbert, AZ