Skip to content

Lake Placid, FL

Cancelled registrations · 80

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 = 'LAKE PLACID' 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 = 'LAKE PLACID'
  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 = 'LAKE PLACID'
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.

N490ALAeroprakt Mfg SP Z O O A32 · S/N 323Cancelled Jan 8, 2026 · Registration pending, canceled · Built 2024 N9238VMooney M20E · S/N 690053Cancelled May 18, 2024 · Revoked, canceled · Marrs Joe G N8004LCessna 172H · S/N 17256204Cancelled May 13, 2023 · Revoked, canceled · Built 1967 · Marrs Joe G N80563Globe GC-1B · S/N 66Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1946 · Marrs John N6129WPiper PA-28-140 · S/N 28-20146Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1964 · Berstling Brandon R N74473Bellanca 14-13-2 · S/N 1586Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1948 · Berstling Brandyn R N7845ZCessna 150C · S/N 15059945Cancelled May 24, 2022 · Registration expired, pending cancellation · Built 1963 · Marrs John A N727EPElrod Michael N ZENITH STOL CH 701 · S/N 7-5310Cancelled Oct 13, 2021 · Exported to Canada · Built 2005 · Hangar Niner LLC N18907Beech B19 · S/N MB-860Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Built 1977 · Bollman Terence R N126XCessna 310 · S/N 35021Cancelled Aug 23, 2018 · Revoked, canceled · Built 1955 · Marrs Joe G N1669RPerry William H STRATON D7 · S/N 007Cancelled Jun 26, 2018 · Registration pending, canceled N434SXAdvanced BUCCANEER-SX · S/N BIB500582Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1988 N187KBPowrachute AIRWOLF · S/N A069ULSCancelled May 30, 2018 · Sale reported, canceled · Built 2006 N5007JHughes TH-55A · S/N 66-18266Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Brainerd Philip S N9224BCessna 175 · S/N 55024Cancelled Mar 23, 2018 · Revoked, canceled · Built 1958 · Marrs Joe G N4832HPiper PA-17 · S/N 17-130Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1948 · Welden Andrew M N324SSieckmann C H RAF 2000 GTX SE · S/N 324Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1998 · Paxton John P N11JHipp EAA BIPLANE · S/N CAAC1Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1975 · Marrs John N9253JPiper PA-28-180 · S/N 28-3328Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1966 · Marrs John A N3506JCessna 150E · S/N 15061206Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1965 · Brown Randolph E N9423RSnow S2A · S/N 1053ACancelled Feb 13, 2017 · Revoked, canceled · Built 1960 · Marrs Joe G N7611MCessna 175 · S/N 55911Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Marrs John A N76159Cessna 140 · S/N 10556Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Marrs Joe G N95060Piper PA-28-140 · S/N 28-25792Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1969 · Marrs John N9013JPiper PA-28-180 · S/N 28-3039Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1966 · Marrs John A N29354Cessna 177 · S/N 17700835Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1968 · Marrs Joe G N2633XCessna P206 · S/N P206-0133Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1965 · Marrs Joe G N5425VPiper PA-18 · S/N 18-877Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1960 N4904ACessna 180 · S/N 32301Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1956 · Smith Lucious D Jr N2038AGrumman G-21A · S/N 1167Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1943 · Marrs Joe G N2050MPiper J3C-65 · S/N 20822Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1946 · Smith Lucious D Jr N6146UBeech C-45F · S/N 43-35754ACancelled Aug 5, 2013 · Revoked, canceled · Built 1943 · Marrs Joe G N69LBellanca 14-13-3 · S/N 1631Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1949 · Snavely W R N909QBeech 65-80 · S/N LD-100Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1963 · Karma Inc N44816Harvey Mitchell B CONDOR III + 2 · S/N 83-140-3-2Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Lake Placid Ultralights Inc N2750RStinson 108-2 · S/N 108-3290Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Heinley George J N9134UCessna 150M · S/N 15078085Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1976 · Dbelisk Inc N9388PPiper PA-24-260 · S/N 24-4889Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1969 · Marrs Joe G N7484YPiper PA-30 · S/N 30-545Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1964 · Russell Charles N6794Vertol H21B · S/N 53-4329Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1953 · Marrs Joe G N5700HPiper PA-16 · S/N 16-311Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1949 · Marrs Joe G N204Camair 480 · S/N 1052Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1947 · Marrs Joe G DBA N11020Champion 7ECA · S/N 3Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1964 · Marrs Joe G N7841FCessna 150F · S/N 15063941Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1966 N2759GCessna 182B · S/N 52059Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1959 · Marrs Joe G N45BGGranger VP-2 · S/N V2-1Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1975 · Guy John L N97357Stinson 108-2 · S/N 108-357Cancelled Nov 26, 2012 · Sale reported, pending cancellation · Built 1946 N4340VCessna 195 · S/N 7246Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1948 · Marrs Joe G N3808SCessna 172E · S/N 17251008Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1963 · Marrs Joe G N8309BCessna 172 · S/N 36109Cancelled Nov 13, 2012 · Sale reported, pending cancellation · Built 1957

Back to Lake Placid, FL