Skip to content

Cancelled registrations · 944

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 = 'OR' AND d.registrant_city = 'PORTLAND' 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 = 'OR' AND d.registrant_city = 'PORTLAND'
  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 = 'OR' AND d.registrant_city = 'PORTLAND'
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.

N1211NConsolidated Vultee BT-15 · S/N 10629Cancelled Apr 5, 1951 · Snyder Arthur H N49091Aeronca 0-58B · S/N 058B-2632Cancelled Apr 3, 1951 · Johnson Leslie W N26406Stinson 10 · S/N 7594Cancelled Mar 29, 1951 · Built 1940 · Whitaker A W N46807Fairchild M-62A · S/N T43-7161Cancelled Mar 29, 1951 · Matteson Austin R N49394Fairchild M-62A · S/N T42-1494Cancelled Mar 29, 1951 · Howard Dale R N49401Fairchild PT-19B · S/N T43-5832Cancelled Mar 29, 1951 · Griffiths Happy J N19938Cessna T-50 · S/N 2700Cancelled Mar 28, 1951 · Olson Oscar E Jr N258HBeech D17S · S/N 4901Cancelled Mar 27, 1951 · H M Clark Jr N94612Ercoupe 415-CD · S/N 4713Cancelled Feb 15, 1951 · Built 1947 · Venegelen Ambrose P N89564Cessna 140 · S/N 8607Cancelled Jul 25, 1950 · Grantham Glen E N4350KRyan NAVION · S/N NAV-4-1350Cancelled Jul 20, 1950 · A M Conway & Sons N23551Aeronca S-65-C · S/N C-5149Cancelled Jun 8, 1950 · Built 1939 · Cottrell George W N49422Fairchild M-62A · S/N T43-5765Cancelled May 5, 1950 · Henry Elwin B N1653BLuscombe 11A · S/N 11-159Cancelled Mar 9, 1950 · Built 1948 · Oien Al F N2271EAeronca 7AC · S/N 7AC-5845Cancelled Nov 16, 1949 · Butler H N N2276EAeronca 7AC · S/N 7AC-5851Cancelled Jul 15, 1949 · Dahl John P Richard W Brown N17490Aeronca K · S/N K-14Cancelled Jun 20, 1949 · Chasteen William F N49303Fairchild M-62A · S/N T42-1537Cancelled Apr 6, 1949 · Streans & Welch Meat Co N54622Fairchild M-62A · S/N T42-3639Cancelled Mar 8, 1949 · Woodlaw Graham C N54074Cessna UC-78 · S/N 3610Cancelled Mar 1, 1949 · Davis C Russell N49426Fairchild M-62A · S/N T43-5057Cancelled Feb 3, 1949 · Jameson Dick N53895Fairchild M-62A · S/N T42-1948Cancelled Dec 31, 1948 · Hall James E N53023Ryan Aeronautical ST3KR · S/N 2170Cancelled Nov 9, 1948 · Built 1942 · Clark Herbert M Jr N49239Fairchild M-62A · S/N T42-3482Cancelled Nov 4, 1948 · Skylife Inc N37704Porterfield FP-65 · S/N 933Cancelled Sep 15, 1948 · Built 1941 · Kelly Alfred P N33342Johnson ROCKET 185 · S/N 4Cancelled Sep 2, 1948 · Don D Waltz N4472Waco GXE · S/N 1120Cancelled Jul 13, 1948 · Kempton Ray N19953Fred J Shepard/Thomas C Krum SHEPARD/KRUM SPRTCFT · S/N SC-1Cancelled Jun 30, 1948 · Murray A Wick N18899Aeronca K · S/N K-168Cancelled Jun 9, 1948 · Read Anthony W N19961Aircraft Builders STUDENT PRINCE X · S/N 104Cancelled May 25, 1948 · Brodsky Hyman W N49414Boeing A75N1 · S/N 75-3074Cancelled May 12, 1948 · Davis Russell C N49443Cessna T-50 · S/N 6268Cancelled May 12, 1948 · Cole James A N49297Boeing A75N1(PT17) · S/N 75-1767Cancelled May 4, 1948 · Columbia Crop Dusting Service N15404Beech B17L · S/N B17L-42Cancelled Apr 23, 1948 · Built 1935 · Coffey Harry K N1123Eaglerock LONG WING EAGLEROCK · S/N 242Cancelled Mar 29, 1948 · Built 1927 · Sturges Robert G N235YKinner SPORTSTER K · S/N 30Cancelled Mar 25, 1948 · Built 1933 · Ensign John Dale N828MAircraft Builders STUDENT PRINCE X · S/N 100Cancelled Feb 26, 1948 · Wray Donald C N105BBell 47B · S/N 25Cancelled Feb 10, 1948 · Built 1947 · Journal Publishing Co N189HFairchild 71 · S/N 672Cancelled Dec 10, 1947 · S & M Flying Service N26629Taylorcraft BL-65 · S/N 1971Cancelled Oct 29, 1947 · Built 1940 · S & M Flying Service N85827Aeronca 11AC · S/N 11AC-226Cancelled Aug 22, 1947 · Built 1946 · Whaley E A N49446Fairchild M-62A · S/N T42-3692Cancelled Jun 22, 1946 · Henry Elwin B N53022Ryan Aeronautical PT-22 · S/N 1818Cancelled Jan 17, 1946 · Stine Stanley R N49378Boeing A75N1 · S/N 75-2438Cancelled Dec 3, 1945 · Taber George W N10672Bird BK · S/N 2059-39Cancelled Apr 1, 1944 · Built 1930 · Davis Roy N27734Stinson 10 · S/N 7667Cancelled Feb 16, 1944 · Commercial Aircraft Co Inc N459WMonocoupe 90 · S/N 632Cancelled Feb 5, 1944 · Built 1932 · Gailbraith Theodore C N20981Culver LCA · S/N 110Cancelled May 28, 1943 · Built 1940 · Freeman Percy Frary Jr N33982Taylorcraft BL12-65 · S/N 2834Cancelled Aug 15, 1942 · Altitude Club Inc N8294Eaglerock A-2 · S/N 901Cancelled Jan 22, 1942 · Built 1929 · Mckinnon A G

Back to Portland, OR