Skip to content

Cancelled registrations · 146

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 = 'TX' AND d.registrant_city = 'SPRING' 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 = 'TX' AND d.registrant_city = 'SPRING'
  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 = 'TX' AND d.registrant_city = 'SPRING'
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.

N969AZClarke John EZ FLYER · S/N 049BYACancelled May 15, 2017 · Registration expired, pending cancellation · Clarke John E N512PHAmerican Eurocopter AS350B3 · S/N 4607Cancelled Mar 14, 2017 · Exported to Canada · Built 2009 · Helicopter Services Inc N204HNAerospatiale AS350 B2 ECUREUIL · S/N 2835Cancelled Jul 8, 2016 · Exported to Panama · Built 1994 N103HNAerospatiale AS350 B2 ECUREUIL · S/N 2575Cancelled Apr 29, 2016 · Exported to Mozambique · All American Aviation LLC N350LNEurocopter AS 350 B2 · S/N 3708Cancelled Apr 22, 2016 · Exported to New Zealand · Built 2003 N197AMEurocopter AS 350 B2 · S/N 2917Cancelled Feb 4, 2016 · Exported to Canada · Built 1996 N222LNBell 222U · S/N 47544Cancelled Nov 2, 2015 · Exported to South Africa · Built 1985 N427MABell 222U · S/N 47558Cancelled Nov 2, 2015 · Exported to South Africa · Built 1987 N9584KStinson 108-2 · S/N 108-2584Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1947 · Gullotti Paul S N5248FCessna 172F · S/N 17252442Cancelled May 13, 2015 · Sale reported, canceled N12ANPiper PA-23-235 · S/N 27-558Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1963 · Kdw Schools Inc DBA N200AZAerodis America AA200 · S/N 001Cancelled May 4, 2015 · Registration expired, pending cancellation · Aerodis America Inc N405BMMathews Byrdell B MATHEWS PEGAZAIR · S/N 930655Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1996 · Mathews Byrdell B N30155Oday Kerry D SONERI II · S/N 1284Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1948 · Oday Kerry D N8782UCessna 150M · S/N 15077989Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1976 · Connell James G N78SWHiller H-23D · S/N 1358Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1961 · Meyer Henry N80925Piper PA-28-181 · S/N 28-8090097Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1979 · Reid Robert L N6328FCessna 337A · S/N 337-0328Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1966 · Kdw Schools Inc DBA N3795XAero Commander 100 · S/N 292Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1968 · Kirkham Kenneth L N2946YPiper PA-32-300 · S/N 32-7940220Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1979 · J A Kent Investments N2275BBell 47G · S/N 53-3662Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Sky Pro Inc N2379VPiper PA-38-112 · S/N 38-82A0060Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1982 · Travel Air Service Inc N849KSSchweizer 269C-1 · S/N 0310Cancelled Apr 25, 2014 · Exported to China · Built 2007 · Helicopter Services Inc N7165KZiebell Grant G KOLB TWINSTAR MK II · S/N M2-283Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1991 · Planter Bill E N7022DBeech 60 · S/N P-13Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1968 · Konicki Joseph S N342RDSmith Harold F ROTORWAY EXEC · S/N 4162Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1991 · Spagnoletti Anthony N17130Cessna 150L · S/N 15073630Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1972 · Huddleston Ronnie L N82HTCessna 172N · S/N 17272078Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1978 · M & D Aviation Inc N1345EFluker Reid HUMMER B · S/N 0088-ACancelled Jun 18, 2013 · Registration expired, pending cancellation · Fluker Reid N979BBCessna 182P · S/N 18261930Cancelled Jun 17, 2013 · Exported to Canada · Built 1973 · Svr Transportation LLC N511AAZitzmann/Lawrence/Galeoti FALCON XP · S/N 600122Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Falcon-American Arv Inc N88001Morrisett 1CARUS II · S/N 029Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1974 · Morrisett G Curtis N7724JPiper PA-32-260 · S/N 32-1126Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Mock Joseph R N714UXCessna 152 · S/N 15279453Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1977 · Turcotte Joseph R N6704TCessna 310C · S/N 39004Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1959 · Jones Dean R N6713BPiper PA-22-150 · S/N 22-4046Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1956 · Kissling Don L N872CLLacourse R/Costello J A VARI EZE · S/N 206ACancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1990 · Lacourse Richard N5920PPiper PA-24-250 · S/N 24-1007Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1959 · J Douglas Properties Inc N8208SCessna 150F · S/N 15061808Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1965 · May Jerry D N89032Cessna 152 · S/N 15282603Cancelled Feb 1, 2013 · Exported to Mexico · Built 1978 · M & D Aviation Inc N234LARobinson Helicopter R22 BETA · S/N 3534Cancelled Jan 29, 2013 · First renewal notice · Built 2004 · Helicopter Services Inc N281RGRobinson Helicopter R22 BETA · S/N 4250Cancelled Jan 29, 2013 · Built 2007 · Helicopter Services Inc N314LSBell 206L-3 · S/N 51006Cancelled Jan 23, 2013 · Exported to Paraguay · Built 1982 N93CHBell 206L-3 · S/N 51314Cancelled Dec 20, 2012 · Exported to Paraguay · Built 1989 · Gulf State Aviation LLC N4471HPiper PA-15 · S/N 15-260Cancelled Nov 30, 2012 · Registration expired, pending cancellation · Built 1948 · Wensien Michael N N139DSSurbrook David W MONNETT MONI · S/N 139Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Surbrook David W N300LPPruett Alfred L SKYBOLT · S/N 1Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Pruett Alfred L N400PRHawker Siddeley DH.125-400A · S/N NA732Cancelled Sep 12, 2012 · Registration pending, canceled · Built 1969 N48421Cessna 152 · S/N 15283338Cancelled Aug 27, 2012 · Sale reported, pending cancellation · Built 1979 N34954Hiller UH-12D · S/N 1274Cancelled Aug 14, 2012 · Registration pending, canceled · Built 1961

Back to Spring, TX