Skip to content

Cancelled registrations · 73

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 = 'GARLAND' 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 = 'GARLAND'
  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 = 'GARLAND'
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.

N1907PPiper PA-22 · S/N 22-2654Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Ball John T N151JDJoseph D Muse P51D EXPERIMENTAL · S/N F869Cancelled May 21, 2022 · First renewal notice · Built 2016 · Muse Joseph D N81195Fantasy Air Sro ALLEGRO 2000 · S/N 06-228Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2006 · Northam Alan R N91601North American NAVION · S/N NAV-4-372Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1946 · Matt David A N7534URobinson Helicopter R22 BETA · S/N 3661Cancelled Mar 16, 2021 · Exported to Romania · Built 2004 · Sky Helicopters Inc N8325PPiper PA-24-250 · S/N 24-3576Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1963 · Nation David L Jr N95545Taylorcraft BC12-D · S/N 7845Cancelled Dec 28, 2020 · Registration expired, pending cancellation · Built 1946 · Sandell Spencer L N65382Boeing A75N1(PT17) · S/N 75-4248Cancelled May 8, 2020 · Revoked, canceled · Built 1942 · Rogers James T N259SHRobinson Helicopter R22 BETA · S/N 4227Cancelled May 31, 2019 · Exported to Israel · Built 2007 · Sky Helicopters Inc N26095Phipps EASYRISER · S/N ER-261Cancelled Jan 14, 2019 · Revoked, canceled · Built 1976 · Phipps John Q N3973WPiper PA-32-260 · S/N 32-901Cancelled Sep 11, 2018 · Registration expired, pending cancellation · Built 1967 · Seehorn James M N7486ACessna 172 · S/N 29586Cancelled Apr 6, 2018 · Revoked, canceled · Built 1956 · Humphries A L Co Ow N168WWWisley William B SR SNS8-HIPERLIGHT · S/N 52Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1993 · Wisley William B Sr N5620NPowrachute PEGASUS · S/N A-191-PEGCancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 2002 · Folstadt Robert H N1508ZBalloon Works FIREFLY 7-B · S/N F7B-004Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1982 · White Victor N8697MBeech P35 · S/N D-7283Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1963 · Strann Daniel R N3585GAerostar International RX 8 · S/N RX8-3051Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1990 · Hays Craig N10029U-Fly-It Ultralights CHALLENGER II · S/N CH2-2307Cancelled Aug 5, 2016 · Third renewal notice · Built 2005 · Stephens Laurence G N135CStinson 108-2 · S/N 108-3135Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1947 · Bowen Brad N7261TCessna 172A · S/N 46861Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1959 · Ata Company N733TWBoeing 737-2H4 · S/N 22732Cancelled Jun 3, 2014 · Exported to South Korea · Built 1982 · Commercial Jet Partners LLC N61246Quicksilver SPORT 2S · S/N SPORT 2S 0184Cancelled Nov 7, 2013 · Built 2006 · Cawthon Charles D N1498PPiper PA-23-150 · S/N 23-568Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1956 N3977MMedema Dave E RAVEN/MEDEMA S-60A · S/N 012Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Medema Dave E N7973FCessna 150F · S/N 15064073Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1966 · Young Ray A N6745WPiper PA-28-140 · S/N 28-20868Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1965 · Romine Steven J N911SGRobinson Helicopter R44 II · S/N 12350Cancelled Apr 26, 2013 · Exported to Canada · Built 2008 · Sky Helicopters Inc N5749SSchweizer SGS 1-26C · S/N 385Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1968 · Crawford Gary W N126AEEvaul Robert W P-26A · S/N 1Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Evaul Robert W N4245UCessna 150D · S/N 15060245Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1963 · Shaffer John J N2460ZGeneral Balloon AX-6 · S/N 460Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1979 · Gibbons D N45806Wiese DUSTER · S/N 356Cancelled Jul 24, 2012 · Revoked, canceled · Wiese Arthur K N6574ZAerostar International RX-7 · S/N RX7-3153Cancelled May 27, 2010 · Triennial form not returned · Built 1988 · Hays Marilyn N732WGCessna T210M · S/N 21061828Cancelled Mar 30, 2010 · Exported to Bolivia · Built 1977 · Ramallo Rita V N644SHRobinson Helicopter R44 II · S/N 10819Cancelled Mar 17, 2010 · Exported to New Zealand · Built 2005 · Sky Helicopters Inc N758CVCessna R172K · S/N R1722997Cancelled Dec 31, 2009 · Exported to Bolivia · Built 1978 · Ramallo Rita V N8434HPiper PA-34-220T · S/N 34-8133219Cancelled Dec 31, 2009 · Exported to Bolivia · Built 1981 · Ramallo Rita V N2910ZPiper PA-22-150 · S/N 22-6880Cancelled Oct 19, 2009 · Registration revoked · Built 1959 · Griffis Orman W N198DKCessna T210M · S/N 21062870Cancelled Oct 14, 2009 · Exported to Bolivia · Built 1978 · Ramallo Rita V N87AMCessna U206G · S/N U20606888Cancelled Jul 30, 2009 · Exported to Bolivia · Built 1985 · Ramallo Rita V N2606SCessna 337C · S/N 337-0906Cancelled Jul 15, 2009 · Registration revoked · Built 1968 · Johnson Carl N1875MCessna 337G · S/N 33701475Cancelled Jul 9, 2009 · Registration revoked · Built 1973 · Gilley Larry W N1330PPiper PA-23-150 · S/N 23-374Cancelled Jul 6, 2009 · Registration revoked · Built 1955 · Johnson Carl DBA N4877ZCessna U206G · S/N U20606040Cancelled Jun 19, 2009 · Exported to Bolivia · Built 1981 · Ramallo Rita V N6576UCessna U206G · S/N U20605498Cancelled Apr 29, 2009 · Exported to Bolivia · Built 1979 · Morales Robert Carlos N4152GRobinson Helicopter R44 II · S/N 12108Cancelled May 22, 2008 · Exported to France · Built 2008 · Sky Helicopters Inc N4070YBalloon Works FIREFLY 7 · S/N 10059Cancelled Dec 16, 2000 · Triennial form not returned · Built 1980 · Hines Donald A N115REPitcock Dan J ROTEC RALLY 3A · S/N 25129Cancelled Aug 31, 2000 · Triennial form not returned · Gibbons Dennis R N42JRRoddie Jackson MINI-500 · S/N 0259Cancelled Jan 8, 2000 · Roddie Jackson N62603Babb William T HI-MAX 1700R · S/N 1Cancelled May 19, 1999 · Triennial form not returned · Babb William T

Back to Garland, TX