Skip to content

Cancelled registrations · 135

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

N220AAIsrael Aerospace Ind GULFSTREAM 200 · S/N 220Cancelled Oct 21, 2024 · Exported to Colombia · Built 2009 · Skyline Aviation Services LLC N511JDTextron 208B · S/N 208B5646Cancelled May 31, 2024 · Exported to Panama · Built 2021 · Green Mountain View LLC N6847WPiper PA-28-140 · S/N 28-20992Cancelled Mar 23, 2024 · Sale reported, canceled N78604Cessna 172K · S/N 17257683Cancelled Feb 17, 2024 · Sale reported, canceled · Built 1968 N502NKAirbus A319-132 · S/N 2433Cancelled Apr 21, 2023 · Built 2005 · Spirit Airlines Inc N533NKAirbus A319-132 · S/N 3393Cancelled Apr 21, 2023 · Built 2008 · Spirit Airlines Inc N86425Boeing 727-212 · S/N 21459Cancelled Jan 23, 2023 · Exported to Kenya · Jr Aviation Services LLC N598FMDJI INSPIRE 1 PRO · S/N W21ACL04020350Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Jessuron Max N17RRase R-1 · S/N 1Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1958 · Gonzales Miguel A N8816YPiper PA-30 · S/N 301974Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1969 · Barraza Saddy N2213PPiper PA-28-161 · S/N 28-7916275Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Rolle Amos N2218VCessna 140 · S/N 14449Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1948 · Szot Robert N9839VCessna 172M · S/N 17264525Cancelled May 31, 2022 · Registration pending, canceled N690GCBeech 58 · S/N TH-1163Cancelled May 9, 2022 · Registration expired, pending cancellation · N947pw LLC N17JECessna 401A · S/N 401A0082Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Solo Energy Drink Inc N2932YPiper PA-28-161 · S/N 28-7916548Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Sands Tamal C N841JKDJI MAVIC PRO · S/N 08QUE8Q10101T0Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Phoenix View Pro LLC N714KGBeech 300 · S/N FA158Cancelled Jun 23, 2021 · Exported to Colombia · Built 1988 · Skyline Enterprises Corp N842DSBeech A100 · S/N B-244Cancelled Mar 3, 2021 · Exported to Bahamas · Built 1979 · Ch Aircraft Group Corp N55223Piper PA-34-200 · S/N 34-7350188Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1973 · Eastern Air Express Inc N723DBeech C35 · S/N D-2832Cancelled Jan 30, 2021 · Sale reported, canceled · Built 1951 N763AJBeech 400A · S/N RK-21Cancelled Dec 14, 2020 · Exported to Colombia · Skyline Enterprises Corp N66GTPiper PA-23-250 · S/N 27-4001Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Ryan Kenley E N37NWWay Norman R VANS RV-4 · S/N 2597Cancelled Feb 10, 2020 · Exported to Bolivia N1362GCessna 310R · S/N 310R0717Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1976 · Villanueva Juan G N608AFDJI PHANTOM 2 VISION + · S/N PH645494984Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Aerifocus LLC N51FEBeech 1900D · S/N UE-50Cancelled Mar 6, 2019 · Exported to Colombia · Skyline Enterprises Corp N770MCCessna 172N · S/N 17269598Cancelled Sep 18, 2018 · Exported to Peru · Built 1977 · Cruise Mario N6877BCessna T210M · S/N 21062849Cancelled Jul 9, 2018 · Exported to Guatemala · Dubon Dubon Ericka M N766VABoeing 767-2Q8 · S/N 24448Cancelled May 31, 2018 · Sale reported, canceled · Built 1989 N171LFAirbus A340-642 · S/N 453Cancelled May 30, 2018 · Sale reported, canceled N272WAMcdonnell Douglas MD-11 · S/N 48437Cancelled May 30, 2018 · Sale reported, canceled · Built 1992 N371LFAirbus A340-642 · S/N 475Cancelled May 30, 2018 · Sale reported, canceled N228EAHawker Siddeley BH.125-400A · S/N NA754Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Espiova Air LLC N947PWBeech E-55 · S/N TE-947Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1973 · N947pw LLC N72972Cessna 140 · S/N 10173Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1946 · Leiva Samuel N751TBeech 65 · S/N LC-223Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1966 · International Albatros Corp N6430RPiper PA-28-140 · S/N 28-21610Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1966 · Servalis Josue N826QBeech 65 · S/N LC-59Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1960 · Milburn William R N920PJMcdonnell Douglas DC-9-51 · S/N 47677Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1975 · Avteam Inc N258JMCessna 411A · S/N 4110258Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1967 · Seajay Airways Inc N170SACessna 402A · S/N 402A0043Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1969 · Island Wings Inc N473CQAero-Ace CE 1 · S/N PARD-1Cancelled Nov 3, 2017 · Built 1985 · Gonzalez Miguel A N662DADratbe Shmiel Amir CLASSIC EDGE X · S/N 582-563Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 2008 · Mijares John A N928MLMcdonnell Douglas DC-9-31 · S/N 47326Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1969 · Homfeld II LLC N68034Hiller UH-12D · S/N 1420Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1962 · Rodriguez Michael N954BGBeech B35 · S/N D-2616Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1950 · Gross George A N346LCSlater Charles R LANCAIR IV-P · S/N LIV-346Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 2000 · Echeverri Alexander N817NKMcdonnell Douglas DC-9-82(MD-82) · S/N 49141Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1983 · Spirit Airlines Inc N64589Bell-Transworld Helicopter Cor 47G-2 · S/N TWH-11Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1977 · Rodriguez Michael

Back to Miramar, FL