OpenAirDocs.org
Robertson, MO

Cancelled registrations · 43

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 = 'MO' AND d.registrant_city = 'ROBERTSON'
  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.

N5518NFairchild M-62A · S/N FV675Cancelled Aug 23, 2012 · Revoked, canceled · Built 1944 · Krieger Edward WN54798Consolidated Vultee BT-13A · S/N 5309Cancelled May 7, 1957 · Wallach Vernon CN21395Aeronca K · S/N K343Cancelled Oct 19, 1955 · Built 1938 · Walling Lyle GN26673Taylorcraft BL-65 · S/N 2015Cancelled Sep 12, 1949 · Robertson Aircraft CorpN36607Aeronca 65-CA · S/N 16961Cancelled Jan 6, 1949 · Built 1941 · Robertson Aircraft CorpN37392Interstate S-1A-65F · S/N 235Cancelled Aug 27, 1948 · Built 1942 · Robertson Aircraft CorporationN19421Monocoupe 90A · S/N A-777Cancelled Aug 20, 1948 · Built 1939 · Monocoupe CorpN26477Meyers OTW · S/N 30Cancelled Jun 25, 1948 · St Louis School Of Aeronautics IncN20982Culver LCA · S/N 111Cancelled May 28, 1948 · Robertson Aircraft CorpN2209Waco EGC-7 · S/N 4558Cancelled May 4, 1948 · Built 1937 · Robertson Aircraft CorportationN16033Ryan Aeronautical ST-A · S/N 122Cancelled Apr 21, 1948 · Built 1936 · Robertson Aircraft CorpN14227Security National Acft S1-A · S/N 17Cancelled Apr 7, 1948 · Built 1934 · Aviation Credit Corp Of St LouisN928WStinson SM-8A · S/N M-4105Cancelled Mar 31, 1948 · Robertson Aircraft CorpN694MBrewster FLEET 2 · S/N 255Cancelled Mar 11, 1948 · Built 1930 · Robertson Aircraft CorpN118VMonocoupe 110 · S/N 6W31Cancelled Feb 25, 1948 · Monocoupe CorpN14082Waco YMF · S/N 4120Cancelled Dec 21, 1944 · Built 1934 · Robertson Aircraft CorpN24927Piper J3F-50 · S/N 3541Cancelled Oct 1, 1941 · Brayton Flyng Service IncN19427Curtiss-Wright 23 · S/N 23-1Cancelled Jul 22, 1941 · Built 1939 · Curtiss Wright CorpN16021Lockheed ELECTRA 10-B · S/N 1056Cancelled Apr 22, 1941 · Chicago & Southern Air Lines IncN21688Piper J3F-50 · S/N 2574Cancelled Apr 9, 1941 · Built 1938 · Robertson Aircraft CorpN16023Lockheed ELECTRA 10-B · S/N 1058Cancelled Jan 18, 1941 · Exported to India · Chicago & Southern Air Lines IncN16024Lockheed ELECTRA 10-B · S/N 1059Cancelled Jul 13, 1940 · Exported to Canada · Chicago & Southern Air Lines IncN16417Curtiss Wright A-19-4 · S/N 19R-10Cancelled May 17, 1940 · Built 1937 · Curtiss Wright Corp St Louis Airplane DivN19441Curtiss-Wright CW-21 · S/N 21-2Cancelled May 15, 1940 · Built 1940 · Curtiss-Wright CorpN6524Waco GXE · S/N 1659Cancelled Aug 1, 1939 · St Louis Flying Service IncN426KFleet 2 · S/N 149Cancelled Apr 17, 1938 · Brayton Flying School IncN16421Curtiss Wright A-19-4 · S/N 19R-14Cancelled Apr 2, 1938 · Built 1937 · Lambert Stafford LN11781Curtiss Wright 19R · S/N 19R-1Cancelled Mar 1, 1937 · Built 1936 · Curtiss Wright CorpN16022Lockheed ELECTRA 10-B · S/N 1057Cancelled Aug 5, 1936 · Chicago And Southern Air Lines IncN9282Curtiss-Robertson ROBIN C-1 · S/N 358Cancelled Oct 23, 1935 · Exported to Mexico · Built 1929 · Brayton Flying Service IncN6490Stearman C-3-MB · S/N 188Cancelled Jul 17, 1934 · American Airways IncN880EFokker F-10-A(FXA) · S/N 1047Cancelled Jun 1, 1933 · Built 1929 · American Airways IncN881EFokker F-10-A(FXA) · S/N 1048Cancelled May 12, 1933 · Built 1929 · American Airways IncN5551Ryan B1 · S/N 116Cancelled Jan 7, 1933 · Robertson Airplane Services CoN310NCurtiss KINGBIRD J-3 · S/N G-2Cancelled Dec 13, 1932 · Curtiss-Wright Airplane CoN12324Curtiss-Wright CW-3W · S/N 1502Cancelled Jan 18, 1932 · Built 1931 · Curtiss Wright Airplane CoN866Ryan B1 · S/N 35Cancelled Aug 18, 1931 · Built 1927 · Robertson Airplane Service CoN94WPitcairn PA-6 · S/N 146Cancelled Aug 4, 1931 · American Airways IncN1133Ryan M-2 · S/N 20Cancelled Apr 17, 1931 · Built 1927 · Lambert Flying Club IncN736MRyan B-5 · S/N 236Cancelled Sep 26, 1930 · Ryan Aircraft CorpN550NRyan B-5 · S/N 242Cancelled Aug 22, 1930 · Ryan Aircraft CorpN385KRyan B-5 · S/N 241Cancelled Mar 20, 1930 · Ryan Aircraft CorpN321HA V Roe AVRO AVIAN · S/N 268Cancellation date not recorded · Aviation Credit Corporation Of St Louis
Back to Robertson, MO