Skip to content

Cancelled registrations · 35

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 = 'CA' AND d.registrant_city = 'ROSEVILLE' 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 = 'CA' AND d.registrant_city = 'ROSEVILLE'
  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 = 'CA' AND d.registrant_city = 'ROSEVILLE'
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.

N258MHEvolution REVOLT · S/N 001028Cancelled Jan 6, 2024 · Registration pending, canceled · Built 2021 N8084ECameron Balloons Z-90 · S/N 6287Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Miller Kyle N141PSGlaser-Dirks DG 500 ELAN · S/N 5E186X36Cancelled Oct 27, 2020 · Built 1998 · Silverado Soaring Inc N4781BCessna 152 · S/N 15283631Cancelled May 27, 2020 · Exported to Turkey · Executive Aviation Solutions Inc N5249KNavion NAVION B · S/N NAV-4-2149BCancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1950 · United Property Advocates LLC N4562DBeech G35 · S/N D4714Cancelled Apr 23, 2019 · Registration expired, pending cancellation · Cardinal Landmark Properties LLC N31KRInfinity Power Parachutes INFINITY 2003 · S/N IPP3-180Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 2003 · Hanson Todd A N41735Culver LFA · S/N 457Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1942 · Crosby Scott N1951BCubcrafters CC11-160 · S/N CC11-00406Cancelled Jun 15, 2018 · Plane Fun LLC N727GGLee W Graybill/William L Gotte G&G ACE · S/N 001Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Graybill Lee W N94579Spectrum BEAVER RX40 · S/N 255Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1993 · Hicks Matt A N40RBBeech 95 · S/N TD-286Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Melnik Charles J N2004QCessna 177RG · S/N 177RG0404Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1973 · Melnik Charles J DBA N551GPNorth American P-51D · S/N 44-72321Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Dream Machines LLC N77969Luscombe 8A · S/N 3696Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1946 · Greener Russell N N1949HPiper PA-28-161 · S/N 28-7716068Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1977 · Darrell Spence Jr N996FMCook Robert C RUTAN VARI-EZE · S/N 991Cancelled May 14, 2013 · Registration expired, pending cancellation · Martin Frank C N4608PPiper PA-23-250 · S/N 27-121Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1960 N728RJCessna 182T · S/N 18281396Cancelled Oct 27, 2010 · Exported to South Africa · Built 2004 · Rysaw Air LLC N4379APiper PA-32R-301T · S/N 32R-8529013Cancelled Jan 28, 2008 · Triennial form not returned · Built 1985 · D F Properties Inc N93DBBuchanan Donald W PITTS S1S · S/N 8-0138Cancelled May 13, 2005 · Exported to Sweden · Built 1984 · Morrison Michael A N5492KCessna 172P · S/N 17274157Cancelled Apr 16, 2002 · Exported to Switzerland · Built 1980 · Ceasar Aero Inc N4451RCessna 172M · S/N 17263193Cancelled Oct 6, 1998 · Triennial form not returned · Ledrew Sandra J N761NECessna T210M · S/N 21062380Cancelled Jun 16, 1993 · Csy Investments N2077ECessna 172N · S/N 17271145Cancelled Jul 20, 1992 · Exported to France · Mcgrew J Benjamin N732HHCessna TU206G · S/N U20604678Cancelled Apr 18, 1991 · Triennial form not returned · Mogol Marc DBA N5676SBeech A23-24 · S/N MA84Cancelled Mar 26, 1991 · Triennial form not returned · Lewis Steven R N90SDPaulson STARDUSTER SA300 · S/N 1136Cancelled Nov 25, 1987 · Second triennial mailing, no response · Built 1976 · Curnutt Hugh H N56KHHeidger KR-2 · S/N KRH-291Cancelled Sep 9, 1983 · Heidger Kenneth R N8173LCessna 172H · S/N 17256373Cancelled Apr 9, 1983 · Administratively canceled · 73 L Aircraft Corporation N78501Cessna 172K · S/N 172-57641Cancelled May 5, 1972 · Kime Zane R & Sharon N7304XCessna 150B · S/N 15059404Cancelled Apr 30, 1971 · Douglass Thomas Edward N3956EAeronca 11BC · S/N 11BC-40Cancelled Feb 9, 1971 · Holtsman Clyde And/Or Edna Holtsman N7285TCessna 172A · S/N 46885Cancelled Oct 7, 1970 · Williams Norman S N90183Cessna 140 · S/N 9248Cancelled Oct 2, 1952 · Daniels Harry S

Back to Roseville, CA