Skip to content

Cancelled registrations · 116

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

N100MWBeech E-90 · S/N LW-2Cancelled Jul 2, 2026 · Built 1972 · Tunnell Darrell N6089WPiper PA-28-140 · S/N 28-20103Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1964 · Wright Gregory D N36485Piper PA-34-200T · S/N 34-7870336Cancelled Feb 10, 2023 · Exported to Argentina · Entropic Synergies LLC N14537Aeronca C-3 · S/N 432Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Bl Link Enterprises LLC N328SCBeech 58 · S/N TH-1311Cancelled Oct 27, 2022 · Exported to Argentina · Built 1981 · Entropic Synergies LLC N818SBeech V35B · S/N D-9101Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1970 · Nepinsky Brian C N13560Cessna 177B · S/N 17702436Cancelled Apr 18, 2022 · Exported to Argentina · Entropic Synergies LLC N614ZPDJI INSPIRE 1 · S/N W13DCC28030017Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Pruitt Larry C N7196XCessna 150A · S/N 15059296Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1961 · Benway David C N80NWHiller UH-12E4 · S/N 5104Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Barton Aero Inc N45101Naval Aircraft Factory N3N-3 · S/N 2757Cancelled Jun 5, 2020 · Revoked, canceled · Built 1943 · Frontier Airways N1035FAir Tractor AT-502 · S/N 502-0081Cancelled Apr 8, 2020 · First renewal notice · Built 1990 · Gilbert Aviation Industries Inc N70537Piper J-3 · S/N 17546Cancelled Jan 24, 2020 · Revoked, canceled · Built 1946 · White Pauline J P N8640PPiper PA-24-260 · S/N 24-4081Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1964 · Bushnell Industries Inc N8561FBell 47G-5 · S/N 7809Cancelled Jul 10, 2019 · Registration expired, pending cancellation · Built 1966 · Barton Aero Inc N929ECChouest Eddie CHOUEST EAGLE II · S/N CHOUEST-0001Cancelled Feb 2, 2019 · Sale reported, canceled · Built 1981 N51652Maule M-5-220C · S/N 5037CCancelled Jun 26, 2018 · Registration pending, canceled · Built 1974 N5732PPiper PA-24 · S/N 24-35Cancelled May 30, 2018 · Sale reported, canceled N5011HPiper PA-18 · S/N 19-1Cancelled Apr 5, 2018 · Revoked, canceled · Built 1949 · White Pauline J P N4774SBell 47G-2A · S/N WAV182Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1965 · Barton Aero Inc N29570Piper PA-28RT-201 · S/N 28R-7918147Cancelled Mar 13, 2018 · Exported to Uruguay · Built 1979 · Entropic Synergies LLC N4048WPiper PA-32-300 · S/N 32-40065Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1966 · Akin T A N22957Piper J3C-65 · S/N 2854Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1940 · Lemons Brooks D N45837Ross Orrin E RS1-RS-2L · S/N 1Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Blain Brian Thomas N659PGMooney M20J · S/N 24-0701Cancelled Jun 13, 2017 · Exported to Argentina · Built 1978 · Entropic Synergies LLC N911TSFlight Design CTLS · S/N F-11-02-05Cancelled Sep 14, 2016 · Built 2011 · County Of Tulare Sheriffs Office N9711RBeech 95-55 · S/N TC-12Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1960 · Fanopoulos Dimitrious G N67116Hiller UH-12E · S/N 1711Cancelled Nov 14, 2014 · Registration expired, pending cancellation · Built 1964 · Green E J N824TSCirrus Design SR22 · S/N 2197Cancelled Oct 20, 2014 · Exported to Canada · Built 2006 · Carejet LLC N68448Boeing A75N1(PT17) · S/N 75-6820Cancelled Nov 12, 2013 · Revoked, canceled · Built 1943 · Crop Air Inc N4328UBealine Sporty 0-1 · S/N 1Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Arias Angel D N43JDPiper PA-38-112 · S/N 38-78A0432Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1978 · Bostard Will N2115SCessna T210L · S/N 21061078Cancelled Aug 9, 2013 · Registration expired, pending cancellation · Built 1975 · Rameson Robert F Trustee N807QBeech 58 · S/N TH-823Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1977 · Darrell Tunnell Co N125ZLCessna 210-5 · S/N 205-0037Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1963 · Lane Zeth N4070XRaven S-60A · S/N S60A-268Cancelled May 9, 2013 · Sale reported, canceled · Built 1983 N78370Aero Commander 500-A · S/N 1255-79Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1962 · William L Main Inc N1115XPiper PA-28-140 · S/N 28-7525284Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1975 · Quinci Thomas J N7951PPiper PA-24-250 · S/N 24-3188Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1962 N58744Stinson L-5 · S/N 76811Cancelled Feb 21, 2013 · Revoked, canceled · Built 1942 · Henderson Pauline J P N7205WPiper PA-28-180 · S/N 28-1018Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1963 N6058KCessna 150M · S/N 15077500Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1975 N6717DBell 47G-2 · S/N 2210Cancelled Nov 26, 2012 · Sale reported, pending cancellation · Built 1958 N7358PPiper PA-24-250 · S/N 24-2536Cancelled Oct 16, 2012 · Sale reported, pending cancellation · Built 1961 N49957Boeing PT-17 · S/N 75-2982Cancelled Aug 9, 2012 · Revoked, canceled · Built 1942 · Crop Air Inc N4806VBoeing A75 · S/N 75-2026Cancelled Aug 7, 2012 · Revoked, canceled · Built 1941 · Crop Air Inc N925Clawson Richard S NUVENTURE · S/N 0001Cancelled May 22, 2012 · First renewal notice · Built 1999 · Clawson Richard S N996AAMaule M-6-235 · S/N 7397CCancelled May 21, 2012 · Exported to Canada · Built 1982 · Cal Agro Seed Co Inc N6090QMooney M20C · S/N 3260Cancelled Jun 18, 2011 · First renewal notice · Built 1965 · Williams Sheldon Lewis N31552Bell 47G-2 · S/N 434Cancelled Apr 16, 2011 · Registration pending, pending cancellation

Back to Visalia, CA