Skip to content

Earlier aircraft under this name · 35

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'MELEX USA INC' OR list_contains(d.other_registrant_names, 'MELEX USA INC') 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_name = 'MELEX USA INC' OR list_contains(d.other_registrant_names, 'MELEX USA INC')
  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_name = 'MELEX USA INC' OR list_contains(d.other_registrant_names, 'MELEX USA INC')
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.

N4117VWSK PZL Mielec M-18A · S/N 1Z025-04Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1994 · Raleigh, NC N8042AWsk-Pzl-Mielec PZL-M-18 · S/N 1Z001-02Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1979 · Raleigh, NC N4433SAir Tractor AT-301 · S/N 301-0093Cancelled Feb 29, 2012 · Third renewal notice · Built 1977 · Raleigh, NC N4117QWSK PZL Mielec M-18A · S/N 1Z025-03Cancelled Sep 30, 1999 · Exported to Brazil · Raleigh, NC N2855RWsk-Pzl-Mielec PZL-M-18 · S/N 1Z008-08Cancelled Aug 20, 1999 · Exported to Trinidad and Tobago · Raleigh, NC N119MCWsk-Pzl Meilec PZL M18B · S/N 1Z027-10Cancelled Jun 4, 1999 · Exported to Canada · Smithfield, NC N60159Wsk-Pzl Meilec PZL M18B · S/N 1Z027-30Cancelled Apr 1, 1999 · Exported to Canada · Smithfield, NC N44376Wsk-Pzl Meilec PZL M18B · S/N 1Z02722Cancelled Jun 29, 1998 · Exported to Canada · Smithfield, NC N4676CWsk-Pzl-Mielec PZL-M-18 · S/N 1Z01207Cancelled Mar 6, 1998 · Exported to Chile · Raleigh, NC N9132XWsk-Pzl Meilec PZL M18B · S/N 1Z02629Cancelled Sep 9, 1997 · Exported to New Zealand · Smithfield, NC N62610WSK PZL Mielec M-18A · S/N 1Z02609Cancelled Sep 3, 1996 · Exported to Australia · Smithfield, NC N7080LWSK Mielec PZL M-26 · S/N 1APP01-02Cancelled Jul 23, 1996 · Raleigh, NC N8021HWSK PZL Mielec M-18A · S/N 1Z02506Cancelled Jul 10, 1996 · Exported to Canada · Smithfield, NC N81458WSK PZL Mielec M-18A · S/N 1Z02526Cancelled Jan 10, 1996 · Exported to Spain · Smithfield, NC N8211PWSK PZL Mielec M-18A · S/N 1Z02520Cancelled Jan 3, 1996 · Exported to Australia · Smithfield, NC N9279MWSK PZL Mielec M-18A · S/N 1Z02524Cancelled Nov 17, 1995 · Exported to Australia · Smithfield, NC N49896WSK PZL Mielec M-18A · S/N 1Z02427Cancelled Nov 15, 1994 · Exported to Brazil · Raleigh, NC N75906WSK PZL Mielec M-18A · S/N 1Z02426Cancelled Sep 23, 1994 · Exported to Australia · Raleigh, NC N2087MWSK PZL Mielec M-18A · S/N 1Z02304Cancelled May 26, 1994 · Exported to Brazil · Raleigh, NC N6236BWSK PZL Mielec M-18A · S/N 1Z02309Cancelled May 7, 1993 · Exported to Canada · Raleigh, NC N2253QWSK PZL Mielec M-18A · S/N 1Z02101Cancelled Jun 15, 1992 · Exported to Costa Rica · Raleigh, NC N2252NWSK PZL Mielec M-18A · S/N 1Z02030Cancelled Feb 21, 1992 · Exported to Costa Rica · Raleigh, NC N2173XWSK PZL Mielec M-18A · S/N 1Z02025Cancelled Aug 12, 1991 · Exported to Mexico · Raleigh, NC N21773WSK PZL Mielec M-18A · S/N 1Z02007Cancelled Apr 4, 1991 · Exported to Mexico · Raleigh, NC N2178QWSK PZL Mielec M-18A · S/N 1Z02027Cancelled Mar 7, 1991 · Exported to Spain · Raleigh, NC N2178FWSK PZL Mielec M-18A · S/N 1Z02008Cancelled Feb 26, 1991 · Exported to Spain · Raleigh, NC N70456Wsk-Pzl-Mielec PZL-M-18 · S/N 1Z019-10Cancelled Feb 7, 1991 · Exported to Brazil · Raleigh, NC N8085NWSK PZL Mielec M-18A · S/N 1Z01919Cancelled Oct 12, 1990 · Exported to Brazil · Raleigh, NC N2260KPezetel PZL-106 BS · S/N 10890238Cancelled Feb 22, 1990 · Exported to Poland · Raleigh, NC N8085TWSK PZL Mielec M-18A · S/N 1Z019-20Cancelled Jan 10, 1990 · Exported to Spain · Raleigh, NC N7015JWSK PZL Mielec M-18 DROMADER · S/N 1Z01819Cancelled Nov 29, 1988 · Exported to Venezuela · Raleigh, NC N7015NWSK PZL Mielec M-18 DROMADER · S/N 1Z018-21Cancelled Nov 18, 1988 · Exported to Venezuela · Raleigh, NC N164ASP Z L -Warszawa-Cnpsl PZL-104 WILGA 35A · S/N 96317Cancelled Jun 15, 1983 · Administratively canceled · Raleigh, NC N2620RWSK PZL Mielec M-18 DROMADER · S/N 1Z007-08Cancelled Feb 19, 1982 · Exported to Venezuela · Raleigh, NC N51946Wsk-Swidnik MI-2 · S/N 525150047Cancelled Mar 3, 1981 · Exported to Canada · Raleigh, NC

Back to Melex USA Inc