Skip to content

Cancelled registrations · 47

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 = 'NJ' AND d.registrant_city = 'CAMDEN' 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 = 'NJ' AND d.registrant_city = 'CAMDEN'
  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 = 'NJ' AND d.registrant_city = 'CAMDEN'
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.

N60898Consolidated Vultee BT-13A · S/N 8821Cancelled Jul 16, 2013 · Revoked, canceled · Built 1942 · Templin John F N5698ZPiper PA-22-108 · S/N 22-9535Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1962 · Stosny Anthony Jr N4611KRyan NAVION · S/N NAV-4-1611Cancelled Jul 31, 2012 · Revoked, canceled · Built 1948 · Mcveigh George J N86138Aeronca 11AC · S/N 11AC-568Cancelled Oct 28, 1981 · Exported to Canada · Stosny Anthony Jr N533CSGrumman G-159 · S/N 110Cancelled Jun 22, 1977 · Exported to Canada · Campbell Soup Co N4890TPiper PA-28-180 · S/N 28-7205218Cancelled Mar 22, 1976 · Exported to Canada · Built 1972 · Cherokee Associates Inc N3375WPiper PA-32-260 · S/N 32-221Cancelled Jan 5, 1971 · Built 1965 · Strange John W N11638Piper PA-24 · S/N 55Cancelled May 18, 1965 · Paramount Air Service N47854Taylorcraft DCO-65 · S/N 0-4327Cancelled Jul 16, 1959 · Built 1944 · Daly Mathew L N25DBeech D18S · S/N A270Cancelled Jun 23, 1958 · Radio Corp Of America N94302Ercoupe 415-C · S/N 1525Cancelled May 7, 1957 · Built 1946 · Mullins Carl R N15069Kellett KD-1B AUTOGIRO · S/N 101Cancelled Jan 31, 1956 · Built 1939 · Kellett Aircraft Corp N87593Republic RC-3 · S/N 162Cancelled Oct 28, 1955 · Maness Frederick B N46390Fairchild M-62A · S/N T43-5329Cancelled May 19, 1955 · Built 1945 · Mancine Peter V N3184VBeech 35 · S/N D-619Cancelled Mar 23, 1954 · Radio Corp Of America N54833North American AT-6 · S/N 59-1981Cancelled Dec 2, 1952 · Exported to Israel · Spartan Aero Repair N9972HNorth American AT-6 · S/N 84-7596Cancelled Nov 20, 1952 · Exported to Mexico · Built 1942 · Spartan Aero Repair N80467North American AT-6 · S/N 88-10244Cancelled Oct 31, 1952 · Exported to Mexico · Built 1942 · Spartan Aero Repair N66021North American SNJ-3 · S/N 78-7166Cancelled Oct 29, 1952 · Exported to Mexico · Spartan Aero Repair N5285NNorth American AT-6 · S/N 8810396Cancelled Jun 25, 1952 · Exported to South Africa · Spartan Aero Repair Division Of Spartan Aircraft N54690North American AT-6 · S/N 77-4576Cancelled Jun 25, 1952 · Exported to Israel · Spartan Aero Repair Division Of Spartan Aircraft C N9355HNorth American SNJ-4 · S/N 88-9333Cancelled Jun 4, 1952 · Exported to Israel · Spartan Aero Repair N5703NNorth American AT-6C · S/N 42-84643Cancelled May 20, 1952 · Exported to Israel · Spartan Aero Repair N9291HNorth American AT-6A · S/N 78-7222Cancelled Apr 23, 1952 · Exported to Israel · Spartan Aero Repair N13569Waco UIC · S/N 3828Cancelled Apr 22, 1952 · Built 1933 · Paramount Air Service N9050HBeech AT-10 · S/N 638Cancelled Apr 5, 1951 · Colsey Arthur L N76004Cessna 120 · S/N 10398Cancelled Mar 2, 1951 · Central Airport Flying Service N76638Cessna 120 · S/N 11078Cancelled Mar 2, 1951 · Central Airport Flying Service N3114HEngineering & Research ERCOUPE 415-C · S/N 3739Cancelled Jun 13, 1950 · Built 1946 · Central Airport Flying Service N6001KRepublic RC-3 · S/N 170Cancelled Jun 13, 1950 · Central Airport Flying Service Inc N77044Cessna 120 · S/N 11498Cancelled Jun 13, 1950 · Built 1946 · Central Airport Flying Service N93940Ercoupe 415-C · S/N 1263Cancelled Aug 22, 1949 · Built 1946 · Este Aviation Incorp N89158Cessna 140 · S/N 8170Cancelled Apr 15, 1949 · Walz Corp N20648Grumman G-21A · S/N 1018Cancelled Apr 14, 1949 · Exported to Ecuador · R M Hollingshead Corp N22731Piper J4 · S/N 4434Cancelled Jun 9, 1948 · Soloff Albert & Mark Morton N89589Cessna 140 · S/N 8632Cancelled Nov 6, 1947 · Walz Corp N6172KRepublic RC-3 · S/N 360Cancelled Oct 22, 1947 · Warren Webster Jr N26661Taylorcraft BL · S/N 2003Cancelled Jan 29, 1941 · Pal Air Club N848WPerth Amboy BIRD BK · S/N 2052-32Cancelled Sep 2, 1937 · Walz Corporation N14068Waco YKC · S/N 3988Cancelled Aug 1, 1936 · Built 1934 · Tatem Minnie A M N814VWaco NAZ · S/N 4016Cancelled Mar 14, 1933 · Wings Corp Of Philadelphia N825VWaco NAZ · S/N 4028Cancelled Jan 12, 1933 · Wings Corp Of Philadelphia N11683Kellett K-2 · S/N 6Cancelled Nov 1, 1932 · Ludington Flying Service Inc N6806Waco GXE · S/N G-1594Cancelled Oct 20, 1931 · Ludington Flying Service Inc N931MMoth 60-GM · S/N 130Cancelled Jun 25, 1931 · Ludington Flying Service Inc N73MSchneider ES 59 ARROW · S/N 1Cancelled Aug 6, 1930 · Jacob E Brown N1832Curtiss JN4D · S/N 3770Cancelled Jan 24, 1928 · Arrowsmith Arthur E

Back to Camden, NJ