Skip to content

Cancelled registrations · 40

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 = 'NY' AND d.registrant_city = 'BRONX' 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 = 'NY' AND d.registrant_city = 'BRONX'
  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 = 'NY' AND d.registrant_city = 'BRONX'
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.

N3042QYakovlev YAK-55M · S/N 920409Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Yana Brink N22327Aeronca 50-C · S/N C3299Cancelled Feb 28, 2020 · Revoked, canceled · Built 1939 · Roth Milton N8798PPiper PA-24-260 · S/N 24-4251Cancelled Sep 6, 2019 · Revoked, canceled · Built 1965 · Eriksen Robert N7154RPiper PA-28-140 · S/N 28-21861Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1966 · Johnson Janice K N4392EAeronca 7DC · S/N 7DC-47Cancelled Apr 17, 2019 · Registration expired, pending cancellation · Built 1948 · Johnson Janice K N7060CPiper PA-34-200T · S/N 34-7670084Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1975 · Urena Daisy Nis N664NZ3D Robotics SOLO · S/N S111A5501940Cancelled Feb 5, 2018 · Sale reported, pending cancellation N47229Fairchild M-62A · S/N T435507Cancelled Nov 18, 2017 · Revoked, canceled · Built 1943 · Gerardi Angela N19010Cessna 150L · S/N 15074089Cancelled Oct 28, 2017 · Revoked, canceled · Built 1972 · April Stephanie Pastor N40868Piper PA-28-140 · S/N 28-7425181Cancelled Jul 9, 2014 · Exported to Philippines · Built 1973 · Gorospe Glenn N457TMBoeing 737-214 · S/N 20156Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1969 · Transamerican Inc N78MFMartin Beresford HA-2M SPORTSTER · S/N BSF-73Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1980 · Martin Beresford G N523AABeech 60 · S/N P-31Cancelled Sep 19, 2013 · Sale reported, canceled · Built 1968 N6264KRepublic RC-3 · S/N 474Cancelled Aug 5, 2013 · Revoked, canceled · Built 1947 · Mccormack Owen J Jr N4709QCessna 170A · S/N 20018Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1951 · Folchi Arthur N11TNBeech B90 · S/N LJ-419Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1968 · M&C Aviation Inc N4921TCessna 411 · S/N 411-0121Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1965 · Vazquez Avan N61381Cessna T-50 · S/N 6159Cancelled Aug 30, 2012 · Revoked, canceled · Built 1943 · Christensen Maurice N9932MEmroth-Emair MA-1B · S/N 032Cancelled May 3, 2011 · Registration pending, pending cancellation · Built 1977 N34473Aeronca 65-CA · S/N CA15101Cancelled Dec 16, 2010 · Revoked, pending cancellation · Built 1941 · Luciano Alfred P N5282ZCessna 182P · S/N 18262747Cancelled Jan 31, 2002 · Exported to Tanzania · 182 Flight Corp N3221QCessna 401 · S/N 4010021Cancelled Dec 10, 1997 · Exported to Dominican Republic · Milagros Felix N2617ABeech V35A · S/N D-9053Cancelled Jan 10, 1984 · Administratively canceled · T C A Aviation Corp N72180Cessna 337G · S/N 33701536Cancelled Mar 3, 1982 · Exported to Gambia · Brown Louis Jr N77958Luscombe 8F · S/N 3685Cancelled Apr 8, 1974 · Aquaflights Inc N55658Piper J5A · S/N 5-1414Cancelled Jul 14, 1971 · Zeidler Donald W/ Casey George E N9167HFairchild M-62 · S/N FW921Cancelled Feb 24, 1971 · Hoyer George R N30824Piper J3C-65S · S/N 5128Cancelled Nov 9, 1959 · Exported to Canada · Built 1940 · Hueber Charles Schellhorn Edward N4168HPiper PA-15 · S/N 15-50Cancelled Apr 22, 1958 · Exported to Germany · Giebelhaus Charles N18815Aeronca K · S/N K-82Cancelled Feb 20, 1956 · Built 1937 · Mack Louis N36942Aeronca 65-TAC · S/N C2491TACancelled Feb 20, 1956 · Leitz Kenneth R N87590Republic RC-3 · S/N 159Cancelled Sep 14, 1955 · Exported to Canada · Starza Roland La N1062KLuscombe 8A · S/N 3789Cancelled Nov 24, 1954 · Surburban Air Service Inc N8806HNorth American NAVION · S/N NAV-4-806Cancelled Dec 14, 1950 · Tri Boro Elevator Co N92019Piper J3C-65 · S/N 16452Cancelled Oct 27, 1949 · Terminello Ernest V N16280Aeronca LB · S/N 2025Cancelled Sep 28, 1941 · Weiland Francis John N564NCurtiss Wright ROBIN 4C-1A · S/N 714Cancelled Dec 18, 1940 · Herfurtner John N71KHeath HEATH PARASOL · S/N A-1-BCancelled Feb 9, 1933 · Built 1930 · Pageau Charles Henry N3112Curtiss JN4C · S/N 3112Cancelled May 19, 1928 · Mark Brann N745Curtiss JN4D · S/N M4017Cancellation date not recorded · Blossner Ben

Back to Bronx, NY