Skip to content

Cancelled registrations · 39

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 = 'ID' AND d.registrant_city = 'MOSCOW' 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 = 'ID' AND d.registrant_city = 'MOSCOW'
  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 = 'ID' AND d.registrant_city = 'MOSCOW'
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.

N211EJCessna 340A · S/N 340A0514Cancelled Jun 8, 2024 · Built 1978 · Sp Aircraft LLC N3275SCessna 182G · S/N 18255775Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1964 · Barrie Scott M N9278GCessna A188B · S/N 18801444Cancelled Feb 15, 2022 · Sale reported, canceled · Built 1973 N728PFDJI PHANTOM 3 PROFESSION · S/N P76DCG15016440Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Lonnekes Jeffrey J N769DZFinwing Technology PENGUIN · S/N 0115099114101119121111117Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Lonneker Jeffrey N7370UDJI PHANTOM 2 · S/N PT645223797Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Idaho N819PCYuneec TYPHOON Q500 4K · S/N YU15260246804801Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Idaho N18054Monocoupe 90A · S/N A-763Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Built 1937 · Zabriskie Brian S N48459Grumman Acft ENG Cor-Schweizer G-164A · S/N 1645Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1976 · Fountain Inc N8756KStinson 108-1 · S/N 108-1756Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Haley Robert N700TASilvaire LUSCOMBE 8F · S/N S-28Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1959 · Sun Up Flyers LLC N2482NCessna 140 · S/N 12735Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1947 · Enochs Ed L N49360Cessna T-50 · S/N 4149Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1943 · Nyberg Carl N3276ZPiper PA-22-150 · S/N 22-7228Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1960 · Flowers Jesse S N6146CSkyhopper 10 · S/N XTC-1Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1962 · Cowin Ted N550YSSchoepflin Dale E DA-4-550 · S/N 97-001Cancelled Jan 7, 2013 · Third renewal notice · Built 1997 · Humble William R N3339Sailplane TERN · S/N RR-FL/WTM-19-72Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1972 · Crew Marshall D N477MMooney M-18C · S/N 232Cancelled Oct 1, 2012 · Sale reported, pending cancellation · Built 1950 N2838PConsolidated Aeronautics LAKE LA-4-200 · S/N 925Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1978 · Humble William R N21565Cessna 182P · S/N 18261717Cancelled Dec 29, 2010 · Revoked, pending cancellation · Built 1973 · Benner Donald H N27069Cessna 335 · S/N 335-0021Cancelled Jul 1, 2004 · Triennial form not returned · Built 1979 · Hill Otto H DBA N9768GCessna A188B · S/N 18801596TCancelled Sep 5, 2002 · Exported to Brazil · Built 1974 · Windsor Brian S N2581XCessna P206 · S/N P2060081Cancelled Jun 4, 1993 · Triennial form not returned · Magee John A Jr N7267VAero Commander CALLAIR A-9B · S/N 1318Cancelled Apr 2, 1975 · Exported to Australia · Fountain Pete N50838Taylorcraft DCO-65 · S/N 4354Cancelled Jul 31, 1974 · Hawley Keith H N8652GCessna 150F · S/N 15062752Cancelled Jun 29, 1970 · Ottmar Aviation N78736Piper PA-11 · S/N 11-1488Cancelled Jun 25, 1970 · Helbling A E N3898LCessna 172G · S/N 172-54067Cancelled Jun 14, 1968 · John C Naylor N4074UCessna 150E · S/N 1506174Cancelled Mar 16, 1966 · Built 1965 · Fountain Pete N7404XCessna 172B · S/N 17247904Cancelled Jun 8, 1965 · Fountain Pete N89301Cessna 140 · S/N 8327Cancelled May 26, 1965 · Vandal Flying Club Inc N72551Cessna 140 · S/N 9721Cancelled Apr 11, 1958 · Vandal Flying Club Inc N2531EAeronca 7AC · S/N 7AC-6113Cancelled Mar 7, 1952 · Fountain Pete N26808Piper J-3 · S/N 4189Cancelled Nov 15, 1949 · Ellis A Halman N49315Consolidated Vultee BT-13A · S/N 430Cancelled Nov 4, 1948 · Hardin Robert A N77379Cessna 140 · S/N 11820Cancelled Jul 28, 1948 · Built 1946 · Graser Harry R N8714HNorth American NAVION · S/N NAV-4-714Cancelled Mar 5, 1948 · Hall Robert W N10334Lundquist M/Manna R/Lundquist NORTHROP TRNR GLIDER · S/N 1-LHCancelled Jan 13, 1933 · Built 1930 · Lundquist Melvin N10618Parker Ernest SPORT · S/N 1Cancelled Jul 26, 1932 · Parker Ernest

Back to Moscow, ID