Skip to content

Morgan Hill, CA

Cancelled registrations · 36

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 = 'MORGAN HILL' 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 = 'MORGAN HILL'
  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 = 'MORGAN HILL'
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.

N3906XPiper PA-28R-200 · S/N 28R-7535348Cancelled Mar 1, 2023 · Built 1975 · Petersen Aircraft Inc N809SRCirrus Design SR22 · S/N 2129Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2006 · Tierra Grande Aviation LLC N8353TPiper PA-28-236 · S/N 28-8111055Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1981 · Positive Dynamic Aviation N93941Engineering & Research ERCOUPE 415-G · S/N 1264Cancelled Nov 30, 2018 · Registration expired, pending cancellation · Built 1946 · Woodward Allen G N7123BBalloon Works FIREFLY 8B · S/N F8B-145Cancelled May 31, 2018 · Sale reported, canceled · Built 1988 N3869AFletcher John L XAIR · S/N 1171Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Nedelcovic Ivan R N1722DCessna 170A · S/N 20165Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1951 · Moffatt Jeff C N1514UBalloon Works FIREFLY 7 · S/N 11027Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1981 · Anson Jeanne M N4435WMartin/Rohde TERATORN TIERRA II · S/N 3449775Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1983 · Lite Flite N6207Jones Jerry ROTORWAY 162F · S/N 6207Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1997 · Jones Jerry D N27022Balloon Works FIREFLY 7 · S/N 757Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1977 · Anson Jeanne M N2854RPiper PA-28-201T · S/N 28-7921065Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Northcott Freeman L N6683CBleriot 1909 · S/N 1Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Perlitch Janice N9033WPiper PA-28-235 · S/N 28-10625Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1965 · Beattie Tom N12BDMartin-Brooks BD-4 · S/N 12Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Martin Glenn H N5786ECessna 150 · S/N 17286Cancelled Feb 21, 2013 · Revoked, canceled · Built 1959 · Britton Robert James N7340Byrd VOLKSPLANE VP-1 · S/N 2048Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1974 N2357JCessna 172S · S/N 172S10588Cancelled Dec 3, 2012 · Exported to New Zealand · Built 2007 · Journey Of A Lifetime Luxury Travel LLC N3274FMooney M20F · S/N 670367Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1967 · Holliday Lloyd E Jr N91537North American NAVION · S/N NAV-4-133Cancelled Sep 10, 2012 · Revoked, canceled · Built 1946 · Rolita Edward P N90854Balloon Works FIREFLY 8B · S/N F8B-314Cancelled Jun 5, 2008 · Triennial form not returned · Built 1991 · Anson Jeanne M N18014Cessna 150L · S/N 15073731Cancelled Apr 22, 2008 · Exported to Philippines · Built 1972 · Robson William W N7383ACessna 172 · S/N 29483Cancelled Dec 21, 2006 · Triennial form not returned · Built 1956 · Vongiese Leonard N36180Balloon Works FIREFLY 8-24 · S/N F8-041Cancelled Nov 9, 1999 · Registration expired, pending cancellation · Built 1984 · Farnham Myron J N7000JEagle Balloons C-7 · S/N E81710Cancelled Nov 9, 1999 · Second triennial mailing, no response · Farnham Myron J N74206Balloon Works FIREFLY 8-24 · S/N F8-080Cancelled Nov 1, 1999 · Exported to Mexico · Farnham Myron J N3047APiper PA-28-161 · S/N 287916107Cancelled Mar 18, 1997 · Exported to Malaysia · Nord Jerry E N5384WCessna P210N · S/N P21000681Cancelled Nov 5, 1996 · Triennial form not returned · Kushner Robert N1980MRaven Industries S-66A · S/N S66A105Cancelled Dec 18, 1991 · Triennial form not returned · Farnham Myron J N4832BCessna 310 · S/N 35132Cancelled Sep 30, 1982 · Merrill Richard L N4652KCessna 182P · S/N 18263654Cancelled Nov 23, 1976 · Built 1975 · Mcelroy Dale A N52290Fairchild M-62A · S/N T421770Cancelled Apr 23, 1974 · Leslie Paul R & Budde Bobby M N2324DCessna 170B · S/N 20476Cancelled Mar 8, 1974 · Mcrae Lawrence F N2861HEngineering & Research ERCOUPE 415-C · S/N 3486Cancelled Dec 6, 1971 · Marchese Michael A N78342Aero Commander 680-F · S/N 680F-1202-106Cancelled Jul 29, 1971 · Exported to Norway · Bonfonte Mario F N5455BCessna 182 · S/N 33455Cancelled Jan 26, 1971 · C H R Flying Club Inc

Back to Morgan Hill, CA