Skip to content

Cancelled registrations · 35

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

N85047Eagle Balloons C-7 · S/N E876102Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Baumgarten Michael N111WJPiper PA-31-325 · S/N 31-7812005Cancelled May 13, 2015 · Registration expired, pending cancellation · Dart Air Inc N30457Cessna 177A · S/N 17701266Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1968 · Hatschek Laszlo N6241VBeech 56TC · S/N TG-44Cancelled Aug 5, 2013 · Revoked, canceled · Built 1967 · Whipple Bret D N72242Cessna 337G · S/N 33701546Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1973 · Sealife Displays Inc N2478HBalloon Works FIREFLY 7 · S/N 7706Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1978 N5960GCessna 150K · S/N 15071460Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1969 · Strange George Harold N4985PPiper PA-23-235 · S/N 27-589Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1964 · Anthonique Reg Jones Inc N92998Rearwin 185 · S/N 1732Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1946 N59684Piper PA-36-300 · S/N 36-7760098Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1977 N53MMBeech 95-B55 (T42A) · S/N TC-1487Cancelled Sep 18, 2012 · Revoked, canceled · Built 1972 · Steinke Kathleen Ann N5534UCessna TU206G · S/N U20605315Cancelled Jun 14, 2012 · Registration pending, canceled · Built 1979 N1161QCessna U206F · S/N U20602851Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Built 1975 · Beek Nigel N3211TCessna 177 · S/N 17700511Cancelled Mar 12, 2012 · Sale reported, pending cancellation · Built 1967 N3897KPiper PA-28-140 · S/N 28-23771Cancelled Jul 25, 2011 · Revoked, canceled · Built 1967 · Strange George Harold N973TCCessna 402C · S/N 402C0003Cancelled Dec 10, 2010 · Built 1978 · Talya Air Cargo Inc N9255VMooney M20F · S/N 690070Cancelled Sep 15, 2009 · Registration revoked · Built 1969 · Steinke Kathleen A N61264Cessna 150J · S/N 15070928Cancelled Nov 19, 2008 · Triennial form not returned · Built 1969 · Cecil James E N9216UCessna 150M · S/N 15078166Cancelled Dec 12, 2007 · Built 1976 · Throttle Aviation Inc N9511PPiper PA-25-235 · S/N 25-7405598Cancelled Sep 23, 2003 · Exported to Brazil · Built 1974 · Planeta Brasilis Corp N82313Piper PA-25-235 · S/N 25-7656074Cancelled Aug 27, 2003 · Exported to Brazil · Built 1976 · Planeta Brasilis Corp N339SCessna 340A · S/N 340A0712Cancelled Oct 2, 2002 · Triennial form not returned · Built 1979 · Bercu Harold S N203CBNorth American T-28A · S/N 485Cancelled Sep 13, 2002 · Second triennial mailing, no response · Built 1951 · Byrd Charles L N8561LPiper PA-25-260 · S/N 25-4983Cancelled Jan 29, 2002 · Exported to Brazil · Planeta Brasilis Corp N8603LPiper PA-25-235 · S/N 25-5028Cancelled Jan 28, 2002 · Exported to Brazil · Planeta Brasilis N5479QCessna 150L · S/N 15073379Cancelled Dec 6, 2000 · Harari David N46JKBeech 200 · S/N BB45Cancelled May 19, 1994 · Exported to Brazil · Aviation Of Lauderhill N794KBeech C90 · S/N LJ535Cancelled Feb 10, 1994 · Exported to Brazil · Aviation Of Lauderhill N929RWCessna 500 · S/N 5000046Cancelled Apr 15, 1993 · Exported to Brazil · Avjet Trading Inc N4824RCessna A188B · S/N 18802343Cancelled Mar 2, 1992 · Exported to Hungary N2FACessna 310R · S/N 310R1551Cancelled Feb 28, 1992 · Exported to Brazil · Avjet Trading Inc N5658TMaule MX-7-180 · S/N 11017CCancelled Feb 18, 1992 · Exported to Austria N927TKCessna 210M · S/N 21062301Cancelled Nov 12, 1991 · Exported to Brazil · Avjet Trading Inc N3158MCessna 310R · S/N 310R1862Cancelled Mar 12, 1991 · Exported to Brazil · Avjet Trading Inc N70132Beech F90 · S/N LA-195Cancelled May 24, 1989 · Exported to Brazil · Air Trading Inc

Back to Lauderhill, FL