OpenAirDocs.org
Homestead, FL

Cancelled registrations · 204

Query with SQL
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 = 'HOMESTEAD'
  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.

N8336BCessna 172 · S/N 36136Cancelled May 17, 2006 · Triennial form not returned · Built 1957 · Poteet Kenneth WN82435Dryer David B FISHER 404 · S/N DBD 404-01Cancelled Oct 8, 2003 · Triennial form not returned · Built 1998 · Dryer David BN3754SCessna 172E · S/N 17250954Cancelled Apr 2, 2003 · Exported to Paraguay · Built 1963 · Kenneth Poteet Flying Service IncN8748UCessna 172F · S/N 17252652Cancelled Jan 9, 2003 · Exported to Nicaragua · Built 1965 · Del Rosario Luis FN308EDDearwent James E KIS TR-1C · S/N 69Cancelled Oct 30, 2002 · Triennial form not returned · Built 1996 · Dearwent James EN8214ZCessna 210-5(205) · S/N 205-0214Cancelled May 3, 2001 · Triennial form not returned · Uninsured 205 Lsg CorpN9405YBeech B95 · S/N TD-449Cancelled Apr 9, 2001 · Triennial form not returned · Dryer Richard VN44YDBeech 65-80 · S/N LD23Cancelled Jul 11, 1998 · Triennial form not returned · Roberts Air South IncN3265NBritten-Norman BN-2A-3 · S/N C504Cancelled Apr 7, 1998 · Exported to Australia · International Aviation CorpN55WEPiper PA-31-350 · S/N 317405163Cancelled Oct 23, 1997 · Triennial form not returned · Key Largo Air Service IncN30373Cessna 172M · S/N 17264137Cancelled Sep 5, 1997 · Exported to Poland · Wyatt Aviation Services IncN25PRBlaha Roy C VELOCITY · S/N DM0045Cancelled Jun 19, 1997 · Triennial form not returned · Blaha Roy CN211JRCessna 340 · S/N 3400552Cancelled Dec 4, 1996 · Triennial form not returned · Richard S Bach Dds PaN9985VCessna 172M · S/N 17264603Cancelled Nov 15, 1996 · Triennial form not returned · Built 1974 · Wyatt Aviation Services IncN288ATBoeing 727-51 · S/N 18943Cancelled Sep 3, 1996 · Exported to Peru · Sunrise Partners IncN39588Piper PA-32RT-300T · S/N 32R7887112Cancelled Oct 10, 1995 · Triennial form not returned · Houston Traville SN2803RPiper PA-28R-200 · S/N 28R35291Cancelled Oct 4, 1995 · Triennial form not returned · Ledford William PN1457LBeech A23 · S/N M843Cancelled Oct 3, 1995 · Triennial form not returned · Bojac Aviation Club IncN5144DCessna 172N · S/N 17272434Cancelled Oct 2, 1995 · Triennial form not returned · Wyatt Aviation Services IncN32940Piper PA-28-140 · S/N 287525130Cancelled Jul 27, 1995 · Triennial form not returned · Houlihan Stephen D DBAN1034DAlameda Jay C SCORPION 133 · S/N 10775Cancelled Jul 17, 1995 · Wolcott Dennis LN286ATBoeing 727-22 · S/N 19153Cancelled Nov 21, 1994 · Exported to Peru · Sunrise Partners IncN289ATBoeing 727-51 · S/N 18942Cancelled Nov 18, 1994 · Exported to Peru · Sunrise Partners IncN9321MMooney M20F · S/N 670252Cancelled Jun 21, 1994 · Triennial form not returned · Harris James MN7785PPiper PA-24-250 · S/N 243002Cancelled Apr 25, 1994 · Triennial form not returned · Loggins Diana GN3489UCessna 182F · S/N 18254889Cancelled Apr 5, 1994 · Hamker Leonard HN202BLPiper PA-23-250 · S/N 277405237Cancelled Feb 23, 1994 · Bill'S Aircraft Service IncN8024MCessna 310I · S/N 310I0024Cancelled Oct 26, 1993 · Triennial form not returned · Teft IncN8049FCessna 150F · S/N 15064149Cancelled May 13, 1993 · Triennial form not returned · Schoppaul WillyN2100QCessna 177RG · S/N 177RG0500Cancelled Jan 14, 1993 · Triennial form not returned · Wyatt Walter W SrN7206PPiper PA-24-250 · S/N 242376Cancelled Dec 1, 1992 · Triennial form not returned · Mcmillan Robert T JrN9667NDofka Martin F III KR-2 · S/N 1MD1Cancelled Oct 26, 1992 · Lee Eugene DN3673WPiper PA-32-260 · S/N 32582Cancelled May 23, 1991 · Exported to Netherlands · Ledford William PN47866Piper PA-28-181 · S/N 287890146Cancelled May 13, 1991 · Exported to United Kingdom · Harden John EN56630Piper PA-32-260 · S/N 327400002Cancelled Mar 12, 1991 · Exported to Belgium · Harris Roland HN1159Neubauer Richard L PITTS SPECIAL S1C · S/N RN-1Cancelled May 10, 1989 · Exported to United Kingdom · Built 1970 · Neubauer Richard LN73180Cessna T207A · S/N 20700567Cancelled Aug 14, 1984 · Bateman Stanley RN440JMConvair 440 · S/N 434Cancelled Feb 3, 1984 · Built 1957 · Yac Aircraft IncN303EHDehavilland DHC-6-300 · S/N 419Cancelled Sep 11, 1982 · Exported to Colombia · Hawk Aviation CorpN445JMConvair 440 · S/N 421Cancelled Jul 1, 1982 · Exported to Bolivia · Built 1957 · Yac AircraftN49CCFairchild F-27 · S/N 59Cancelled Jun 21, 1982 · Exported to Mexico · Hawk Aviation CorpN76663Cessna 140 · S/N 11103Cancelled Mar 3, 1982 · Hutchins Richard AN63402Boeing N2S-3 · S/N 75-7972Cancelled Feb 18, 1982 · Exported to Canada · Holleys Dusting Service IncN5331NCessna 182Q · S/N 18267650Cancelled Jan 30, 1981 · Exported to Belize · Interflite CorpN443JMConvair 440 · S/N 417Cancelled Dec 18, 1980 · Sale reported · Built 1957N46917Piper J3C-65 · S/N G-105Cancelled Oct 17, 1980 · Sherry Wayne MN455Lake LA-4 · S/N 430Cancelled Jul 7, 1977 · Administratively canceled · U S Department Of InteriorN7059QCessna 172L · S/N 17260359Cancelled Aug 6, 1975 · Durie Jack F JrN4547YPiper PA-25-235 · S/N 25-4198Cancelled May 9, 1975 · Exported to Trinidad and Tobago · Built 1967 · Farm Air Service IncN6731ZPiper PA-25-235 · S/N 25-2202Cancelled May 8, 1975 · Exported to Trinidad and Tobago · Huribut William
Back to Homestead, FL