Skip to content

Producing Se Inc

Earlier aircraft under this name · 23

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 = 'PRODUCING SE INC' OR list_contains(d.other_registrant_names, 'PRODUCING SE 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 = 'PRODUCING SE INC' OR list_contains(d.other_registrant_names, 'PRODUCING SE 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 = 'PRODUCING SE INC' OR list_contains(d.other_registrant_names, 'PRODUCING SE 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.

N1179CMiracle Robert D SONERAI II · S/N 135Cancelled Feb 20, 1985 · Administratively canceled · Miracle Robert D, Deforest, WI N2133LBell Helicopter Textron 206L-1 · S/N 45633Cancelled Feb 14, 1985 · Administratively canceled · Petroleum Helicopters Inc, Lafayette, LA N42RHHight Roger G SMARAGD · S/N 007Cancelled Jan 31, 1985 · Administratively canceled · Hight Roger G, Hudson, OH N15PTPiper Advanced Technology PAT-1 · S/N 1Cancelled Dec 11, 1984 · Administratively canceled · Piper Advanced Technology Inc, Wichita, KS N4267XMcdonald Hal W STITS SA6B · S/N 658MCancelled Dec 6, 1984 · Administratively canceled · Mcdonald Hal W, Kearns, UT N209DWWilson J Dale OSPREY-2 · S/N 05Cancelled Oct 26, 1984 · Administratively canceled · Wilson J Dale, Madison, WI N2623Bell Helicopter Textron 206L-1 · S/N 45641Cancelled Oct 26, 1984 · Administratively canceled · Mobil Oil Exploration And, New Orleans, LA N81RHHochgesang Robert A SONERAI-II · S/N 738Cancelled Oct 26, 1984 · Administratively canceled · Hochgesang Robert A, Medinah, IL N352QTBell 206A · S/N 65Cancelled Sep 6, 1984 · Administratively canceled · Hollico Svcs Inc, Houton, TX N122EFEFF Chris A VARIEZE · S/N 528Cancelled Jul 21, 1984 · Administratively canceled · Eff Chris A, Louisville, KY N2384VAir Tractor AT-301 · S/N 301-0436Cancelled Apr 6, 1984 · Administratively canceled · Ag Air Inc, Los Fresnos, TX N2816BGoodwin Peter H MITCHELL U-2 · S/N 221Cancelled Nov 29, 1983 · Administratively canceled · Goodwin Peter H, Kent, CT N98HJBell 205A-1 · S/N 30089Cancelled Nov 23, 1983 · Administratively canceled · Heli Trade Corporation, Eugene, OR N467FDassault/Sud FAN JET FALCON SER F · S/N 460Cancelled Nov 19, 1983 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N465FDassault-Breguet FALCON 20 · S/N 458Cancelled Oct 25, 1983 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N462FDassault-Breguet FALCON 20 · S/N 456Cancelled Aug 16, 1983 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N459FDassault-Breguet FALCON 20 · S/N 452Cancelled Aug 9, 1983 · Administratively canceled · Falcon Jet Corp, Teterboro, NJ N2088JBell 206B · S/N 3441Cancelled Jul 22, 1983 · Administratively canceled · Pumpkin Air Inc, Addison, TX N461FDassault-Breguet FALCON 20 · S/N 454Cancelled Jul 9, 1983 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N1038VCarlstrom Kenneth V HUMMER-A · S/N 0085ACancelled May 5, 1983 · Administratively canceled · Carlstrom Kenneth V, Nashua, NH N8249KPiper PA-28-161 · S/N 28-8216181Cancelled Apr 23, 1983 · Administratively canceled · Sunrise Aviation Enterprises Inc, Cincinnati, OH N447FDassault/Sud FAN JET FALCON SER F · S/N 443Cancelled Apr 4, 1983 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ N1176JVanecek TJ MITCHELL B-10 · S/N 231Cancelled Jun 5, 1982 · Administratively canceled · Vanecek Timothy J, Arlington, TX

Back to Producing Se Inc