Skip to content

Cancelled registrations · 52

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 = 'FL' AND d.registrant_city = 'ODESSA' 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 = 'FL' AND d.registrant_city = 'ODESSA'
  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 = 'FL' AND d.registrant_city = 'ODESSA'
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.

N3363ZPiper PA-22-150 · S/N 22-7303Cancelled May 23, 2026 · Registration pending, canceled · Built 1960 N3525PPiper PA-22-150 · S/N 22-3280Cancelled Oct 4, 2025 · Registration pending, canceled · Built 1955 N343USCostruzioni Aeronautiche Tecna P2006T · S/N 343/USCancelled May 21, 2025 · Built 2021 · Dilo Equipment Leasing LLC N950KHughes 369HS · S/N 640610SCancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1974 · Pasco County Mosquito Control District N701RVCessna 172RG · S/N 172RG0477Cancelled Apr 20, 2022 · Exported to South Africa · Woe N701rv LLC N508TMCessna P210N · S/N P21000258Cancelled Dec 1, 2020 · Exported to Canada · Wings Of Eagles Aircraft Delivery LLC N926KBBrad J Bates MOSQUITO XE 285 · S/N MXE 1306A17BCancelled Aug 19, 2020 · Registration expired, pending cancellation · Built 2017 · Bates Brad J N4ULAerostar International RAVEN S49A · S/N S49A-3091Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Built 1991 · Kepley Kyle N500EWPiper PA-31T2 · S/N 31T-8166060Cancelled Nov 16, 2018 · Exported to South Africa · Built 1982 · Wings Of Eagles Aircraft Delivery LLC N922BAIcon A5 · S/N 00022Cancelled Mar 20, 2018 · Built 2017 · N529pg LLC N13192Cessna 172M · S/N 17262560Cancelled Mar 7, 2018 · Exported to Mexico · Built 1973 · Rooks Aviation LLC N8615ZCessna U206E · S/N U20601658Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1971 · Keystone Seaplane LLC N9426Beech B90 · S/N LJ-421Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1968 · Equinox Administration Inc N3TRSchweizer SGS 1-26D · S/N 408Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1968 · Behrens Paul L N186AQBoeing 737-322 · S/N 24666Cancelled Feb 15, 2017 · Third renewal notice · Phoenix Aer Capital LLC N185AQBoeing 737-322 · S/N 24532Cancelled Jan 24, 2017 · Third renewal notice · Phoenix Aer Capital LLC N456FBChallenger-Quad City Ultraligh CH2 · S/N CH2-1294-1259Cancelled May 21, 2015 · Sale reported, canceled · Built 1994 N4508CCameron Balloons US O-90 · S/N 5905Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1993 · Kepley Franklin K N4569DBeech G35 · S/N D-4750Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1956 · Myers William T N3822PCessna P210N · S/N P21000060Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1978 · Acosta-Rubio Ivan L N218DRCameron Balloons O-56 · S/N 808Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Gardner Dave J N6034VPiper PA-22 · S/N 22-384Cancelled May 10, 2013 · Sale reported, canceled · Built 1952 N5406MCessna 152 · S/N 15284582Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1980 · Ed Silvernell & Sons Inc N9518KHughes TH-55 · S/N 66-18272Cancelled Mar 26, 2013 · Sale reported, canceled N5945LAmerican AA-1 · S/N AA1-0245Cancelled Feb 26, 2013 · Revoked, canceled · Built 1969 · Holsinger Richard C Jr N4137QCessna 310N · S/N 310N-0037Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1967 · Madden Timothy J N129BDEvolution Trikes REVO · S/N 000562Cancelled Nov 2, 2012 · Exported to China · Built 2010 · Mednick Larry S N337ACCessna 337B · S/N 337-0721Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1967 · Holsinger Richard C Jr N238HBeech S35 · S/N D-7925Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1965 · M & H Aircraft Inc N2357Reed-Thorp T-18 · S/N 106Cancelled Aug 27, 2012 · Registration pending, canceled · Built 1969 N194CFCessna 210E · S/N 21058560Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1964 · White Francis E N2116BCessna T206H · S/N T20608449Cancelled May 1, 2012 · Exported to Guatemala · Ariel J Quintela LLC N2864UPiper PA-28RT-201T · S/N 28R-7931230Cancelled Jul 25, 2011 · Expired dealer · Built 1979 · Tri-Star Aviation N11EVMednick Larry S REVO · S/N 000550Cancelled Jul 28, 2010 · Built 2009 · Mednick Larry S N139JPCessna 210N · S/N 21063810Cancelled Dec 20, 2002 · Triennial form not returned · Built 1980 · Browne J Danforth N64795Cessna 172P · S/N 17275626Cancelled Mar 13, 2002 · Exported to Canada · Built 1982 · Palmer Charles Jr N6786MHughes TH-55A · S/N 68-16786Cancelled Mar 5, 2001 · Triennial form not returned · Pasco County Mosquito Control Dist N67597Cessna 152 · S/N 15281938Cancelled Jul 17, 1997 · Triennial form not returned · Seven Eagles Inc N6613LCessna 152 · S/N 15284465Cancelled Sep 12, 1995 · Triennial form not returned · Seven Eagles Inc N34JPBeech A23-24 · S/N MA54Cancelled Nov 4, 1994 · Second triennial mailing, no response · Busciglio Johnny N28741Piper PA-34-200T · S/N 348070061Cancelled Jun 15, 1993 · Exported to Venezuela · Seven Eagles Inc DBA N6879NMooney M20C · S/N 680154Cancelled Jun 7, 1993 · Triennial form not returned · Seven Eagles Inc N2169DPiper PA-34-200T · S/N 347970028Cancelled Oct 2, 1991 · Exported to Germany · Aircraft Mountain II Corporation N8079VPiper PA-34-200T · S/N 347970490Cancelled Aug 28, 1991 · Exported to Germany · Aircraft Mountain II Corp N20331Cessna A150M · S/N A1500719Cancelled Jan 9, 1991 · Exported to United Kingdom · Seven Eagles Inc N75SVCessna 210N · S/N 21063135Cancelled Oct 22, 1984 · Ed Silvernell & Sons Inc N7360YCessna U206G · S/N U20605532Cancelled Feb 9, 1981 · Exported to Bolivia · Ed Silvernell & Sons Inc N6536CCessna T210N · S/N T210-63911Cancelled Jun 11, 1980 · Exported to Mexico · Ed Silvernail & Sons Inc N97974Cessna 182Q · S/N 18267261Cancelled Apr 21, 1980 · Exported to Venezuela · Ed Silvernell & Sons Inc N73184Cessna 172M · S/N 172-67311Cancelled Jan 10, 1980 · Exported to Canada · Ed Silvernell & Sons Inc

Back to Odessa, FL