Skip to content

Cancelled registrations · 50

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

N6570DJI AGRAS T40 · S/N 64TBKAF002006PCancelled Oct 17, 2026 · Sale reported, canceled N310PKCessna 310 · S/N 35153Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1955 · Kass Peter D N47MPCessna 172RG · S/N 172RG1137Cancelled Jun 13, 2022 · Exported to Mexico · Built 1983 · Howard Harold Spencer N127YYYuneec USA TORNADO H920 · S/N YU15400121B03A01Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Fallbrook Flight Academy LLC N9133ZMooney M20J · S/N 24-1700-14Cancelled Nov 5, 2019 · First renewal notice · Built 1990 · Morrison Carleton H Jr N102CMMalinowski Walter S RV8A · S/N 81015Cancelled Aug 2, 2018 · Sale reported, canceled · Built 2014 N9909BCessna 182A · S/N 34309Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1957 N8325XRobinson Helicopter R44 · S/N 0207Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1995 N667DCPiper PA-24-250 · S/N 24-1611Cancelled May 31, 2018 · Sale reported, canceled · Built 1959 N704PTCessna 150M · S/N 15078772Cancelled May 31, 2018 · Sale reported, canceled · Built 1976 N738GKCessna TR182 · S/N R18200925Cancelled May 31, 2018 · Sale reported, canceled N1093WBeech V35B · S/N D-9506Cancelled May 30, 2018 · Sale reported, canceled · Built 1973 N120MDCessna 120 · S/N 10770Cancelled May 30, 2018 · Sale reported, canceled · Built 1946 N2613GCessna 182B · S/N 51913Cancelled May 30, 2018 · Sale reported, canceled · Built 1953 N464WAPiper PA-34-200T · S/N 34-7870189Cancelled May 30, 2018 · Sale reported, canceled · Built 1978 N4998EAero Commander 680FL · S/N 1739-141Cancelled May 30, 2018 · Sale reported, canceled · Built 1968 N5167RCessna 172RG · S/N 172RG0043Cancelled May 30, 2018 · Sale reported, canceled · Built 1979 N5295YCessna 172S · S/N 172S9236Cancelled May 30, 2018 · Sale reported, canceled · Built 2002 N1550RGrumman American Avn. AA-5B · S/N AA5B-0050Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1975 · Hubbard Dave C N888BFBeech E-55 · S/N TE-819Cancelled Mar 7, 2018 · Sale reported · Built 1970 N49ERHuff NUGGET · S/N 49Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1972 · Protzman Frank W N659WReed Roger A SKYRANGER · S/N SKR1290Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2006 · Reed Roger A N196BWWills E K/Wills B M ZNTH-ZODIAC CH601HDS · S/N 6-1429Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Wills Elbert K N3932HEngineering & Research ERCOUPE 415-CD · S/N 4633Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1947 · Gallagher John C N9151PNorth Star Helicopters R500 · S/N 297Cancelled Sep 6, 2016 · Third renewal notice · Casto Richard DBA N7513Beechcraft G36 · S/N E-3996Cancelled May 21, 2015 · Sale reported, canceled · Built 2013 N880RSSutherland Ron LANCAIR 235 · S/N 88Cancelled May 21, 2015 · Sale reported, canceled · Built 1990 N137MPMooney M20L · S/N 26-0017Cancelled May 13, 2015 · Sale reported, canceled N5367YPiper PA-44-180 · S/N 4496175Cancelled May 13, 2015 · Sale reported, canceled · Built 2003 N774BBeech A35 · S/N D-1784Cancelled May 11, 2015 · Sale reported, canceled · Built 1948 N3271TBanks Theodore JR WOODSTOCK · S/N 100XXCancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1984 · Knoll William C N9SHBeech A36 · S/N E-981Cancelled Dec 2, 2013 · Sale reported · Built 1977 N9PUBeech F90 · S/N LA57Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1980 · R W F Inc N821SMRaytheon A36 · S/N E-3031Cancelled Aug 29, 2013 · Sale reported, canceled · Built 1996 N4929GLackey Royale Ruth QUICKSILVER MX II · S/N 1680Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1983 · Clackey Royale R N6HAAberle Harry L PITTS SPECIAL S1-S · S/N ACA4ACancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1981 · Aberle Yvonne J N1070TMilner Roger W MILNER ROTORWAY EXEC · S/N RW2918Cancelled May 6, 2013 · Registration expired, pending cancellation · Milner Roger W N25904Cessna 152 · S/N 15280846Cancelled Nov 6, 2012 · Exported to Mexico · Built 1977 · North County Aircraft Inc N24963Cessna 152 · S/N 15280474Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1977 · Logue C J DBA N50643Cessna 150J · S/N 15069456Cancelled Aug 10, 2012 · Revoked, canceled · Built 1968 · Smith James A N7411RPiper PA-28-140 · S/N 28-21928Cancelled Aug 10, 2012 · Registration pending, canceled · Built 1966 N995CBLindner Robert LANCAIR LEGACY · S/N L2K-142Cancelled Jun 11, 2010 · Exported to Australia · Built 2001 · Lindner Robert J N9191RBeech A45 · S/N G-274Cancelled Sep 15, 2009 · Registration revoked · Built 1953 · Pribble Paul N2094DBeech D35 · S/N D-3439Cancelled Jul 13, 2009 · Registration revoked · Built 1953 · Boulter Edward Francis N1396JRockwell International 112A · S/N 396Cancelled May 6, 2009 · Registration revoked · Built 1975 · Frederick E Jackson Md Inc N4195ZHughes 369HS · S/N 0684SCancelled Oct 15, 2008 · Triennial form not returned · Built 1974 · Scw Contracting Corp N23MBBellanca 17-30A · S/N 74-30719Cancelled Apr 2, 2004 · Triennial form not returned · Built 1974 · Black Milton E N40VFMooney M20J · S/N 24-3315Cancelled May 20, 2002 · Built 1993 · Beamer William H Trustee N3930MUnknown model · S/N 4633Cancelled Jul 13, 1993 · Gallagher John C N7877ACessna 180 · S/N 32774Cancelled Mar 1, 1971 · Snow Irrigation Engineering

Back to Fallbrook, CA