Skip to content

Cancelled registrations · 61

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 = 'NOVATO' 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 = 'NOVATO'
  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 = 'NOVATO'
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.

N676AMAviat A-1B · S/N 2376Cancelled Mar 16, 2026 · Exported to Canada · Built 2006 · Hogarth De La Plante John Rammacher N2401PPiper PA-38-112 · S/N 38-79A0975Cancelled Aug 22, 2022 · Exported to Philippines · Built 1979 · Monpas Carol A N211WMMacneil Wayne F ROTORWAY 162F · S/N 6513Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 2001 · Loesch Richard A N838RBBlacker Richard A RV 4 · S/N 1522Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 2000 · Blacker Richard A N49186Taylorcraft DC-65 · S/N 5264Cancelled Jan 3, 2020 · Revoked, canceled · Built 1943 · Lawton A N7330ECessna 210 · S/N 57030Cancelled Jan 29, 2019 · Registration pending, canceled · Built 1959 N33194Piper J4A · S/N 4-1358Cancelled Apr 5, 2018 · Revoked, canceled · Built 1940 · Bailey Dennis J N9929RBeech B95 · S/N TD-362Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1960 · Shadetree Flying Club Inc N312RVTevis Terry RV-6A · S/N 21199Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 2001 · Tevis Terry N4803CCessna T210N · S/N 21063634Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1979 · De Renzy Alexander E N48AALodolce/Blackwell FALCON XP · S/N 600180Cancelled Dec 22, 2014 · Registration expired, pending cancellation · American Aircraft Of California Inc N530WLBoeing 737-406 · S/N 24530Cancelled Dec 4, 2014 · Third renewal notice · Willis Lease Finance Corp N858WLBoeing 737-406 · S/N 24858Cancelled Dec 4, 2014 · Registration expired · Willis Lease Finance Corp N761YACessna T210M · S/N 21062614Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1978 · Yankee Alfa Associates N70962Piper J3C-65 · S/N 17990Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1946 · Mattingly George F N19PSSwitzer STARDUSTER TOO · S/N 553Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1974 · Morus Barbara L N4182PPiper PA-28-181 · S/N 28-43333Cancelled Nov 15, 2013 · Exported to Brazil · Built 2000 · Neff T J N70198Irish Harley K MONG SPORT · S/N N-301MCancelled Sep 19, 2013 · Registration expired, pending cancellation · Irish Harley K N95337Cessna 152 · S/N 15285873Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1984 · Cc Kemp Inc DBA N738QYCessna 172N · S/N 17270166Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1977 · Kennard Bruce P N6346QCessna 152 · S/N 15285233Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1981 · Vindar Aviation Inc N88978Cubillo-Dougherty VULTURE · S/N CD-1Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1965 N45022Cessna 177RG · S/N 177RG1089Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1976 · Sheppard Dean N91301Piper PA-38-112 · S/N 38-81A0155Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1981 · Air Allana Corporation N809WPDehavilland DHC-8-103 · S/N 032Cancelled Oct 25, 2012 · Built 1986 · Willis Lease Finance Corp N14046Piper PA-23-250 · S/N 27-4660Cancelled Jun 14, 2012 · Sale reported, canceled · Built 1971 N761LVCessna T210M · S/N 21062349Cancelled Jun 8, 2010 · Exported to Bolivia · Built 1977 · Behm Jerry W N370TBSocata TB-20 TRINIDAD · S/N 1727Cancelled Sep 25, 2009 · Exported to Canada · Built 1996 · Tavistock Capital LLC N3783NBeech 35 · S/N D-1005Cancelled Jul 27, 2009 · Registration revoked · Built 1947 · Rosen Thomas S N2113BLuscombe 8A · S/N 6540Cancelled Jul 13, 2009 · Registration revoked · Built 1948 · Faust William G N286CDCirrus Design SR22 · S/N 1235Cancelled Apr 30, 2008 · Triennial form not returned · Built 2004 · Alamar Construction Inc N347TBSocata TB-20 TRINIDAD · S/N 1700Cancelled Jan 9, 2008 · Exported to Australia · Neff T J DBA N113TBSocata TB-20 TRINIDAD · S/N 1699Cancelled Dec 13, 2007 · Exported to Australia · Built 1995 · Neff T J DBA N2942YCessna 182E · S/N 18253942Cancelled Mar 7, 2007 · Triennial form not returned · Built 1962 · Air Ward Inc N5343EBeech K35 · S/N D-5828Cancelled Dec 23, 2003 · Triennial form not returned · Built 1959 · Shade Tree Flying Club Inc N84828Cessna 172K · S/N 17258632Cancelled Feb 11, 2003 · Triennial form not returned · Built 1969 · Air Ward Inc N47729Piper PA-28R-201T · S/N 28R-7803007Cancelled Jan 26, 2001 · Exported to Thailand N210SASebring E III · S/N 1914Cancelled Oct 12, 1994 · Triennial form not returned · Sebring Robert M N2742TBeech 35-C33 · S/N CD1086Cancelled Sep 15, 1992 · Triennial form not returned · Lehmann Harry V N180HPPilotte MIDGET MUSTANG M-1 · S/N 957Cancelled Nov 18, 1991 · Triennial form not returned · Pilotte E J N6225FCessna 337 · S/N 3370225Cancelled Sep 20, 1991 · Triennial form not returned · Marin Carpet Service Inc N4081KHuebner Robert D REVOLUTION MINI 500 · S/N 1Cancelled Aug 16, 1991 · Tomasello Lawrence N761TWCessna T210M · S/N 21062514Cancelled Jul 9, 1991 · Rodriguez Carl R N12658Cessna 172M · S/N 17262153Cancelled Jun 10, 1991 · Triennial form not returned · Lang Robert E N58EEHitchcock Jerry N JH-1 · S/N 4887Cancelled Mar 26, 1991 · Triennial form not returned · Hitchcock Jerry N N8439NPiper PA-34-220T · S/N 34-8133245Cancelled Feb 4, 1985 · Administratively canceled · Putnam Stephen N68244Cessna 152 · S/N 152-82207Cancelled Dec 2, 1983 · Exported to New Zealand · Vindar Aviation Inc N1165SSchweizer SGS 1-34 · S/N 65Cancelled Oct 22, 1983 · Administratively canceled · Silverado Soaring Inc N14168Piper PA-23-250 · S/N 27-4732Cancelled Jun 25, 1983 · Administratively canceled · Nordquist Neil H N7253PPiper PA-24-250 · S/N 24-2429Cancelled Dec 20, 1982 · Lockhart Dewayne W

Back to Novato, CA