Skip to content

Earlier aircraft under this name · 40

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 = 'MASIN JOSEPH V' OR list_contains(d.other_registrant_names, 'MASIN JOSEPH V') 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 = 'MASIN JOSEPH V' OR list_contains(d.other_registrant_names, 'MASIN JOSEPH V')
  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 = 'MASIN JOSEPH V' OR list_contains(d.other_registrant_names, 'MASIN JOSEPH V')
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.

N90569Dehavilland CARIBOU DHC-4 · S/N 48Cancelled Jan 15, 1982 · Exported to India N90570Dehavilland CARIBOU DHC-4 · S/N 56Cancelled Jan 15, 1982 · Exported to Switzerland · Rodenkirchen N87805Douglas C-47 · S/N 4477226ACancelled Sep 8, 1977 · Exported to Spain · Built 1975 · Rodenkirchen N90573Dehavilland CARIBOU DHC-4 · S/N 83Cancelled Aug 15, 1977 · Exported to India · Rodenkirchen N62443Douglas C-47 · S/N 42-100997Cancelled May 26, 1976 · Rodenkirchen N61904Beech 18D · S/N 44629Cancelled May 8, 1975 · Rodenkirchen N61906Beech 18D · S/N 90558Cancelled May 8, 1975 · Rodenkirchen N61907Beech 18D · S/N 66454Cancelled May 8, 1975 · Rodenkirchen N61908Beech 18D · S/N 44638Cancelled May 8, 1975 · Rodenkirchen N61910Beech 18D · S/N 66415Cancelled May 8, 1975 · Rodenkirchen N88927Junkers JU-52 · S/N 144Cancelled May 6, 1975 · Exported to Germany · 5038 Rodenkirchen N67082Douglas C-47D · S/N 44-77097Cancelled Mar 12, 1975 · Exported to Ethiopia · Rodenkirchen N90905Douglas C-47 · S/N 76692Cancelled Jan 14, 1975 · Exported to South Africa N93441Dehavilland DHC-3 · S/N 189Cancelled Jun 19, 1974 · Exported to Canada N93433Dehavilland DHC-2 · S/N 1126Cancelled Apr 24, 1974 · Exported to Canada · Rodenkirchen N93434Dehavilland DHC-2 · S/N 1683Cancelled Apr 2, 1974 · Exported to Canada N93440Dehavilland DHC-2 · S/N 1711Cancelled Jan 16, 1974 · Exported to Norway N61909Beech D18S · S/N 44676Cancelled Oct 8, 1973 · Exported to France N61905Beech D18S · S/N 85099Cancelled Sep 5, 1973 N31705Hiller UH-12E · S/N 2176Cancelled Aug 9, 1973 · Exported to United Kingdom · Rodenkirchen N31707Hiller UH-12E · S/N 2178Cancelled Aug 9, 1973 · Exported to United Kingdom · Rodenkirchen N31708Hiller UH-12E · S/N 2181Cancelled Aug 9, 1973 · Exported to United Kingdom · Rodenkirchen N73687North American T-6 · S/N 53-4631Cancelled Jul 9, 1973 · Exported to France N73688North American T-6 · S/N 53-4618Cancelled Jul 9, 1973 · Exported to France N31701Hiller UH-12E · S/N 2157Cancelled Jun 26, 1973 · Exported to United Kingdom · Rodenkirchen N31706Hiller UH-12E · S/N 2177Cancelled Jun 26, 1973 · Exported to United Kingdom · Rodenkirchen N14081Piper PA-23-250 · S/N 27-4684Cancelled Jun 25, 1973 · Rodenkirchen N31703Hiller UH-12E · S/N 2165Cancelled Jun 12, 1973 · Exported to United Kingdom · Rodenkirchen N31704Hiller UH-12E · S/N 2175Cancelled Jun 12, 1973 · Exported to United Kingdom · Rodenkirdhen N4729Piper PA-18-150 · S/N 18-4912Cancelled May 20, 1971 · Exported to Italy · Rodenkirchen N5883Piper PA-18-150 · S/N 18-5334Cancelled May 20, 1971 · Exported to Germany · Rodenkirchen N5882Piper PA-18-150 · S/N 18-5326Cancelled May 5, 1971 · Exported to Germany · Rodenkirchen N5884Piper PA-18-150 · S/N 18-5364Cancelled May 5, 1971 · Exported to Germany · Rodenkirchen N2597JCessna 150E · S/N 15061097Cancelled Mar 20, 1968 · Exported to Germany · Jackson Heights, NY N3784SCessna 172E · S/N 17250984Cancelled Mar 20, 1968 · Exported to Germany · Jackson Heights, NY N5470RCessna 172F · S/N 17253030Cancelled Mar 20, 1968 · Exported to Germany N9226WPiper PA-28-235 · S/N 28-10894Cancelled Jul 13, 1967 · Exported to Belgium · Jackson Heights, NY N7582DPiper PA-18-150 · S/N 18-5878Cancelled Mar 31, 1967 · Exported to Germany · Jackson Heights, NY N3373ZPiper PA-18-150 · S/N 18-7246Cancelled Mar 9, 1967 · Exported to Germany · Jackson Heights, NY N14158Piper PA-23-250 · S/N 27-4724Cancellation date not recorded · Koln

Back to Masin Joseph V