OpenAirDocs.org
Lodi, NJ

Cancelled registrations · 30

Query with SQL
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 = 'NJ' AND d.registrant_city = 'LODI'
  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.

N3102QAerotechnik L-13 SEH VIVAT · S/N 930507Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1993 · Mechura Emil JN319JBBontempo Jerry J DAPHNE · S/N 17162024293777Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Bontempo Jerry JN9278HFairchild M-62A · S/N FV457Cancelled Feb 13, 2017 · Revoked, canceled · Built 1943 · Guzman FrankN54409Piper PA-28-140 · S/N 28-7425125Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1973 · Costello Frank JrN6947KPiper PA-20 · S/N 20-51Cancelled Sep 3, 2014 · Revoked, canceled · Built 1950 · Jack Howard BN3897GCessna U206B · S/N U206-0897Cancelled Jul 30, 1974 · Van Don Company IncN9502DPiper PA-22-160 · S/N 22-6417Cancelled Mar 15, 1972 · Built 1958 · Van Don Co IncN4308YPiper PA-23-160 · S/N 23-2031Cancelled Nov 12, 1970 · Van Don Co IncN162ACessna 411 · S/N 411-0219Cancelled Jan 29, 1969 · Van Don Co IncN30260Cessna 177 · S/N 17701157Cancelled Jul 26, 1968 · Exported to Germany · Van Don Company IncN93304Ercoupe 415-C · S/N 627Cancelled Jun 27, 1968 · Exported to Canada · Van Don Co IncN2285FCessna 310L · S/N 310L-0085Cancelled Feb 27, 1968 · Exported to Brazil · Van Don Co IncN8360JCessna 150G · S/N 15066260Cancelled May 10, 1967 · Exported to Norway · Van Don Co IncN8309JCessna 150G · S/N 15066209Cancelled Apr 6, 1967 · Exported to Germany · Built 1967 · Van Don Company IncN9773RBeech M35 · S/N D-6256Cancelled Jul 20, 1965 · Exported to South Africa · Van Don Co IncN3193UCessna 182F · S/N 18254593Cancelled Jul 19, 1965 · Exported to South Africa · Built 1963 · Can Don Co IncN2406XCessna 182H · S/N 18256306Cancelled Jun 22, 1965 · Exported to Germany · Built 1965 · Van Don Co IncN5112UCessna 206 · S/N 2060-112Cancelled Jun 22, 1965 · Exported to South Africa · Van Don Co IncN8171MCessna 310I · S/N 310I0171Cancelled Jun 18, 1965 · Exported to South Africa · Van Don Company IncN7095YPiper PA-30 · S/N 30-61Cancelled Jun 14, 1965 · Van Don Co IncN3695VCessna 140 · S/N 14971Cancelled Jun 12, 1965 · Cardall Alfred JN2032PPiper PA-23 · S/N 23-607Cancelled May 24, 1965 · Exported to South Africa · Van Don Co IncN4725DCessna 182A · S/N 34825Cancelled Apr 28, 1965 · Exported to South Africa · Built 1958 · Don Co IncN8187MCessna 310I · S/N 310I0187Cancelled Mar 22, 1965 · Exported to South Africa · Van Don Co IncN5883TCessna 185 · S/N 185-0783Cancelled Nov 16, 1964 · Exported to Norway · Van Don Company IncN6771ACessna 172 · S/N 28871Cancelled Aug 20, 1963 · Exported to Germany · Van Don CoN9200CCessna 180 · S/N 31299Cancelled Jan 26, 1960 · Exported to Finland · Mclaren PatrickN4308MPiper PA-12 · S/N 12-3264Cancelled Feb 28, 1952 · Built 1947 · Dzendzel JohnN841WGates GATES RSV · S/N 103Cancelled Aug 2, 1934 · West Charles FN1240Curtiss JN4D · S/N 2051Cancellation date not recorded · Gates Flying Circus & Aviationco
Back to Lodi, NJ